Interview with Author on essential SQL

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 – http://www.essentialsql.com/interview-with-jack-vamvas/

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