After my post on listing users with System Admin (sysadmin) rights, Chris Mangrum shared a better script that also covers CONTROL SERVER. Here it is.
SQL SERVER – Too many dumps generated. CPerIndexMetaQS::ErrorAbort – Index Corruption
A reader had too many dumps with CPerIndexMetaQS::ErrorAbort. Here is how we traced them to index corruption and the steps we took to fix it.
SQL SERVER – List Users with System Admin (sysadmin) Rights
I List Users with System Admin membership before agreeing on the permissions for a health check. This query inspects visible principals.
SQL SERVER – Fix Error – Restore Operation Failed for Database Due to Insufficient Memory in the Resource Pool ‘Default’
SQL SERVER – Fix Error – Restore Operation Failed for Database Due to Insufficient Memory in the Resource Pool ‘Default’
SQL SERVER – Login Failed. The Login is From an Untrusted Domain and Cannot be Used with Windows Authentication – SPN Issue
Login failed, untrusted domain, error 18452, and a cluster that would not fail over. The cause was an SPN. How to read the SPN messages.
SQL SERVER – Always On Availability Group Failover Generating Dump. Error: 17066: SQL Server Assertion: HadrFstrVnnUtils.cpp:479
A client’s availability group failover across subnets got stuck in Resolving and generated dumps with Error 17066. Here is what we found and how we fixed it.
SQL SERVER – FIX: SQL Service Does Not Start After Promoting the Machine as Domain Controller
A SQL Server machine was promoted to a domain controller and the service stopped starting. Why it broke, the workaround we used, and the real fix.