sp_RestoreScript 1.8 Now Released
It looks like there was a bug lurking in sp_RestoreScript that was causing the wrong ALTER DATABASE command to be generated when using @SingleUser and a WITH MOVE parameter....
2020-11-23
50 reads
SQL Undercover
Undercover Academy – SQL Server Backup and Recovery – Module 1: Taking and Restoring a Backup
Welcome along to the first module in our Undercover Academy’s SQL Server Backup and Recovery course. In this module we’re going to look at how to take and restore...
2020-10-07 (first published: 2020-09-30)
339 reads
sp_RestoreScript 1.7 Released
sp_RestoreScript 1.7 has been released. For information and documentation please visit https://sqlundercover.com/2017/06/29/undercover-toolbox-sp_restorescript-a-painless-way-to-generate-sql-server-database-restore-scripts/ Changes in 1.7 New Parameters @IncludeCopyOnly – 1 – Copy only backups are included0 – Copy only...
2020-09-29
184 reads
Merry-Go-Round or Advanced Scan
The merry-go-round scan or advanced scan is something that I’ve seen mentioned a few times recently and it’s a lovely little feature of Enterprise Edition that not all that...
2020-09-23 (first published: 2020-09-16)
231 reads
Find All Heaps In Your Database
This is just going to be a quick post but I was asked the question the other day, how can I find all the tables in the database that...
2020-08-20
807 reads
Backup On-Premise SQL Server to Azure BLOB Storage
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...
2020-07-08 (first published: 2020-06-22)
512 reads
T-SQL Tuesday #127 – Non SQL Tips and Tricks, Referencing Multiple PowerShell Array Elements
This month’s T-SQL Tuesday invitation is from Ken Fisher and he’s asking about non-SQL tips and tricks. This had me thinking for a bit and then something popped into...
2020-06-23 (first published: 2020-06-09)
349 reads
BlitzFileStats custom module available for Inspector V2
BlitzFileStats is the latest addition to our custom module collection for reporting on data logged to tables using the First Responder kit, We created a new project where we plan on...
2020-06-03
26 reads
Undercover Tools: June Updates
Undercover Catalogue Update 0.4.3 An update to the tables module, Row count and size infotmation added Fix – LocalInterrogation There was an issue with the LocalInterrogation stored proc not...
2020-06-01
23 reads
A Bug in ‘Move All Your SQL Database and Log Files in Bulk’
It looks like we had a bug the in the SQL script in Move All Your SQL Database and Log Files in Bulk. No worries though, it’s all been fixed...
2020-04-22
18 reads
Blogs
T-SQL Tuesday #192: What career risks have you taken?
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
AI: Blog a Day – Day 3: LLM Models – Open Source vs Closed Source
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment
Quite the title, so let me set the stage first. You have an Azure...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers