Earlier this week, I delivered a presentation called “Query Progress Tracking in SQL Server” to my local user group. Among other...

This script displays the last date and time of each backup type for each database. It’s useful when you need to know quickly when a...

Let’s say you are developing an SSIS package on your dev box to load data from an Excel file to SQL Server. For this example, let’s...

I don’t like the MERGE statement. The syntax is weird, it’s tricky in terms of locks, and it has a history of weird errors. The other day...

Here’s a newsflash: You may not thing so, but you are expensive. There’s no point in endless performance tuning. I love performance...

It’s 2014 now. I hope you had fun in new year’s eve. 2013 was an amazing and intense year. To recap it, I thought about sharing some of...

It’s 2014 now. I hope you had fun on New Year’s Eve. 2013 was an amazing and intense year. To recap it, I thought about sharing some of...

This post is for T-SQL Tuesday #49, the monthly blog party of the community. This tradition was started by Adam Machanic (blog |...

While in SQLRally Amsterdam, I had the honor to interview Brent Ozar (blog | twitter), Adam Machanic (blog | twitter) and Denny Cherry...

Introduction Service Broker is a cool feature new since SQL Server 2005. Yes, SQL 2014 is just around the corner so it’s hardly “new” any...