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

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

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

31 Days of SSIS – Small Package, Big Win (26/31)

Welcome to day twenty-sixth post of the 31 Days of SSIS.   We’re getting near the end now.  If you have...

A Half-Price Seat at the Masters’ Table

Well, it looks like I half-won the SQLskills competition for a free seat at a SQLskills Master Immersion Event on...

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

My Most Popular Posts From 2010

I was recently looking through my blogging statistics and discovered that I can see the most viewed posts during that...

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

SSAS Dimension Attribute Discretization Methods

Discretization (one of my favorite tech words to say J) is a really great feature of Analysis Services that is...

Two Profiler Tips

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