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

The 2012 Rally

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

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