Performance Dashboard reports are free custom reports from the Microsoft SQL Server Support team. Here is the Performance Dashboard installation and setup in SSMS.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Reading Connection Details in Code: APP_NAME, HOST_NAME and Logins
An audit row blamed the wrong machine because a label was treated as proof. Here is which connection values you can trust, and which you cannot.
SQL SERVER – Connecting to Azure Storage with SSMS
Connecting to Azure Storage from SSMS takes a few simple steps from Object Explorer. I also show where to find your storage account name and key.
SQL SERVER – SSMS: Index Usage Statistics, Physical Statistics & User Statistics
Creating indexes is a science, not rules of thumb. I look at the SSMS reports for Index Usage Statistics, Physical Statistics and User Statistics.
SQL SERVER – Using the SSIS Term Extraction for Data Exploration – Notes from the Field #046
Tim Mitchell shows how SSIS Term Extraction helps with data exploration, so you understand the source data better before you build an ETL process.
SQL SERVER – SSMS: Resource Locking and Object Execution Statistics Report
How many times did a procedure run, and how much CPU and IO did it use? The SSMS Resource Locking and Object Execution Statistics reports answer exactly that.
SQL SERVER – Location of Natively Compiled Stored Procedure and Naming Convention
Why is it called a natively compiled stored procedure when the code is T-SQL? I explain, and show a DMV query that finds where its DLL is loaded from.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.