• Pingback: 10 Character Traits of Outstanding DBA’s | John Sansom - SQL Server DBA in the UK()

  • Pingback: Seven Reasons You Should Attend SQLBits 7 | John Sansom - SQL Server DBA in the UK()

  • Pingback: The Best Database Administrators Automate Everything | John Sansom - SQL Server DBA in the UK()

  • Pingback: SQL Server Memory Configuration and MemToLeave | John Sansom - SQL Server DBA in the UK()

  • Laavanya

    Thanks a lot for all the information! I had been searching for just this.

  • Danny

    its really good information what i looking for to start as Jr DBA.

    • http://www.johnsansom.com John Sansom

      Hi Danny, delighted you found it helpful. Thanks for your comments!

  • Pingback: Your Road to Becoming a DBA: Getting Organised()

  • Aga

    I would like to thanks the author of the interview tips. Thanks a lot. It helps much

    • http://www.johnsansom.com John Sansom

      Hi Aga, thanks for your comments! I’m glad you found the post helpful.


    Thanks for guidence

  • sreenivas

    Thanks for guidence

    • http://www.johnsansom.com John Sansom

      You’re welcome, glad you enjoyed the post.

  • Pingback: Your Top 10 Posts of the Year()

  • Frank P

    Hi John,
    Thanks for the interview tips. I was looking forward to this kind of information.

    This is my story:
    I’ve been working in support for the last 3 years and as a Microsoft Sys Admin for the last one.
    I have an interview tomorrow for a Jr DBA position and although I don’t have any experience with DB other than connecting specific applications with the SQL Servers I was shortlisted due to my sysadmin background.

    I will try to leverage my existing skills in a way to transfer them into the DBA position. This post and your blog was awesome for this purpose.

    Thanks a lot.

    • http://www.johnsansom.com John Sansom

      Hi Frank, glad you enjoyed the post sir.

      May I suggest that you also attend your interview armed with a plan for how you might acquire/develop the skills you envisage needing for role, in addition to any training provided on the job. This will demonstrate your initiative and determination to succeed.

      Best of luck!

  • http://fixyourserver.com Rob

    This is a fantastic blog and a largely beneficial source of information. I must say, one minor pet peeve, if the links would open in new tabs, that would be awesome. All the articles link to each other and I found myself sort of lost.

    Thank you for all of the information. I feel like I have a base to begin with now in my SQL career.

    • http://www.johnsansom.com John Sansom

      Cheers Rob, glad you are enjoying the site my good chap.

      An interesting suggestion about external links. It is something that I already do for the weekly link posts (SFTW) and I certainly see how it could also benefit external references.

  • Gigi

    Hi John,
    I just left a internal data analyst position a year ago because I wanted to try something new. This journey however, reaffirmed how much I enjoy being data person and I want to go to school for it. I have a BA in Marketing and a MA in counseling. Like you mentioned in one of your webpage. Everything I know about SQL and databases are experience based and self taught. I don’t have formal schooling. I would like to go for certification however, I don’t think we have this kind of certification offered here. The book that I’m using is Oracle SQL and SQL Server. It has some PL/SQL and some exercise lessons but since I am a MAC user. Access to the lessons have been limited for me. I’m considering investing on a PC to help practice. Can you offer any advise? As far as certifications goes or other related topics that you might find helpful in my situation.
    Thanks in advance.

  • Spirit

    I have an associate degree in database management and soon I am going to have an interview with big company for a Junior SQL server DBA position. Any advise for my coming interview?

    • http://www.johnsansom.com John Sansom

      One tip I would offer is to practice interview scenarios with a friend before-hand. They may not be able to challenge you with technical questions but they could certainly help with the “stock” interview type questions, “What are your strengths and weaknesses?”, “Why do you want the role/job?”, “What makes you the best candidate for the opportunity?” etc.

  • Swathi

    Hi John, Thanks very much for the helpful tips.

  • Matthews

    Wow, thanks for the great articles John, you are a lecture I’ve been hoping to find somewhere out there. Well I’m a third year Networking student, and I’ve done DB Administration as part of my diploma, and would like to get certified for it.. Now the question I keep asking myself is whether or not the combination of my diploma, the certificates and the “Work Integrated Learning” projects we’ve been doing at my college be enough to score me a jnr DBA interview? Thanks in advance for your answer

  • Amit

    Thanks John, For the articles, As DBA can you give us, some DBA tips which are more important and frequently in use.

    • http://www.johnsansom.com John Sansom

      Hi Amit, what sort of tips are you interested in sir?

  • sanjeev

    sir ,i am .net developer i have 1 year experience ,i knowlede of ssis,ssas,ssrs so i ask one question i am confuse about that which line is good for me .net or msbi ,if i learn logshipping ,mirroring,repication ,backup.than it is profitable me.or not please give me suggestion

    • http://www.johnsansom.com John Sansom

      Sanjeev, great question sir!

      It really depends on what the requirements are of the role that you are interested in. Reason being that the skills required for a “BI Professional” in one company will likely differ to those required by another. With this in mind, I encourage people to maintain as wide breadth of understanding as they possible can and to then focus in on a few areas of specialization, such as performance tuning for a DBA. By having a wide reach, you then know “enough” about other areas so that you can dive deeper when the need arises.

    • sanjeev

      thank you sir ,I am more interest in msbi leaning but not the company work experience i am good in ssrs and ssas with mdx so ,i want to move these msbi area ,that’s possible .or not ..

    • Thomas

      Thanks! I found this very helpful.

  • http://tipswell.com Gaurav Garg

    Really great tips. Thanks for providing this information.

    I want to know that how can i improve myself as a DBA at Home.

    • http://www.johnsansom.com John Sansom

      Gaurav – delighted you found the post helpful sir. Take a look at my post Being an Effective DBA Remotely for some ideas on how remote workers can raise their game.

  • Pingback: The Year in Numbers 2013 • John Sansom()

  • pankaj

    Hello john….
    Your blog is awesome….. Sir i have a one question that i just cleared my b.tech and i want ti be a DBA but confused how to prepared from the starting. Plz sir guide me i m vry thankful to u.

    • http://www.johnsansom.com John Sansom

      Pankaj – Delighted to hear that you are enjoying the blog. That’s a great question. The How To Become a SQL Server DBA area has a wealth of information that I think you will find helpful. In particular the post series Your Road To Becoming a DBA looks at how ways an aspiring Data Professional can get started.

  • Guest

    Nowadays, I am learning SQL Server course. When I have free time, I read ebook about SQL server but I don’t know what ebook should I need to read ? please tell me ! thank you

  • Guest

    Nowadays, I am learning SQL Server course. When I have free time, I read ebook about SQL server but I don’t know what ebook should I read ? please tell me ! thank you

  • Renielle

    Thanks soo much!
    I DO want to become a Dba. I have the studies but no practice. Im also looking for a sponsorship in the US to work for, if anyone has information about needing a DBA Jr. I’ll be very grateful.

    • http://www.johnsansom.com John Sansom

      Concentrate on gaining experience first in your local economy, before looking for international opportunities. You have to be able to clearly demonstrate your value to employers, if you expect them to invest in you.

  • Hanuman

    wow! what an information you just provided here.. It is much helpful for the Junior DBA’s like me.. I salute you Mr. John

  • ST Pillai

    Hi John,
    Am a DB2 DBA on Zos and LUW…thinking of learning SQL Server Administration ,to surbive in long term..what do you think my chances are of getting there(becoming SQL DBA) and with self learning is it possible/simple/tough…your valuable opinion please…anty links to get started

    • http://www.johnsansom.com/ John Sansom

      You should choose to learn SQL Server because you are inspired to do so not because you feel you have to in order to just get by in your career. If you’re passionate about what you choose to pursue in life, you’ll find you can go much farther than what you originally thought possible. Successful Data Professionals all invest a significant amount of their time and effort to their studies. I’d encourage you to do the same. Good luck out there!

  • Pruthiviraj.medicharla

    Than q very much sir and giving lot information