This month’s invitation from Marlon is sure to bring out the war stories as he asks us to share our most memorable SQL Server outage. I enjoy a good war story. But no, this isn’t the time Azure blindsided me, when service accounts were locked, or when I left a transaction open and halted a production system (easily fixed […]
A few weeks ago I demonstrated the simplicity of performing point-in-time database restored in Azure Managed Instance. Whilst that has a lovely front-end, it can be just as easy with a proc call on your traditional SQL instance. Let’s see how to use two open source tools to achieve this simplicity. Back it up Before we […]
One of the benefits which comes with a Managed Instance is having backups taken care of for you. That also includes restores. Particularly useful is a one-click (ish) restore for a specific point in time. Restoring a database is as easy as creating a new database, as its part of the same workflow. From the […]
Andy Brownsword 