Speaking at SQLSaturday 725 in Victoria

Victoria is on an island off the coast of Vancouver, British Columbia. The island is wisely called Vancouver Island. It is beautiful there, and I wouldn’t mind retiring there someday. Those of you who listen to my convoluted stories will recall that it was on Vancouver Island that I broke my foot in 2013. Hopefully
-> Continue reading Speaking at SQLSaturday 725 in Victoria

The perils of RAID

Recently, I was asked to assist an organization with getting their data back for a SQL Server that had experienced physical hard drive failure. I asked a lot of questions about the configuration of the data layer, and it came to light that it was a fairly regular setup. SQL Server is virtualised on VMWare,
-> Continue reading The perils of RAID

Post image

Backup Retention Policies

Today’s post is just a bunch of questions, but they are very important questions, all around the main topic of a Backup Retention Policy. How long do you keep backups for every database in your environment (including development, testing, quality assurance and production)? Do you keep backups of system databases? Do you keep backups of system databases
-> Continue reading Backup Retention Policies

Post image

The Transaction Log Is Very Resilient

Last week I wondered whether a log backup chain would survive a database migration. Unsurprisingly, the answer is “yes”. I also asked if a log backup taken on the new instance would be usable on the old instance, if the need arose to fail back to the original environment. Unsurprisingly, the answer is “it depends”.
-> Continue reading The Transaction Log Is Very Resilient

Post image

Career Limiting Moves – Dropping a Table

In this new series, I will share some things that took place early in my career that could have resulted in my looking for new work—but didn’t! This post is also evidence that I haven’t always worked with SQL Server. I used to work with a PeopleSoft implementation partner, sometime last century. One morning I
-> Continue reading Career Limiting Moves – Dropping a Table

Post image

Update to Azure Blob Storage Sync and Restore

Blob Storage Sync tool updated During a SQL Server migration this month, I found some inconsistencies in my Azure Blob Storage Sync tool, so I made several improvements, and fixed an outstanding bug. As you know, it relies on the naming convention provided in Ola Hallengren’s Maintenance Solution and comes in two parts: the AzureBlobStorageSync command-line application, and
-> Continue reading Update to Azure Blob Storage Sync and Restore

Post image

On the importance of good backups

(Originally posted on my personal blog.) I’ve been vocal for some years about the importance of backups, and I have zero sympathy for anyone who does not have good backups*. This comes with (very) painful experience: a few years ago, during the migration of data from several drives to my new computer at the time,
-> Continue reading On the importance of good backups