Cool Data Visualization

I attended a course from Edward Tufte a few years ago on Data Visualization, and while I learned some neat...

Slacking Off: Totally TED

Lately I’ve taken to watching TED talks in the evening.  They’re thought-provoking, usually entertaining, and, best of all when watching...

SQL Saturday Houston #107 Recap

I enjoyed a long weekend in Houston starting with Kalen Delaney’s Pre-con on Query Tuning. I have learned over the...

SSIS Data Flow Tuning

 During my SSWUG webcast I was asked to give some examples on how to tune
the DefaultBufferMaxRows and DefaultBufferSize, so here goes.

When a source is pulling in data, it places them into...

SSIS Data Flow Tuning

During my SSWUG webcast I was asked to give some examples on how to tune the DefaultBufferMaxRows and DefaultBufferSize, so...

SSIS Data Flow Tuning

During my SSWUG webcast I was asked to give some examples on how to tune the DefaultBufferMaxRows and DefaultBufferSize, so here goes.
When a source is pulling in data, it...

AlwaysOn Failover Bug

I just found a little bug in AlwaysOn. It’s actually not that big a deal, but it’s interesting. In a...

April Hammond .net User Group Presentation - SQL Server Security and Permissions

Here's the slide deck and sample files from last night's presentation at the Hammond .net User Group.  We discussed SQL...

Beer, Cheese and SQL Saturday 118 Madison

This past weekend I (w|t) headed up to Madison, WI to attend and present at SQL Saturday 118. The MADPASS...

Offset without OFFSET

A while ago Robert Cary posted an article on SQL Server Central entitled 2005 Paging – The Holy Grail which is,...