After a cluster rebuild, adding a replica failed: The specified instance is hosted by a system that is not a Windows Server Failover Cluster node. Here is the fix.
SQL SERVER – SQL Server Configuration Manager Missing from Start Menu
SQL Server Configuration Manager missing from the Start Menu? Open it directly from C:\Windows\System32 with the SQLServerManager msc file for your version.
SQL SERVER – SQL Service Not Getting Started Automatically After Server Reboot While Using gMSA Account
My first gMSA test: SQL Service was not started automatically after server reboot, even with automatic startup set. Here is what the event log showed.
SQL SERVER – Error: 18456, State 149 – Login-based Server Access Validation Failed With an Infrastructure Error. Login Lacks Connect Endpoint Permission
Connecting to the DAC with SQLCMD, I got Error 18456, State 149: Login lacks connect endpoint permission. Here is what the ERRORLOG showed and how to fix it.
How to Extract Alphanumeric Only From A String? – Interview Question of the Week #214
A reader wanted only the values that mix letters and numbers from a column. Here is how to extract alphanumeric values from a string with simple pattern matching.
Eager Index Spool: When the Plan Builds Its Own Index
Investigate an eager index spool, read seek keys and output, and compare a supporting index with the cost of rebuilding temporary storage.
SQL SERVER – How to Invoke SSMS Help From Command Prompt?
A workshop attendee asked how to invoke SSMS help from Command Prompt. Here is how to open SSMS from the command line and list all of its parameters.