SQL Server Practice Test – Online

Folks,

I have found a very good link of SQL Server Practice Test which is an online test….

I thought why not to share, Please follow the below link..

http://www.sql-server-helper.com/free-test/default.aspx

Thanks

Advertisements

How to Change Server Name in SQL server

How to use ‘SP_addserver’ and ‘SP_dropserver’

We often use to change server name for SQL server 2000, 2005 or 2008 instance when we migrate sql instance from one place to another or while changing the name of the computer running the SQL Server.

We have to perform following steps to ensure that SQL Server also uses the new updated servername. Continue reading

Professional Certification for SQL Server DBAs

Why get certified?

Earning a Microsoft Certification helps validate your proven experience and knowledge in using Microsoft products and solutions. Designed to be relevant in today’s rapidly changing IT marketplace, Microsoft Certifications help you use evolving technologies, fine-tune your troubleshooting skills, and improve your job satisfaction.

Whether you are new to technology, changing jobs, or a seasoned IT professional, earning a certification demonstrates to customers, peers, and employers that you are committed to advancing your skills and taking on greater challenges. In addition, certification provides you with access to exclusive Microsoft Certified Professional (MCP) resources and benefits, including opportunities to connect with a vast, global network of MCPs.

Database Administrator IT Professional

This certification is designed for DBA Administrators, and includes three required exams:

  • Microsoft SQL Server 2005 – Implementation and Maintenance (70-431)
  • Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005 (70-444)
  • Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005 (70-444)

Database Developer IT Professional

This certification is designed for DBAs who focus on database development, and includes three required exams:

  • Microsoft SQL Server 2005 – Implementation and Maintenance (70-431)
  • Designing Database Solutions by Using Microsoft SQL Server 2005 (70-441)
  • Designing and Optimizing Data Access by Using Microsoft SQL Server 2005 (70-442)

Business Intelligence Developer IT Professional

This certification is designed for DBAs who specialize in Business Intelligence, and includes two required exams:

  • Microsoft SQL Server 2005 Business Intelligence – Implementation and Maintenance (70-445)
  • Designing a Business Intelligence Infrastructure by Using Microsoft SQL Server 2005 (70-446)

SQL Server Security Interview Questions

During the interview I always like to ask below security questions to DBA. I found that sometimes DBAs are not able to answer these questions. Continue reading

SQL Interview Questions and Answers

    Well, here are some questions for you. Hope this helps you prepare for your interview. Wish you all the best in your job hunt! Feel free to email me ‘interview questions’ that you’ve faced. Continue reading