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

SSAS Maestro–Redmond Day 2–Redux

Wow, what a day 2! This was our first day of lecture and it was a doozy. Stacia and I...

SSIS Configurations: When and How

Configurations in SSIS are a lovely tool that when implemented correctly can greatly reduce package maintenance.  It is very possible...