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

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

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

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