sp_RestoreScript 1.9 – a dirty little bug squished!

It look like we had a little bug in sp_RestoreScript that was putting a rogue 0 after the backup file name. That's now been fixed in 1.9. 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/ Keep an eye out for sp_RestoreScript 2.0 which is currently in development and will bring a while load of new features... Continue Reading →

Inspector V2.6 now available

As always the code can be found here in our github repoWe updated our sample report hereWe forgot to mention V2.5! We added the ability to add Thresholds per drive for the drivespace module.#270 #279 - Improved the server settings module, if server changes have been made between collections this module will now pick them... Continue Reading →

Generate a Random Number for Each Row in a Query {a better way}

A couple of years ago I wrote a post on how to generate a random number in SQL Server. https://sqlundercover.com/2017/06/22/generating-random-numbers-for-each-row-over-a-specified-range-and-other-funky-stuff-you-can-do-with-them/ It's ok and it works, it's also a method that I used for quite a while. Why not use RAND() I've heard people say, well the issue with RAND() is that it will generate the... Continue Reading →

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 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 →

Create a website or blog at WordPress.com

Up ↑