Actual Emails: The Customer Doesn't Want Full Recovery Mode

Got this question in an email.  I'll paraphrase.

William Hoping you can advise me on best way to handle this. My client doesn’t...

Coming to Your Town

I can’t sing and I can’t play and I left the young generation behind a while ago, but I’m still...

Free Tools for Testing SQL Sever

You Need To Test Your SQL Server!
Its like screaming “TEST THE BREAKS ON YOUR CAR!” If you don’t have the...

I couldn’t help myself…

Introduction to Windows Azure SQL Database (Part 1)

Windows Azure SQL Database also known as SQL Server Data Services or simply SQL Azure is a Microsoft’s cloud services...

Meme15: Top 5 Reasons I Like My Job

This month’s Meme15 topic is ‘Top 5 Reasons I Like My Job’.  A little over a year ago, I started...

Monitor Deadlock in SQL 2012

Do you still use trace flag 1204 and 1222 to monitor Deadlock? or using profile to capture deadlock? Now we...

Quick Tip: Accurate Log Shipping Status

Here’s a quick reminder for those of you using log shipping, and checking the SSMS report “Transaction Log Shipping Status”...

Replication and TFS

 So, we’ve had this issue lately at work with our TFS build/deploys causing a significant amount of contention and only...

Speaking at 24 Hours of Pass

24 Hours of PASS (24HOP) has been around a few years now, but this will be my first time participating...