Cloudy Days Ahead

Microsoft is investing heavily in cloud computing with several online services available
under the Azure Platform. 

SQL Azure

The SQL Azure cloud...

PASS 2010 Summit Announcements and New SQL Server Developments

To say that this was a very full conference would be an understatement.  The
SQL Server platform has grown to be...

My Fat Finger and the Target Invocation Exception

I was creating an SSIS package recently and ran into the “TargetInvocationException: Exception has been thrown by the target of...

The New Path To MCM

Microsoft has announced changes to the MCM program. This page shows all the ways that you can become an MCM...

Troubleshooting SQL Server Error: 18456, Severity: 14, State: 16

I recently had to track down a rogue process that was failing to log in on one of my servers....

PASS Summit 2010-Thursday

Quick recap of yesterday afternoon: blur! I know I did stuff, but the pace is brisk and I’m just keeping...

SSIS : Using variables as a source in a Data Flow Component

Currently, none of the existing Data Flow sources allow you to source variables.  Once again in my quest for performance, I look to keep as much data as possible...

SSIS : Using variables as a source in a Data Flow Component

Currently, none of the existing Data Flow sources allow you to source
variables.  Once again in my quest for performance, I look to keep as much
data as possible in memory....

SSIS : Using variables as a source in a Data Flow Component

Currently, none of the existing Data Flow sources allow you to source variables.  Once again in my quest for performance,...

Free SQL Server Training for the Week of November 15, 2010

Tuesday
SQL Lunch - Get a Lever and Pick Any Turtle: Lifting with Metadata - Cade Roux
Pragmatic Works - SSIS Dataflow - Designing for Performance...