The importance of backups

I have been selected to present a second session for the PASS Summit in November this year. I wrote a few weeks ago about the Linux Learning Path and being a part of that, so I was certainly not expecting this. My second topic is about backing up, testing, and restoring SQL Server backups if
-> Continue reading The importance of backups

fire in a bucket

Public Service Announcement: check your backup notifications

The Azure cloud platform lost a data centre for a number of hours recently due to inclement weather. This affected many customers — including Microsoft’s own services — for almost an entire day. Given that the cloud is ostensibly designed to mitigate downtime by way of distributing workloads across multiple redundant systems, this could have
-> Continue reading Public Service Announcement: check your backup notifications

Post image

What is a good Disaster Recovery Plan?

During a Q&A session I hosted at our local Calgary SQL Server User Group last month, one of the attendees mentioned an interview question he’d had and wanted to hear my thoughts. How would you design a disaster recovery solution for a 1 TB database, using Simple Recovery Model? Replication is not permitted, and switching
-> Continue reading What is a good Disaster Recovery Plan?

Post image

On Best Practices

We hear a lot about “best practice”, but what does it mean in the context of SQL Server? Wikipedia describes best practice as follows: A best practice is a method or technique that has been generally accepted as superior to any alternatives because it produces results that are superior to those achieved by other means
-> Continue reading On Best Practices