• Pingback: SQL Server Essentials – Part 1: The Database Administrator’s Primary Responsibility | John Sansom - SQL Server DBA in the UK()

  • Pingback: DBA Survival Skills – Think Defensively | John Sansom - SQL Server DBA in the UK()

  • Pingback: Too Many Disasters To Choose From (T-SQLTuesday)()

  • Tahir

    Excellent article.
    Concise and to the point.

    Thanks John.

  • Darren McCarthy


    I am pursuing a CIS degree, and came upon your site and found your information to be very interesting reading. Thanks for all of your knowledge and input.

    Darren McCarthy

  • Pingback: Simplify Your DBCC CHECKDB Output - John Sansom SQL Server DBA in the UK()

  • Vivien

    Hey John,

    Thanks for this. Must-read for those who are just starting or thinking of starting a career in the world of DBA. Your article is easy to understand and to the point.

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

      Thanks Vivien, glad you enjoyed it.

  • clare

    great article

  • Santhakumar

    Really a Great article for sql beginners.. Very easily understandable.. Thanks John

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

      Thanks, glad you enjoyed it!

  • Swati Madan

    Really nice and easily understandable!!

  • Nic Neufeld

    I would add a few points garnered from my own experience. First, your business’s expectations of RPO are critical to be aware of. In a good-sized multi-server environment with lots of diverse databases (we’re clocking in just under 1400 databases on 80 something instances now), there are a lot of databases that are non-transactional in nature that simple recovery model is more appropriate for. When we consider our non-production tiers, none of which require anything more than full backups, our general approach is to start with Simple and switch to Full when the business needs it, which is mostly our transactional databases in the production tier.

    Full Recovery Model is a twin-edged sword, also. If improperly implemented (it is the default setting for Model, so very often people create new databases in Full Recovery without thinking about the ramifications) without also configuring regular transaction log backups, you are sitting on a timebomb. I’ve come into more than one company where I’ve seen this issue…the transaction log just grows and grows until it fills the drive. And plenty of people don’t create a separate volume for the transaction log file, too, so you can have a pretty ugly potential failure, as if your database shutting down wasn’t ugly enough. Even if you do have transaction log backups going, we’ve seen some funny issues…for instance, when we had a massive SSIS job running against a server, and we had improved our storage speed using SSDs, we actually filled up our transaction log drive in between the 15 minute increments for the transaction log backups! An amusing instance of fixing one thing (storage latency) creating a new, unexpected problem.

    My point being that full recovery model has some things people should be aware of…chiefly, whenever you set something to Full, make doubly sure you are backing up the transaction log!! And talk with the business about RPO…if your expectations and theirs aren’t in sync that can make for an unpleasant post-failure conversation… :D

  • Med

    I just want to say a big thanks because i have finally found what i was hoping for. Somebody who can give me the confidence and trust in becoming a Database Administrator. I think i have found that person and it’s you. Good articles , straight and simple. Thanks

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

      Thank you for your kind words. Delighted you found the blog. You should check out the Community Forum too. It’s packed full of ambitious Data Professionals sharing and learning together.

  • Mahesh

    Awesome article

  • suresh

    Hey John,
    Its really excellent and easy to understandable article.

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

      Suresh – Glad you enjoyed the post. Thanks for your comments!

  • oriyomiade

    Great article.
    Please i joined this forum today but i am interested in studying and getting trained as SQL DBA. I’m studying towards BSC Informatics. I currently working as IT technicain and have some IT Support background for 6 years+ mainly in netwroking with cerfications(A+, CCNA, MCTIP) but i want to change career and pursue DBA because i discover this is where my passion lies, proffering solution, consistency, managing data etc.
    Though my study has being interesting so far, but it seem difficult to get along or understand especially if you are studying on your own. The DBA in my office offered to train me to be his assistant or Junior DBA and he gave me books to study SQL 2012(70-462 and 461) busy with the 462 and finding it interesting but the truth is am strugling to memorise most Alter statement but was able to practise on my personal computer.
    Is there any videos or material that can help me develop or even media/TV channel/programme.
    How can i grow and become very good in SQL DB Admin and be above average. I have so much passion for this and i don’t want it to go down for any reason. As i will also be dealing with data bases in my office as assigned by the senior DBA as soon as i get conversant with my practises of SQL 2012.
    Also it will help my studies because database will be part of my module from year 3.
    Your advice, guidiance and onlinie mentoring will be highly appreciated.