Database disasters happen from time to time. I have a method that allows you and your business to survive any database disaster. Have backups. This isn’t rocket surgery. You are only going to be able to fully recover from any disaster to the point of your last good backup. No backups mean you can’t recover. … Read more
It’s going on midnight here so I wanted to share some advice I have for anyone on the overnight shift: You *do* have backups, right?
Last week I had the honor of presenting at TechEd Europe a session titled “Deploying Microsoft SQL Server 2012 Using Windows Server Core“. Presenting that session gave me the opportunity to learn about administering SQL server using PowerShell, specifically how to administer an instance of SQL Server running on Server Core (PRO TIP: it’s the … Read more
I’ve written before about how much I love looking for outliers. One example of this can be found in the post I did on the sysjobhistory table. Recently I was asked to put together some code to find out which backups were “running long”. Of course my first question was trying to define what was … Read more
Every great DBA I know is both driven AND lazy. They are driven to be as efficient as possible, so they can do less work. It’s a wonderful pair of personality traits to have as a DBA. The unfortunate part is that the more driven they are, the more efficient and lazier they get, which … Read more
