Tag Archives: disaster recovery

Reading Through the Logs

Posted on May 8, 2018 by

Have you ever tried to read a transaction log? I mean used a query against fn_dblog() to read data and try to reconstruct what happened with a transaction or a series of transactions? It’s a cumbersome process and takes a … Continue reading →

Posted in Editorial | Tagged | Leave a comment

The Reliable DBA

Posted on March 13, 2018 by

Many of us would consider ourselves to be reliable at work. Our employers count on us, co-workers may assume we’re handling certain tasks, and it’s human nature to think that we are meeting our obligations and responsibilities. Maybe not 100% … Continue reading →

Posted in Editorial | Tagged , | Leave a comment

Cloud Safe

Posted on February 13, 2018 by

I saw a question recently from an individual that was trying to decide if it made sense to move their databases to the cloud. In this case, management wanted to move, but the technical staff had concerns about Disaster Recovery … Continue reading →

Posted in Editorial | Tagged ,

A Double Dose of Trouble

Posted on October 13, 2017 by

It’s Friday the 13th, during the month of October. Halloween, a strange holiday associated with horrible events, and Friday the 13th, a bad luck day, are happening this month. Both are associated with horror movies, implying that this isn’t necessarily a good month for … Continue reading →

Posted in Editorial | Tagged

Backup Plans for Data Loss

Posted on June 22, 2017 by

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 ,

The Need for DRE

Posted on June 17, 2017 by

“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 , ,

A Bad First Day

Posted on June 14, 2017 by

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

Big Power Issues

Posted on June 5, 2017 by

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

The Quiet Zone

Posted on September 29, 2016 by

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

Posted on July 10, 2015 by

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