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 backups are excluded @SingleUser - Put the database into single user mode before restoring @StopAtMark - Append stopatmark clause to any log restores @StopBeforeMark - Append... Continue Reading →
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 many people seem to know about. The thing to remember here that this is only available in Enterprise Edition, so unfortunately those of you on Standard... Continue Reading →
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 don't have a clustered index? Tables without clustered indexes, known as heaps can give you quite a few different performance problems for various reasons. I don't... Continue Reading →
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 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 →
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 my head, an accidental discovery that I made the other day. I apologise if this is common knowledge among the PoSH guys but it was a... Continue Reading →
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 updating the execution log, this has now been fixed. Undercover Inspector Updates we forgot to mention from May (V2.2): Added EmailGroup column to ReportData table #216Added... Continue Reading →
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 now 🙂
Move All Your SQL Database and Log Files in Bulk
As always, the script from this post can also be found on our GitHub repo, HERE You've got a SQL Server with a few hundred databases on it (to be honest it doesn't even need to be quite that many) and you need to move all the data and log files to a new location.... Continue Reading →
T-SQL Tuesday #124 Query Store and Spin Locks #tsql2sday
This month's T-SQL Tuesday invitation comes from Tracy Boggiano and she's asking us to write about our experiences with Query Store. I thought about what I should write, I'm a big fan of query store and I've used it to help me out on a number of occasions recently. I could write about one of... Continue Reading →
SOS_SCHEDULER_YIELD – What is it really telling us?
I decided to write this off the back of a conversation I was having the other day around the SOS_SCHEDULER_YIELD wait type. The conversation went something along the lines of "but David, I'm seeing SOS_SCHEDULER_YIELD, we must have CPU issues". Yes this particular customer had been CPU bound recently but was that really their problem... Continue Reading →