Photo by Joey Kyber on Pexels.com I'm going to assume that most people will have at least heard of Brent Ozar's brilliant First Responder Kit. If you haven't then you've been missing out on some serious (and FREE) SQL troubleshooting goodness and I'd suggest you check it out. Now I use these scripts all the... 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 →
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 →
Getting table row counts with sp_Tablecount
Sometimes you just want to get a quick row count for a specific table - other times you may want to see a list of tables order by size or row count or perhaps you are monitoring table row counts, whatever it is the chances are you have a script or various scripts stashed away... Continue Reading →
sp_LockDetails – Get Details of all Locks Taken Out Against a Database.
Be sure to get the latest version of this script from our GitHub, https://github.com/SQLUndercover/UndercoverToolbox Have you ever wanted a quick and easy way to see who was holding (and waiting on) locks on a particular database? Perhaps you've got some blocking issues going on and you want to see exactly which rows the row level... 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 →
sp_drivespace – See How Much Space You Have On Your Disks, Including Mount Points
We love xp_fixeddrives here, it's a quick and simple way to see how much space you've got available on your drives. But there are just a couple of things that I really wish it would do better. Firstly, I'd love to see the total size of the drive and possibly even a percentage of free... Continue Reading →
Is Your Availability Group ‘REALLY’ Ready To Failover?
You know what it's like, you need to fail your AG over but is it safe to fail over? Perhaps you've clicked on 'failover' for the AG and there's a little green tick and no data loss reported... Or maybe you've checked out sys.dm_hadr_database_replica_cluster_states and 'is_failover_ready' is reporting a 1. So, you're cool to failover,... Continue Reading →