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
Home »
Backup
Using AzCopy with Batch Files and Task Scheduler
As regular readers of this blog will know, I’m a big fan of AzCopy, especially now that it has a sync option to keep local… Read More »Using AzCopy with Batch Files and Task Scheduler
Accelerated Database Recovery in SQL Server 2019: Choose your own filegroup for the version store
An exciting new feature in SQL Server 2019 is Accelerated Database Recovery (ADR). Resulting from a combination of magic beans and smart software developers (I… Read More »Accelerated Database Recovery in SQL Server 2019: Choose your own filegroup for the version store
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… Read More »The importance of backups
SQL Server 2008 and 2008 R2 is end of life on 9 July 2019
Next month, Microsoft is ending five years of extended support on SQL Server 2008 and SQL Server 2008 R2. This follows five years of mainstream… Read More »SQL Server 2008 and 2008 R2 is end of life on 9 July 2019
My IT department installed an antivirus with SQL Server
Time for another short blog post, and this one combines two topics I am very passionate about: security, and SQL Server performance. Let’s start by… Read More »My IT department installed an antivirus with SQL Server
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… Read More »Using a home-grown Azure Blob Storage solution for SQL Server backups
AzCopy finally gets a sync option, and all the world rejoices
I consider Blob Storage to be the gateway drug to Azure, because it’s a really easy way to get going with offsite backups. One of… Read More »AzCopy finally gets a sync option, and all the world rejoices
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
Do you even PowerShell, bro? An ode to dbatools and dbachecks.
Shall I compare thee to Management Studio? Thou art more scriptable and consistent. Those out-of-memory errors do tend to lose hours of work. And I… Read More »Do you even PowerShell, bro? An ode to dbatools and dbachecks.
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
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
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… Read More »What is a good Disaster Recovery Plan?