SQL Server – SET STATISTICS [IO|TIME] ON

My colleagues and I often joke around with “If it takes less than a second, then it’s okay!”. The reason...

The SQLSaturday Sensation - Celebrating the 100th Event!

 
The SQLSaturday Sensation!
Congratulations, Brazil!  You are the recipient host country for SQLSaturday #100!!  On Saturday, November 26, 2011, when the...

A Guest at the Ranch

From the other side of the world, I had a guest at the ranch today.

Pinal Dave, a friend from...

Microsoft SQL Server 2008 SP2 Cumulative Update 5 Released

Microsoft has released Cumulative Update 5 for SQL Server 2008 Service Pack 2. This CU has ten fixes listed in...

SQLServerCentral.com Track at SQL Server Connections This Fall in Las Vegas

As has now become a regular tradition, SQLServerCentral.com is providing an educational track at SQL Server Connections (part of DevConnections)...

Search Argument Case Study: WHERE the year was 2002…

Content Rating: Beginner, Tips
It’s entirely possible that you’re fiddling with your search arguments too much, and missing out on the...

SQL Server “Denali”: Details on the next version of SSIS

CTP3 of SQL Server Code Name “Denali” was made available recently, and it offers a lot of new features for...

Event: NJSQL UG Tomorrow 7/19 - Management Data Warehouse

If you're in the local NY/NJ Tri-State area, and planning on attending, this is a reminder from the New Jersey...

PASS Update #60

I’ve written a lot here, but for June & July (and part of August) I’m trying to just keep the ship...

Presenting Upserts to PASS AppDev VC

Hopefully this crowd knows a little about what they're getting into!  John Jakubowski (blog|twitter) has graciously asked me to present on upsert strategies with SSIS.  What are "upserts"?  A...