Stuart Ainsworth shares a client case of importing XML documents into a staging table and what he learned about using XQuery methods in SQL Server.
Refreshing a Test Database From Production Safely
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
NOLOCK is one of the most abused hints I see. In Notes from the Field #117, Stuart Ainsworth explains when Nolock makes sense and why overusing it is risky.
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.