Upcoming presentations

It’s looking like it’s going to be a busy year.
It’s only January and I already have three presentations lined up...

MySQL Saves You From Missing Where Clause, Sorta

I’ve been taking a look at MySQL after a long absence to help a client decide if it should be...

31 Days of SSIS – Jim Croce and the Foreach (File) Loop Container (28/31)

31 Days of SSIS
It’s Friday and I’m still taking Friday’s off in my 31 Days of SSIS blog series.  As...

SQL Saturday #57 Houston

So you don’t have anything to do this Saturday.Well, if you have an insatiable thirst for SQL knowledge like me,...

A Quick TRIM, Sir?

The other day, I was answering a question on the ASK.SQLSERVERCENTRAL.COM forum from a programmer who had hit a
problem...

Un-SQL Friday #002 Roundup (finally)

The invitation for Un-SQL Friday #002 (Tech Giants) was, like, a week ago! I’ve gotta get this train a-rollin, or...

31 Days of SSIS – Adding Some Delta Force (27/31)

31 Days of SSIS
Welcome to day twenty-seventh post of the 31 Days of SSIS.   We’re getting near the end now. ...

SQLLunch and SQL University have Combined Forces - SSIS Tips & Tricks (Advanced SSIS)

The SQL Lunch and SQL University have combined forces.  Come and watch, laugh, and learn.

#48-SSIS Tips&Tricks (Advanced SSIS)
Speaker: Josef Richberg

Add To...

Two Profiler Tips

I’ve had occasion to watch a lot of people try Profiler, and to hear a lot more about their previous...

Creating a deep hierarchy with FOR XML

I have two tables in an application that I support.  One is called [Report], and the other is [ReportParameter]. 
 
      --SAMPLE...