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

The past week I had the pleasure to attend SQLRally Amsterdam. I took a flight from Tel-Aviv to Amsterdam and got there on Tuesday...

This is my second day into the PASS Summit 2013, and the excitement is still rising...