Don’t run CHKDSK while SQL Server is running
On behalf of every database administrator everywhere, I implore you not to run CHKDSK on a system that has a live database installed and running.… Read More »Don’t run CHKDSK while SQL Server is running
Home »
Data Recovery
Data is not immutable
Information — in the form of data — usually stored as binary 1s and 0s in an electronic data store, is not immutable. Even the… Read More »Data is not immutable
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… Read More »How I tackle disaster recovery
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… Read More »On the continuity of business
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… Read More »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… Read More »The perils of RAID
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… Read More »Backup Retention Policies
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… Read More »The Transaction Log Is Very Resilient
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… Read More »Career Limiting Moves – Dropping a Table
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… Read More »Update to Azure Blob Storage Sync and Restore
On the importance of good backups
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… Read More »On the importance of good backups