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
26 reads
SQL Undercover
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
23 reads
2019-12-24
15 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
28 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
290 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
41 reads
SQL Undercover TV – Encrypting SQL Backups
In this episode, David looks at how we can encrypt our SQL Server backup files
2019-11-26 (first published: 2019-11-18)
246 reads
SQL Undercover TV – Using Excel to Visualise SQL Performance Data
Adrian looks at how you can use Excel to visualise SQL performance data, specifically data collected by the Blitz First Responder Kit
2019-11-05
105 reads
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...
2019-11-06 (first published: 2019-10-30)
1,048 reads
Finding the Primary Replica of an Availability Group
This is going to be a bit of a quick post but one about something that I see coming up time and time again on SQL Undercover’s search terms....
2019-10-24
665 reads
Blogs
Choosing to not drive the Tesla
By Steve Jones
I started a short thread on Twitter/X and Bluesky recently after leaving the Tesla...
Advice I Like: Transactions and Relationships
By Steve Jones
Life gets better as you replace transactions with relationships. – from Excellent Advice for...
Free PostgreSQL Performance Monitoring with pgNow
I’ve been putting together a new PostgreSQL session called “Performance Monitoring for the Absolute...
Forums
Limits, Not Goals
Comments posted to this topic are about the item Limits, Not Goals
Making Additions and Changes; Getting Error Preventing Them
MS SQL Server/SSMS are my tools. As my project evolves I find I need...
SSL Certificate Chain
SSL Certificate Chain Not Trusted Error in SQL Server Connection in Power BI I’m...
Question of the Day
Precision and Scale II
What is the precision, length, and scale for an int variable?
See possible answers