Remote Storage Sync and Restore updated
Recently, I presented my “Back up and Restore your Database with Azure Blob Storage” session to the Bellingham PASS Chapter. There are two components to… Read More »Remote Storage Sync and Restore updated
Interview Questions for a SQL Server DBA
When I’m interviewing a SQL Server DBA, I have three questions that I always ask. My favourite interview question is this: “What is the difference… Read More »Interview Questions for a SQL Server DBA
Planning matters
It’s the 2016 PASS Summit at the end of this month, and I’ll be attending for my third year. Because I’m a glutton for punishment,… Read More »Planning matters
PSA: Check Your Backups
This post comes to you from the Spanish countryside. I travel a lot these days, sometimes even for work. The best part about travelling, apart… Read More »PSA: Check Your Backups
AzCopy 101 – Copying SQL Server backup files to Azure Blob Storage
SQL Server 2016, released last month, now lets us back up our database files to two locations simultaneously. This is very good news if we’re running… Read More »AzCopy 101 – Copying SQL Server backup files to Azure Blob Storage
The Resilience of the Log Backup Chain
Much has been written about the log backup chain in SQL Server, where we are able to restore a database to a point in time using… Read More »The Resilience of the Log Backup Chain
Expiration Date on Database Backups
What does the expiration date mean on SQL Server database backups? In SQL Server Management Studio, there’s an option in the Back Up Database wizard… Read More »Expiration Date on Database Backups
On Best Practices
We hear a lot about “best practice”, but what does it mean in the context of SQL Server? Wikipedia describes best practice as follows: A… Read More »On Best Practices
Compressed and Encrypted Backups on the Cheap
We back up our databases regularly. We store them on a secure network location so that if the database drive fails, we can still satisfy… Read More »Compressed and Encrypted Backups on the Cheap
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
Basic Availability Groups in SQL Server 2016
One of the new features in SQL Server 2016 Standard Edition, which may appeal to users of the deprecated Database Mirroring feature, is Basic Availability… Read More »Basic Availability Groups in SQL Server 2016
Announcing Azure Blob Storage Sync and Restore
Yesterday at SQLSaturday #407 in Vancouver, I announced availability of a free tool to synchronise and restore your SQL Server backups using Azure Blob Storage.… Read More »Announcing Azure Blob Storage Sync and Restore
Pre-Announcement Announcement
On Saturday, 27 June 2015, I will be presenting at SQLSaturday #407 in Vancouver BC. The session is titled “Restoring a SQL Server Database from… Read More »Pre-Announcement Announcement
SQLSaturday #407 in Vancouver
I have been selected to speak at SQLSaturday #407 in Vancouver, on 27 June 2015. My topic is about restoring SQL Server backups from Azure… Read More »SQLSaturday #407 in Vancouver
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
- « Previous
- 1
- 2