When building a data warehouse, you often need to flatten the data when you move it from the Raw tables to the Stage tables. Flattening data can be a difficult concept for new warehouse designers to grasp, so here are two detailed examples.
If you're inexperienced with using SSIS, creating a data warehouse might seem like an impossible task—but it's not if you use some different strategies. For example, you can use a wizard to initially create an SSIS package that will move data from the source system into the data warehouse.
If you install anti-virus on SQL Server, many 'bigger' anti-virus vendors either offer 'options' that let them 'monitor' SQL Server—or just plain FORCE their binaries right into SQL Server if they detect that it's running on the box....More
Predixion is a Microsoft partner solution that supplements the base SSAS Data Mining offering with many features that have long been on my wish list. The Predixion Insight solution also has exceptional support and far greater capabilities than the base Microsoft solution....More