This is something that I've seen pop up a couple of times on various forums recently, how can we export the results of an XEvent session. So I thought I'd answer the question here. It's actually a very simple thing to do in SSMS, although the option is not always easy to spot. When we... Continue Reading →
SQL Server has given us the option to backup our databases directly to Azure BLOB storage for a while now but it's not something that I've had all that much call to use until recently. So this is just going to be a quick walk through on how you can backup your on premise SQL... Continue Reading →
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/
Unless you've been living under a rock for the last few years I'm sure that you've all heard of that mystical world that is Azure and some of us may even know people who have visited that land but how do we get there ourselves? Well don't worry my fair database folk, there's no need... Continue Reading →
SQL Undercover 