Subscribe to RSS feed  Follow @jackvamvas - Twitter

*Use the Comments section for questions Links


SQL Server DBA Jobs

Interview with Author on essential SQL

23 December,2014 by Tom Collins

Kris Wenzel is a SQL geek. He’s written some excellent guides to learning SQL . The guides are notable for the plain English used.

Kris started a series of interviews on his site. He interviews individuals who are involved in the SQL community. He asked me the following  five questions.

Questions during the SQL Server DBA Interview

  1. What is some advice you would give someone that wanted to become a DBA?
  2. I noticed that you like to optimize databases.  What are some tools and techniques a junior DBA can use to troubleshoot a poorly performing database?  As a follow-on, are the any books or online resources you recommend they can use to learn more about optimization?
  3. SQLServer has added many new features over the years.  Do you feel these newer features, some which make it easier to write SQL, are less efficient that doing it the long way?  For instance, would you use the INTERSECT operator for convenience over the INNER JOIN method for speed?
  4. What is one of the biggest frustrations you see junior DBA have with SQLServer?  Do you have any suggestions to help them overcome these?
  5. Do you have any advice for people that want to start a career as a DBA?  For instance, are certifications a must?

It was a pleasure answering the questions . Read the answers on essential SQL –


Read More on how to grow as a DBA

Top 10 DBA Tips to develop your competitive edge

DBA Resume FAQ

DBA Ignorance , complacency and arrogance experiment


Author: Tom Collins (


Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.


Post a comment on Interview with Author on essential SQL | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer