While building an AlwaysOn demo I hit the Database Mirroring login attempt failed error with a connection handshake failure. Here is how I fixed it.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Fix @@ServerName Property Value When Incorrect
A colleague’s @@ServerName returned NULL instead of the server name. Here is why the value can be wrong and how to fix the @@ServerName property.
Interview Question of the Week #033 – How to Invalidate Procedure Cache of SQL Server?
Clear procedure cache at the narrowest useful scope, remove one plan handle, and compare sp_recompile with statement recompilation.
SQL Authority News – 100 Million Views and Onwards
On August 20, 2015 SQLAuthority.com crossed 100 Million Views. A short thank you note to every reader who made this journey since 2006 possible.
SQL SERVER – DBCC CHECKDB errors – Msg 2520 during executions
Running DBCC CHECKDB on ResourceDB returns Msg 2520. I explain why CHECKDB cannot run on the hidden resource database and what you can do instead.
SQL SERVER – Rewriting Database History – Notes from the Field #094
Kevin Hazzard tells the story of rewriting database history, a journey that starts and ends with ORM, in Notes from the Field #094.
SQL SERVER – Login failed for user . Reason: Token-based server access validation failed
Login failed for user. Reason: Token-based server access validation failed. Here is how the state of error 18456 in the ERRORLOG shows the cause and fix.
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.