Tag Archives: disaster recovery

Reading Through the Logs

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

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

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

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

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

“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

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

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

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