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 – Script – Turn off Firewall Remotely (PowerShell, NetSh, PsExec)
An automated SQL Server install meant we had to disable the firewall without logging in. Here are three ways to turn it off remotely: NetSh, PowerShell and PsExec.
SQL SERVER – Database Mirroring Login Attempt Failed With Error: ‘Connection Handshake Failed. An OS Call Failed: (80090350)
An Always On secondary showed as disconnected and the ERRORLOG said: Connection handshake failed. An OS call failed: (80090350). Here is what caused it and the fix.
SQL SERVER – How to Turn On / Enable Instant File Initialization?
This follow-up to my IFI posts shows how to turn on and enable Instant File Initialization when it is disabled, with a method that works for nearly every version.
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.