As always all updates can be found on our Github repo Breaking changes (Powershell collection): We only test the powershell collection against 2-3 servers so please test carefully before rolling out changes especially if you are centralising more servers than we do. Unlike the SQL based agent collections we would recommend running the powershell collection... Continue Reading →
If you need to keep track of CPU and are not fortunate enough to have a monitoring tool to keep hold of historical CPU usage then this module may just be for you, you can find the code on GitHub. New to the Inspector? be sure to check out the Introducing Inspector post first.We have... Continue Reading →
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 →
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 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 →
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 →
Pre-requisites: SQL 2012 or higher SQL Server Agent A database to store the the data collected by the agent jobs (this can be one you use for your other DBA needs it doesn’t have to be a dedicated database) Optional: For instances with availability groups where you take backups on the secondary replicas you will... Continue Reading →
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 →
This month’s T-SQL Tuesday is brought to you by Jens Bestergaard - the subject is Essential SQL Server tools, the original invitation can be found here. Here is how my day of using SQL tools went: It all started at 00:00 this morning with planned maintenance, I was adding a bunch of Clustered indexes... Continue Reading →
Post Updated: 23/07/2021 Here is a quick guide to getting started with the SQLUndercover Inspector. So you have ran through the installation of the Inspector and now you want to know what to do next, below we will guide you through some of the key steps to get you started and following on from that... Continue Reading →
SQL Undercover 