BlitzWaits custom module available for Inspector V2
We have been working on a new custom module for Inspector V2, in fact this module is part of a new project where we will be producing two other...
2020-01-22
25 reads
SQL Undercover
Introducing The Undercover Catalogue
In this video, David give a quick introduction into the Undercover Catalogue.
2020-01-20
43 reads
Managing Agent Jobs on Availability Group Servers
As always, the scripts in this post can also be found on our Git Hub repo, https://github.com/SQLUndercover/UndercoverToolbox/blob/master/CatagoryControlledAgentJobs.sql Agent jobs, they can be a right pain to manage when you’re...
2020-01-16
43 reads
Undercover Catalogue 0.4.0 Released
We’re pleased to announce the release of the Undercover Catalogue 0.4.0, (please see HERE for full details of the Catalogue). The new version brings with it a number of...
2020-01-06
31 reads
CPU custom module available for Inspector V2
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...
2020-01-02
34 reads
Happy New Year – Our Top Posts of 2019
With the New Year fast approaching and maybe already having arrived depending on where you are, we thought we’d do a quick recap of our top 5 posts from...
2019-12-31
33 reads
2019-12-24
24 reads
SQL Undercover TV Christmas Special – David's Top 5 Azure Data Studio Features
In our Christmas Special, David picks his top 5 features of Azure Data Studio.
2019-12-17
34 reads
Troubleshooting Resource Semaphore and Memory Grants
Memory grants, now here’s a fun thing that can pretty much take your SQL Server to its knees. The Symptoms The first thing that you’re going to notice is...
2019-12-03
307 reads
Inspector V2.00 now available
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...
2019-12-03
53 reads
Blogs
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Forums
Randomly Selecting Columns and Rows from a Table or View
Comments posted to this topic are about the item Randomly Selecting Columns and Rows...
How Can SQL Server Detect Application Errors When Developers Can’t?
Comments posted to this topic are about the item How Can SQL Server Detect...
Getting Database MaiL Profiles
Comments posted to this topic are about the item Getting Database MaiL Profiles
Question of the Day
Getting Database MaiL Profiles
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers