• Home
  • Contact

John Sansom

SQL Server DBA Blog

  • About
    • The Blog
    • John Sansom
    • Contact
  • Ebook
  • Archives
    • Start Here
    • Popular Posts
    • All Posts
    • SFTW
  • Becoming a DBA
    • What it’s Really Like
    • Interview Tips
    • Certification
    • FAQ
  • Books
  • Resources
    • Blog Tools and Technology
    • UK Events Schedule
    • References & Resource Lists
  • Subscribe

DBA Survival Skills – Think Defensively

April 12, 2010 by John Sansom 15 Comments

No matter how much of a Super Hero DBA you consider yourself to be, I can guarantee you that there that there will come a time when you have to deal with either a disaster scenario or some form of mistake. Interestingly however, it is what happens next that separates the Pro’s from everyone else.

Things Can and Will Go Wrong

So faced with the absolute certainty that things can and will go wrong at some point, what can you do about it?

My advice is to arm yourself with this knowledge. If you know that something will go wrong at some point then you can prepare what you plan to do about it ahead of time so that you are not caught out unexpectedly.

Adopting a Defensive Mindset

Hume Castle Wall

Have You Covered all the Angles?

Your database environments are business assets and in your role as a DBA it is your responsibility to guard and protect them.

Before you implement any administrative tasks whether it be deploying a set of database patches to your environment, modifying table data or creating new objects, whatever changes you plan to make, I advise you to always adopt a doomsayer’s frame of mind before carrying out the implementation.

Ask yourself:

  • What is the worst that could happen?
  • What are the things that could go wrong?
  • Have I covered myself adequately?

Preparation is the Key

Having identified possible risks for a given scenario you should then plan how you can either avoid them completely or what you will do if they come to bare.

To give you an idea of the type of preparation you may wish to undertake you could plan how you might:

  • Avoid risk completely
    • Do you really need to make this change i.e. does it have to be done?
  • Minimise risks where possible
    • Backup your databases
    • Leverage database Snapshots
    • Ensure adequate testing has been performed
    • Perform certain types of changes during maintenance windows or out of business hours in order to minimize any possible impact there could be.
  • Devise risk response plans
    • Outline a plan of the steps that you will take in the event of a specific risk or disaster scenario occurring.
    • Test the plan.

Start Thinking Defensively Today

Adopting defensive thinking is the first step to ensuring that you are ready to fight back against disaster scenarios and eventualities outside of your control.

Start thinking defensively today, what’s the worst that could happen?

Similar Posts

  • SQL Server Essentials: Part 1 – The Database Administrator’s Primary Responsibility
  • SQL Server Essentials: Part 2 – Why you should be using the FULL recover model
  • SQL Server Disaster Recover Planning: Getting started…

Filed Under: Disaster Recovery, SQLServerCentral Syndication, SQLServerPedia Syndication Tagged With: Backups, Planning, Thinking Defensively

About John Sansom

I’m a Microsoft Certified Master(MCM) of SQL Server. I’ve been working with database technology in a variety of flavors for over fifteen years. I absolutely love what I do and genuinely feel privileged to be a part of our tremendous technology community. Got a question about SQL Server or being a DBA? Ask me!

Popular Articles

  • Top 10 Free SQL Server Tools
  • Performing fast SQL Server delete operations
  • How to identify the most costly SQL Server queries using DMV’s
  • Top 10 Junior DBA Interview Tips
  • The Database Administrator’s Primary Responsibility
  • Your Road to Becoming a DBA: Laying a Strong Foundation
  • Top 5 SQL Forums
  • SQL Server Memory Configuration, Determining MemToLeave Settings
  • Script SQL Server Agent Jobs Using PowerShell
  • Using sys.dm_os_ring_buffers to Troubleshoot Connectivity Issues

Categories

  • Administration (38)
  • Blogging (8)
  • Customer Service (5)
  • Disaster Recovery (5)
  • DMVs (4)
  • Index Optimisation (6)
  • Interviews (1)
  • Link Posts (243)
  • Memory (2)
  • Performance Tuning (15)
  • Professional Development (70)
  • Reporting Services (5)
  • Reviews (1)
  • SQL Server Community (144)
  • SQL Server Tips (11)
  • SQLServerCentral Syndication (112)
  • SQLServerPedia Syndication (116)
  • Tools (7)

Copyright © 2023 · Santech Solutions Limited · Powered by the Genesis Framework · Privacy Policy