A reader had no Start menu shortcut for SQL Server Configuration Manager and could not find it. Here is how to open it anyway.
SQL SERVER – gMSA: The Service Did Not Start Due to a Logon Failure
SQL Server running under a gMSA would not start: the service did not start due to a logon failure, yet no password had expired. Here is the real cause.
How to Check Edition Specific Features Enabled In SQL Server? – Interview Question of the Week #180
Moving databases to another edition? Here is a simple script for SQL Server 2008 and later that lists the Edition specific features each database uses.
SQL SERVER – Database Mail Error: The SMTP Server Requires a Secure Connection or the Client was not Authenticated. The Server Response Was: 5.5.1
Database Mail with Gmail failed: the SMTP server requires a secure connection or the client was not authenticated, 5.5.1. Here is how to fix it.
SQL SERVER – Many BACKGROUND Threads with Command VDI_CLIENT_WORKER
Seeing many BACKGROUND threads with command VDI_CLIENT_WORKER? Here is what the VDI_CLIENT_WORKER and VDI_CLIENT_OTHER wait types mean.
SQL SERVER – Event ID: 1135 – Cluster node ‘NodeName’ was Removed From the Active Failover Cluster Membership
Event ID 1135 says a cluster node was removed from the active failover cluster membership. Here is what a customer’s AlwaysOn setup taught me about it.
Practical Real World Performance Tuning – Fun and Reviews
Part two of my behind the scenes story of Practical Real World Performance Tuning: the fun we had in class and the reviews our students shared.