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

SQL Saturday 151 BI Pre-con: Stacia Misner

Hello Dear Reader, SQL Saturday 151 Orlando is picking up steam.  The Pre-Con’s have been named and they are fantastic. ...

Unwanted dependency between different parts of the code

Small systems tend to grow with new functionality and new access points. When the system grows, the need for data...

Where’s My Certificate Backup?

If you’re like me, you take advantage of the default backup paths in SQL Server. It makes my code cleaner,...