DROP LOGIN failed with Msg 15173 because the login had granted one or more permission(s) after an AlwaysOn cleanup. Here is how to find and revoke them.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Fix – Error: Msg 468, Level 16, State 9, Line 1
Msg 468 says SQL Server cannot resolve the collation conflict between two columns. I explain why it shows up, including with temp tables, and how to fix it.
Interview Question of the Week #028 – Few SQL Best Practices
Apply SQL best practices through ten reasoned rules for data meaning, predicates, parameters, indexes, ordering, and workload measurement.
PowerShell: How to Find Logical and Physical Processors on SQL Server?
With core based licensing, a DBA friend asked how to count cores. Here is a PowerShell script using WMI to find logical and physical processors on SQL Server.
SQL SERVER – Puzzle – DISTINCT Values in NVARCHAR
Why does SELECT DISTINCT treat ‘ß’ and ‘SS’ differently under each collation? A short puzzle on DISTINCT values in NVARCHAR, born from an SSIS unique key error.
SQL SERVER – Enhancing Reference Data in Master Data Services – Notes from the Field #089
Reeves Smith shows enhancing reference data in Master Data Services, building on data he added earlier with the MDS add-in for Excel.
SQL SERVER – Process ID X was killed by hostname ABC, host process ID Y
Seen the ERRORLOG message that a process ID was killed by hostname, with a host process ID? I explain each placeholder in error 18100 and what it tells you.
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.