The SQL Installation file can be found here.The new Powershell installer can be found here.If you are running the powershell collection you will need to grab the latest revision.The latest powerBI template can be found here.As more features are documented they will be updated on the Inspector V2 page. New Features Schedule report windows and... 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 →
Inspector V1.4 now available
The SQL Installation script can be found here The Inspector sample report has been updated here All of the below Git Issues can be found on the V1.4 Project page #68 Added a new table [Inspector].[ExecutionLog] which will hold elapsed time for each of the stored procedures executed during a collection, this table is truncated... Continue Reading →
Inspector V1.3 now available
Inspector V1.3 is now available on GitHub. We have updated the sample report for you to play with which includes the new informational section added in this build. We updated our getting started guide. We know some of you really hate linked servers so we have been working on a powershell collection which will allow... Continue Reading →
T-SQL Tuesday #104 – My Undercover Toolbox favourites
This months T-SQL Tuesday is being hosted by Bert Wagner , you can find the invitation for this months topic here. Bert has a great topic for this month, he wants us to write about code you’ve written that you would hate to live without. I have found the SQL server community to be extremely helpful... Continue Reading →
What if it all grows out?!
The other day I got thinking about what would happen if all databases on a single instance grew out, every single one of them! but not just once, what if they all grew out three, four or fives times overnight - what would things look like? Well I know the likelihood may be slim but... Continue Reading →
The SQLUndercover Inspector is now available!
Updated: 28/11/2018: We've put together a sample report for you to play with. The SQLUndercover Inspector is now available on GitHub, a quick run down of what it does can be found here: Introducing: The SQLUndercover Inspector, a quick video introduction can be found here and upcoming video tutorials will be released on Undercover TV... Continue Reading →