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[…]

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[…]

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”.[…]

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[…]

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[…]