How do you find the Process ID for SQL Server services? One quick query on sys.dm_server_services returns the process id, status, last startup time and account.
SQL SERVER – Scoped Firewall Rules Instead of Disabling the Firewall
A firewall rule should permit the required SQL Server or management connection narrowly. My original automation case needed remote access.
SQL SERVER – Database Mirroring Login Attempt Failed With Error: ‘Connection Handshake Failed. An OS Call Failed: (80090350)
Connection handshake failed with 0x80090350 on an availability group replica. What the code means, why it says mirroring, and what to check.
SQL SERVER – How to Turn On / Enable Instant File Initialization?
To Enable Instant File Initialization for data files, I check the Windows service identity and volume-maintenance privilege. Eligibility still matters.
How to Check Status of Instant File Initialization? – Interview Question of the Week #184
Here are two quick ways to check status of Instant File Initialization: read the error log, or query sys.dm_server_services on SQL Server 2016 and later.
SQL SERVER – How to Check If Instant File Initialization Enabled or Not?
Is Instant File Initialization enabled on your server? Before SQL Server 2016 there was no quick answer, but from 2016 onward you can check it in seconds.
SQL SERVER – How to Listen on Multiple TCP Ports in SQL Server?
Can SQL Server listen on multiple TCP Ports? Yes, and here are the Configuration Manager steps I shared when a senior DBA asked me during a Health Check.