SQL Server Interview Questions and Answers

This page is for all the SQL Server users who would like to enhance their Interview knowledge and for those who are preparing for a SQL Server DBA or SQL Developer or BI Developer Interview in the near future. The idea behind this page is not to encourage you to cram these interview question and get a SQL Server job the easiest possible way, rather to answer all those readers who have been requesting me to list SQL Server Interview Questions to assist their preparation for the interview and know what to expect in such Interviews.

From time to time, new content is added, the following stats show this…

  • 31 New DBA Question and Answers are added since December 2011
  • 3 New DEV Question and Answers are added since December 2011
  • 8 New BI Question and Answers are added since December 2011

Finally, I would recommend you to go through SQL Server TIDBITS section also, as they cover parts of an answer.

Do you like this site? Like our FB page @ Facebook.com\LearnSQLWithBru so that, you know when there is a new blog post.

- Bru Medishetty

SQL Server DBA Interview Questions and Answers

SQL Server Developer Interview Questions and Answers

SQL Server Business Intelligence Dev & DBA Interview Questions and Answers

  • Siddh2977

    I am totally new in Sql server. I know sql server but I dont have any experience, so I dont know real time job as developer/DBA.
    I am looking for question answer with example and what kind of project u can do as developer/DBA.
    I want to know actual work as developer/DBA, so I can make some project example in my interview.

  • http://www.LearnSQLWithBru.com Bru Medishetty

    Hi Siddh2977,

    Thanks for your feedback and suggestion. I shall definitely update more questions (technical) that are asked in SQL Server Developer Interviews in the next few days..

  • http://www.LearnSQLWithBru.com Bru Medishetty

    @Siddh2977,

    As you have mentioned, that you have not worked on SQL Server before, to gain experience on SQL Server, I would recommend you to start a demo project on your own. Take an example organization (that your friends work at) and think in terms of a Sales project that company might do. Start building a demo database and populate with tables and data (that you can imagine) and it will lead you up for a good demo database that you can start working on….