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

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

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

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

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

vCentre Useful Queries: Part II

After posting on twitter last week that I needed something to write a blog post about my good friend Christian...

ColoradoSQL in June

All ColoradoSQL user group meetings start at 5:30 and provide food and refreshments. There is no cost to attend so...

Getting Backup File Information from a Table Valued UDF - SQLCLR to the Rescue?

Update:

After all of this SMO stuff failed (changing the permission set to unsafe got around the security exception, but instead...

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