I'm approaching the review phase for a paper I wrote about advanced dimensional modeling with Analysis Services 2005 using many-to-many dimension relationships. Currently the paper has around 80 page (with many figures!) and covers 2 base techniques (base  Read more

I just opened the wiki on SQLBI.EU : it contains link to useful resources for BI solution development with SQL Server, so it covers SSIS, SSAS, SSRS and of course SQL Server itself. The wiki works well when there is large contribution, so please share  Read more

I just answered to a request on SQLBI.EU forum of someone that is looking for a better lookup component, specifically designed for typical Data Warehouse scenarios. While you can read the whole thread on the forum , I try to resume most wanted requirements,  Read more

Two weeks ago I wrote a tool to ease and improve the migration of a DTS package to a SSIS package. I named the tool DtsToSsis-Prepare, it is available with full source code at www.sqlbi.eu and now I wrote a larger article that describes the needs that  Read more

Thanks to Alberto Ferrari there is a new way to handle Slowly Changing Dimensions (SCD) with Integration Services: he just released Table Difference 1.1 and FlowSync 1.0 . Both are downloadable at www.sqlbi.eu . The problem that those components solve  Read more

I wrote a small tool to improve the migration from SSIS to DTS. The problem I had to solve was this: I have many Data Transform Tasks that have a simple behavior, read data from a query and write data on a table, using fast load with batch insert. You  Read more

I had the opportunity to test TableDifference (a component written by Alberto Ferrari ) since early versions and I can say it is a very interesting way to handle Slowly Changing Dimension (SCD) much faster than with the standard SCD component of SSIS.  Read more

After I installed build 2153 , my SQL Server Managment Studio DTS 2000 Package Designer (which is part of SQL Server 2005 Feature Pack ) was not working. After I searched for an updated feature pack (which has not been released) I discovered that the  Read more

I have being a user of PromptSQL since version 1.0. This utility was acquired by Red-Gate some months ago and today they shipped the version 2.0, renamed ad SQL Prompt 2.0 . SQL Prompt is fundamentally the ability to add Intellisense when you are editing  Read more

I just had to profile MDX queries sent to SSAS from some client. Office Web Components (that are used in the cube browser of Management Studio) in many circumstances send a lot of MDX queries, increasing roundtrip between client and server, resulting  Read more