Receive error #13119 in toolbox instead of tools in Visual Studio 2008

A couple of times over the past few months, while in Visual Studio 2008 working on an SSIS package, I went...

When to use T-SQL or SSIS for ETL

When doing ETL, you have the choice of using T-SQL or SSIS.  What things should you consider when deciding which...

Microsoft SQL Server Parallel Data Warehouse (PDW) Explained

Microsoft SQL Server Parallel Data Warehouse (PDW), formally called by its code name “Project Madison”, is an edition of Microsoft’s SQL Server...

Microsoft Small Basic

This is a bit off-topic, but I wanted to mention a great tool for beginners to learn how to program. ...

Tracking down KPI error in PerformancePoint

On a few occasions, I have opened up my PerformancePoint scorecard on SharePoint to see an error staring at me:

So...

Methods for populating a data warehouse

Source tables change over time. A data mart or data warehouse that is based on those tables needs to reflect these...

Microsoft SharePoint Online

Microsoft SharePoint Online is a cloud-based service that is part of the recently released Microsoft Office 365.  For those of us...

Using SSIS lookup transformation editor with millions of rows

If you are using a SSIS lookup transformation editor and the reference dataset is large (millions of rows) and you...

SSAS Maestro Program (or SQL BI MCM)

There is a very interesting new Microsoft program that started back in January, called the SSAS Maestro Program.  It is a five-day,...

Product Guide for SQL Server “Denali” released

Released today, the SQL Server code name ‘Denali’ Community Technical Preview 3 (CTP3) Product Guide download contains the latest datasheets, white...