New Microsoft SSIS transform

Microsoft has just released a new SSIS transform, called the SSIS Balanced Data Distributor (BDD).  You can download it here.
This...

PASS Update #57-Board Benefits, Travel, and Meetings

From time to time I get asked about how PASS Board members are compensated, so I thought it would make...

Rebind and Rewind in Execution Plans

Ever looked at an execution plan? If you answered no, you can’t possibly have ever tried to tune a query,...

Speaking at the 2011 PASS Summit

I submitted three sessions to the 2011 Summit for consideration and I heard today that two of them were accepted,...

Speaking at the 2011 PASS Summit

The emails came in today and 2 out of 4 of my sessions were selected. Both are the ones I...

SQL Books Arrived Today

A small post regarding a couple SQL books I bought from Amazon.
A couple new books arrived in the mail from...

SQL Saturday #89 Atlanta GA

The official launch of SQL Saturday #89 was June 8th.  Within the first week of the launch we have registered...

SSRS Error: Cannot read the next data row for dataset Dataset1

This error , Cannot read the next data row for dataset Dataset1, is thrown for many reasons, at least I have seen...

The 2012 Rally

In case you hadn’t heard, the 2012 SQL Rally will be in Dallas. Andy Warren talks about the process for...

Things That Should Be In TSQL

Relation Types

create type type_T(i int primary key clustered, j int check (j > 0)) -- relation type. Includes constraints!
create table T(type_T)

Relvar Assignment

This...