Self-service Reporting in SQL Server “Denali”

Project “Crescent” is the name currently used to describe the new self-service reporting
capability to be released in the next version...

Join the SQL Lunch on Tuesday

What a long week at PASS (stay tuned for more details about my trip).  Now that it's over back to...

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