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

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

Cool Data Visualization

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

Appending New Rows Only

I saw a question in the forums related to inserting new rows into a SQL Server table only if they...

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

Big Apple SQL - SQLSaturday #158 NYC Announced!

 Come this August 4th, 2012, the Big Apple will be baking, but not just because of the hot summer day...

SSWUG Expo..I'm up!

I am proud to say that one of the webcasts I taped last year for SSWUG is part of the...

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

SQL Server 2012 Diagnostic Information Queries (April 2012)

It is hard to believe, but SQL Server 2012 has been GA for nearly a month now. Because of this,...