Close-up of a microscope

How I tackle disaster recovery

One of my special interests as an autistic person is understanding mechanical components of a computer, both analog and digital. In the olden days, we had devices known as hard drives which used one or more spinning disks and a read/write head that would move over the surface with a buffer of air so thin
-> Continue reading How I tackle disaster recovery

network cables coming out the back of a switch

T-SQL Tuesday Retrospective #009: Beach Time

(If you’d like to read my other T-SQL Tuesday Retrospective posts, click here.) In August 2010, Jason Brimhall (blog | Twitter) invited us to discuss preparing for vacations: “Write about what you have done to be able to get a break from the job. Beach time is usually vacation time, but is really anything that
-> Continue reading T-SQL Tuesday Retrospective #009: Beach Time

macro shot of stainless steel padlock

Picking up the pieces after the DBA has left: taking ownership of a SQL Server instance

WARNING: This post contains information that can get you fired if you use it without express written permission. In some jurisdictions it might get you jail time as well. Let’s assume you are a consultant, and a customer has called you in a panic because they have lost access to their production environment. Let’s assume
-> Continue reading Picking up the pieces after the DBA has left: taking ownership of a SQL Server instance

person driving car during night

On the continuity of business

With entire countries shutting their borders, and people being forced to stay home and isolate themselves for as long as possible while health departments ramp up to handle this pandemic, the question of business continuity has been raised. This is where our training as data professionals comes in. The classic DBA must make sure that
-> Continue reading On the continuity of business

A desktop computer destroyed by fire

Disaster recovery, tools edition

I just completed a chapter for another book where I spoke about the Recovery Point Objective (how much data you are prepared to lose) and Recovery Time Objective (how long you have to bring your environment up again) after a disaster, and while I never get tired of repeating myself, that’s SQL Server. What happens
-> Continue reading Disaster recovery, tools edition

PASS logo

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

Using a home-grown Azure Blob Storage solution for SQL Server backups

I’m here for the small organizations, the shops that can’t afford expensive solutions to maintain their environments. I’m here for them because that’s me: the one-person consultancy. I’ve built stuff that’s useful to me, and then made it available for free on GitHub. My first SQL Saturday session, way back in 2015, was the public
-> Continue reading Using a home-grown Azure Blob Storage solution for SQL Server 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?