Many scripts online miss logins when listing sysadmin members. Why the common query is wrong, plus a correct one for logins with System Admin permission.
SQL SERVER – TDE Effects on TempDB’s Slow Performance
A client had slow performance out of nowhere. The cause was TDE effects on TempDB after someone tested encryption on production. Here is what I learned.
SQL SERVER – How to get historical deadlock Information from System Health Extended Events?
Let me start off by asking a simple question. How many of you have seen this error about historical deadlock information earlier?
How to Get Random Records from Table? – Interview Question of the Week #105
How do you get random records from a table? This interview question never gets old. Here is the ORDER BY method I use because its syntax is easy to remember.
SQL SERVER – Unable to Start SQL Service – Server TCP provider failed to listen on [‘any’ 1433]. Tcp port is already in use.
One of my SQL instances would not start: Server TCP provider failed to listen on port 1433, TCP port is already in use. How I found what held the port.
Mirroring Endpoint Permission: Fixing Connection Handshake Failed
A friend using certificates on workgroup machines saw Connection Handshake Failed on every mirroring login attempt. The witness ERRORLOG showed a missing mirroring endpoint permission, and one GRANT statement fixed it.
SQL SERVER – SSMS – Script Out Multiple Objects
Do you script objects one at a time in SSMS out of habit? There is a quicker way to script out multiple objects in one go, and here is how.