Restarting

Well, it’s been awhile since I’ve written anything.  I have lots of excuses for not writing, but none of them...

Restarting

Well, it’s been awhile since I’ve written anything.  I have lots of excuses for not writing, but none of them are rally valid.  There are 2 real reasons for...

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”...