New Maintenance Plan Wizard fails with ‘Agent XPs component is turned off as part of the security configuration’? Here is how to turn Agent XPs back on.
SQL SERVER – Why DBAs Need to Know about Kerberos – Notes from the Field #126
Not everyone knows about Kerberos. Many think it is a two headed dog from mythology, well that is true but when we talk about database,
SQL SERVER – Handling XML Documents – Notes from the Field #125
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.