Happy Halloween From Stedman Solutions
As the jack-o’-lanterns glow and the costumes come out, Halloween brings its share of thrills and chills. But here at Stedman Solutions, we’re declaring one… Read More »Happy Halloween From Stedman Solutions
As the jack-o’-lanterns glow and the costumes come out, Halloween brings its share of thrills and chills. But here at Stedman Solutions, we’re declaring one… Read More »Happy Halloween From Stedman Solutions
A TDE certificate backup that was never exported turns a restore on another server into an unreadable file. Here is how to check master in… Read More »TDE Certificate Backup: The Restore That Cannot Open
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