Plan refreshing a test database with isolated restores, safe paths, user repairs, data replacement, disabled outbound actions, and a log.
SQL SERVER – Who Changed the Password of SQL Login? – Interview Question of the Week #065
Who changed the password of your SQL Login? It is a real world question every DBA faces one day. Bookmark this post, here is how to find the answer.
SQL SERVER – The NOLOCK Question – Notes from the Field #117
Stuart Ainsworth discusses NOLOCK, dirty reads and safer alternatives. A two-session example shows why uncommitted results can be misleading.
Finding Out Who Changed That Row
Investigate who changed data using existing audit evidence, transaction log limits, and the distinction between logins and individual users.
SQL SERVER – How to Connect Using NT AUTHORITY \ SYSTEM Account?
SSMS will not let you type in Windows credentials. Here is how to connect using NT AUTHORITY\SYSTEM account with PsExec from Sysinternals.
SQL SERVER – Timeout expired. The timeout period elapsed prior to completion of the operation
Today we are going to learn about how to fix the error: Timeout expired. The timeout period elapsed prior to the completion of the operation.
SQL SERVER – Someone was trying to hack my SQL Server Logins in Azure!
I noticed failed login errors on my Azure VM. Someone was trying to hack my SQL Server logins in Azure. Here is what I found and fixed.