SQL Saturday #235 New York City Wrapup

Today I had the pleasure of speaking at the SQL Saturday #235 in New York City. Talk about an absolutely...

24 Hours of PASS Q & A: Why are Bit’s Flipped?

http://bit.ly/16UyEPHHello Dear Reader.  Almost two weeks ago I delivered a presentation for the 24 Hours of PASS on SQL Server...

Boorish Behavior? No, Worse. Death Threats Against Developers/Designers.

I know DBAs and developers have a rocky relationship. However, I don't believe we go as far as some of...

Cannot find NT Service\MSSQL$SQL2012?

If you cannot find the virtual account used by the default settings installation of your SQL 2012 instance (in this...

Disaster Recovery Docs–Offsite

Years ago I worked at an ISO certified organization, where we took our administration and planning seriously. We ensured everything...

How are COALESCE and ISNULL different?

At first glance these two functions seem very similar, and superficially they are. For example COALESCE(fieldname1, fieldname2) and ISNULL(fieldname1, fieldname2)...

My event schedule for Fall 2013

As I was browsing my calendar of upcoming events for the remainder of the summer and the fall, I realized...

Traveling and Talking to Wrap Up 2013

I am writing this blog post en route to New York City for SQL Saturday #235. This begins a fairly...

Azure and Your MSDN Account

I’ve heard over and over again that the reason people don’t want to learn Azure, to explore it, to understand...

Distribution setup SQL Server Agent error: "RegCreateKeyEx() returned error 5, 'Access is denied.'"

In the Configure Distribution Wizard, the step "Configuring SQL Server Agent to start automatically" errors with the following text:

TITLE: Configure...