sp_RestoreScript 1.6 Release – @Credential Added For Backups In Azure BLOB Storage

Releases seem to be coming out thick and fast at the moment, here's the latest v1.6 revision to sp_restorescript For those of you backing up to Azure BLOB Storage, we've now added a @Credential parameter. You can grab the latest version from our GitHub repo, https://github.com/SQLUndercover/UndercoverToolbox/blob/master/sp_restorescript.sql or for full documentation, visit https://sqlundercover.com/2017/06/29/undercover-toolbox-sp_restorescript-a-painless-way-to-generate-sql-server-database-restore-scripts/

Aug 29, 2019 0

Undercover Catalogue 0.3.0-Auditing and Change Tracking Comes to the Catalogue

We're pleased to announce the release of the Undercover Catalogue 0.3.0. You can grab it from our GitHub page... https://github.com/SQLUndercover/UndercoverToolbox/tree/master/SQLUndercoverCatalogue Installing and Upgrading Full installation and upgrade instructions can be found on the main Catalogue page, https://sqlundercover.com/undercover-catalogue-0-2/ v0.3.0 Brings Auditing to the Catalogue The biggest change that we've introduced to the Catalogue is auditing. All... Continue Reading →

Aug 27, 2019 0

Get All Database Snapshots and Their Parent Databases On A SQL Server

This is going to be a quick post but this morning I was asked the question, 'how can I get the name of all the database snapshots on a SQL Server?'. It was an interesting question so I thought I'd share a quick script to do just that. We're going to need to tap into... Continue Reading →

Aug 15, 2019 0