How to set the default replication agent profile

Over the last couple of years I've come to the conclusion that the default replication agent profiles just don't cut...

Actual Emails: Is "NOLOCK is the epitome of evil?"

Sent: Friday, January 20, 2012 10:30 AM
To: William Assaf
Subject: dba has a questionWilliam,

Can you send me references to support my contention that NOLOCK...

SQL Server – Modifying Production Data Good Practise

Q. “I need to modify Production Data directly on a Production database. What are some steps I can follow to...

S3OLV – Jan 2012 Meeting Recap

Last week (Jan 12, 2012), we held the user group meeting for the SQL Server Society of Las Vegas (a.k.a S3OLV or SSSOLV). Presenting at that meeting was Josh...

S3OLV – Jan 2012 Meeting Recap

Last week (Jan 12, 2012), we held the user group meeting for the SQL Server Society of Las Vegas (a.k.a...

Find the version of the Master DB from a backup

Try researching recovering the master database online and you will see countless references to having to have SQL at the...

Nooner Viewing Summary

Over the last few weeks, I’ve been watching SQL Server videos and webcasts.  My primary motivator in doing this is...

DBAs and the Career-Life Balance

Reprinted from my editorial in Database Weekly.
I know a lot of DBAs who make SQL Server the focus of their...

Re-blog – January 13 – January 19

Welcome to the Friday Re-Blog summary post.  The aim of these posts is to bring some old posts that newer readers may...

PASS Summit session videos online

If you are interested in viewing the recorded sessions for the PASS Summit 2011, you can order the DVD.  You...