A service pack install in a cluster failed with: There was an error to lookup cluster resource types. Detail.txt pointed to the cause. Here is the fix.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Unable to recycle Errorlog – sp_cycle_errorlog – OS error 1392
On a clustered server the nightly ERRORLOG cycling stopped, and sp_cycle_errorlog failed with OS error 1392. Here is what that means and how we fixed it.
SQL SERVER – Script to Audit Login and Role Member Change
A script to audit login and role member changes in SQL Server, tested end to end, including the failed attempts most people never think to capture.
SQL SERVER – Msg 3136, Level 16 – This Differential Backup Cannot be Restored Because the Database has not Been Restored to the Correct Earlier State
I was trying to teach copy-only backups to my students and encountered below error related to differential backup.
SQL SERVER – Msg 3101, Level 16 – Exclusive Access Could not be Obtained Because the Database is in Use
RESTORE failed with Msg 3101: exclusive access could not be obtained because the database is in use. How to find who is connected and your options to fix it.
SQL SERVER – Management Studio Missing – SSMS 2014 not Installed with SQL Server 2014
SSMS 2014 not installed after a SQL Server 2014 setup? The Management Tools feature was never selected. Here is how the discovery report showed it.
How to Find Median in SQL Server? – Interview Question of the Week #116
There is no MEDIAN function in T-SQL. Here is an easy way to find median values in SQL Server 2012 and later, plus what median really means.
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.