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 →

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. 1.8 fixes this issue. 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/

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 →

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 →

sp_RestoreScript v1.4 – It’s Now Compatible with Case Sensitive Collations, Accepts Wild Cards in DB Names and Fixes A bug

sp_RestoreScript 1.4 is now out and ready for download from our GitHub, https://github.com/SQLUndercover/UndercoverToolbox/blob/master/sp_restorescript.sql Full documentation on sp_RestoreScript can be found at https://sqlundercover.com/2017/06/29/undercover-toolbox-sp_restorescript-a-painless-way-to-generate-sql-server-database-restore-scripts/ New Features Compatible with case sensitive collations Now accepts wild cards in the @DatabaseName string, ('Database1,Database2,SQL%') would now be a valid option with % treated as a wildcard. Bug Fixes An issue when... Continue Reading →

Inspector V1.2 now available

It has been long overdue but finally V1.2 is now available on GitHub. V1.2 brings a lot of changes, We put together a sample report for you to play with but here is an overview of what has been added.   Enhancements:  #9 Long running transactions module added - A new setting has been added to  [Inspector].[Settings]. This setting... Continue Reading →

Create a website or blog at WordPress.com

Up ↑