Every database holds different business data and has its own recovery needs.  Unfortunately, there is not a single solution for all databases. There are many possibilities and solutions. For each database you are responsible for supporting you should be asking yourself and the business the following questions. Throughout this article, we will be using examples from 3...
Read More About What questions to ask when planning a SQL Server backup strategy »

  As a DBMS SQL Server is a powerful, cost-effective, and simple-to-use DBMS able to service the needs of most small-to-medium size businesses right out-of-the-box without professional management by a DBA.  In fact, a recent survey reported that 45% of IT personnel responsible for managing their company’s SQL Server instances are not trained database administrators instead...
Read More About The Value of Expertise »

  I have two recurring career related nightmares one of which I’ve come to discover is part of the shared consciousness of many DBAs: catastrophic database failure.  Not that we haven’t trained for efficient and timely recovery in preparation for such an event, but that our preparation did not account for Murphy, our nemesis, joining the party with a corrupt backup file. ...
Read More About Nightmares »