Nobody can say which servers are behind on cumulative updates without logging into each one. Here is how to read your SQL Server patch level… Read More »SQL Server Patch Level: Which Servers Are Behind?
For the month of October you will receive a free year of our SQL Server Daily Monitoring with the purchase of a SQL Server Assessment.… Read More »Final Days to Seize October Special at Stedman Solutions!
What Database Health Monitor 4.1796 means for small teams: less guessing, better conversations with developers and vendors, and earlier warning on blocking.
A flat SQL Server security score hides the one failure that matters. See how weighting by severity puts the critical findings first.
SQL Server connections by database turns a baffling instance total into a named application, with pool limits, leaks and master slices explained.
The output clause is one of the wow factor query items, where when people see you use it the just go WOW, I did not… Read More »TSQL Output Clause Course
When the instance connection total jumps, SQL Server connections by database shows which application is holding them. Here is how to read the split.
Vendor installers leave behind SQL logins with CHECK_POLICY off, which means no complexity, no expiry and no lockout. Here is why they survive every review,… Read More »The SQL Login Nobody Remembers: Finding Accounts With the Password Policy Turned Off
Is your master database size normal? Read the object count first, then the used and free split in each file, and only then the file… Read More »Master Database Size: Read This Row Before the Megabytes
Learn more about the Join Types poster. Compatible with SQL Server (TSQL) and MySQL. Check out the poster, it is a versatile, print-on-demand resource which… Read More »SQL Join Types Poster
