Tag Archives: disaster recovery

Backup Plans for Data Loss

The British Airways computer failure has been on my mind for a few weeks. It seems like such an epic failure in 2017 from a high public company that many, many people depend on. I still struggle to believe the … Continue reading

Posted in Editorial | Tagged , | Leave a comment

The Need for DRE

“Today’s database professionals must be engineers, not administrators” That’s a quote from an interview at O’Reilly on Database Reliability Engineering. I don’t want to quibble about whether those of us working in technology are engineers in name or not, but … Continue reading

Posted in Editorial | Tagged , , | Leave a comment

A Bad First Day

I’ve started quite a few jobs throughout my career. In college, I worked in a variety of restaurants, changing employers at the start of every summer and again at the start of the school year. At some of those positions, … Continue reading

Posted in Uncategorized | Tagged | Leave a comment

Big Power Issues

Recently British Airways had a massive computer failure and had to cancel hundreds of flights across a couple days. This was a large disruption for travel as tens of thousands of passengers were stranded around the world. In addition to … Continue reading

Posted in Editorial | Tagged | Leave a comment

The Quiet Zone

I’ve been in a data center when most servers turned off. I’ve actually heard dozens of systems powered off quickly, and it’s a strange sound. You become so used to the white noise of numerous fans that having them turned … Continue reading

Posted in Editorial | Tagged ,

Data Loss or Downtime

This editorial was originally published on Jan 7, 2011. It is being re-run as Steve is on vacation. I was watching Kimberly Tripp of SQL Skills talk recently about VLDB disasters and how to recover from them. One of the first things … Continue reading

Posted in Editorial | Tagged

Two Days Off

I almost couldn’t believe this when I saw the article. The Verizon Cloud is shutting down for 48 hours. Apparently they have maintenance scheduled for this weekend and notified their customers that their virtual machines will be shut down early Saturday … Continue reading

Posted in Editorial | Tagged ,

Test Your Situation

I gave a talk on Transparent Data Encryption (TDE) recently and a number of people in the audience were using the feature. However when I asked how many of them had restored a TDE database, not all hands remained up. … Continue reading

Posted in Editorial | Tagged , , ,

Drop and Recreate

Those of you that manage replicated environments have learned to have one thing handy: a script that recreates your replicated publishers, distributors, and subscribers. I was reminded of my past needs for those scripts recently when I saw this post on … Continue reading

Posted in Editorial | Tagged , ,

A SQLServerCentral DR Event

We had a disaster at SQLServerCentral this past weekend. It wasn’t a big disaster, but it was an event that required a restore of data. An Administrative Error On Saturday, I was attending SQL Saturday #331 in Denver. In between … Continue reading

Posted in Blog | Tagged , ,