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 »
Corruption
Just one more thing, an essay on troubleshooting
Over the weekend I watched — for the first time in my life — an episode of the long-running ABC and NBC police show Columbo,… Read More »Just one more thing, an essay on troubleshooting
Infrastructure matters, even in the Cloud
I am still amused by terminology in the Information Technology field. Words like “Kubernetes,” “containers,” and the BASIC keywords PEEK and POKE, all bring a… Read More »Infrastructure matters, even in the Cloud
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… Read More »Public Service Announcement: check your backup notifications
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
SQL Server 2017 Administration Inside Out
For the last five months or so, I have been helping some really smart people put words on paper, both the physical and electronic kind,… Read More »SQL Server 2017 Administration Inside Out
Repair a Windows Server 2016 installation
This is more for my benefit in the future, but hopefully it can help someone else too. We recently had problems with a development server… Read More »Repair a Windows Server 2016 installation
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
This is how I recovered from a catastrophic failure
I was fresh off the boat* from South Africa, working in a small computer store in an equally small town in Saskatchewan. Five days a… Read More »This is how I recovered from a catastrophic failure
Database Corruption Challenge
Steve Stedman has been running a contest over on his site, the Database Corruption Challenge, which I discovered last week quite by chance through Twitter.… Read More »Database Corruption Challenge