Using SQL Server 2008 R2 Best Practice Analyzer against Analysis Services

SQL Server 2008 R2 BPA is an excellent and often under-used, tool.   The title is a little misleading but it does work against SQL Server 2008 instances, not just R2 instances. I recently had the chance to use BPA against SQL Server 2008 Analysis Services.  SQL Browser is disabled by default. I entered the server\instance…

0

Debugging Parameters in the SSIS Data Flow (Script Component)

I had unfortunately picked up the (bad) habit of debugging my SSIS packages by using messagebox.show at design time.  The SSIS data flow Script component does not allow debugging using this approach so I had to find an alternative.  I discovered that it is possible to output parameters at design time using the FireInformation in…

2