found and displayed in this view.
- The Baker’s Dozen: 13 Tips for Basics of Data Warehousing and Dimensional Modeling
Magazine/Issue: CoDe Magazine, 2013 Mar/Apr
Release Date: Wednesday, February 06, 2013
Quick ID: 1304071
Imagine you’re working for a company that has accumulated a tremendous amount of transaction data. The business users want to perform all sorts of analysis, monitoring and analytics on the data. Some OLTP developers might reply with, “Just create views or stored procedures to query all the data the way the users want.” Many companies initially take that approach - however, just like certain technologies and system hardware configurations don’t scale well, certain methodologies don’t scale well either. Fortunately, this is where data warehousing and dimensional modeling can help. In this article, I’ll provide some basic information for developers on the basics of data warehousing and dimensional modeling - information that might help you if you want to provide even more value for your company.
- The Baker’s Dozen Doubleheader: 26 new Features in SQL Server Integration Services 2012 (Part 2 of 2)
Magazine/Issue: CoDe Magazine, 2012 May/Jun
Release Date: Thursday, April 19, 2012
Quick ID: 1206021
The new release of SQL Server's Integration Services has many exciting new features
- The Baker’s Dozen: 13 More Examples of Functionality in SQL Server 2008 Integration Services
Magazine/Issue: CoDe Magazine, 2010 Sep/Oct
Release Date: Friday, August 20, 2010
Quick ID: 1009081
In the last Baker’s Dozen article, I demonstrated 13 SSIS packages to show what Integration Services can do. This article picks up where the last one left off. I’ll show some capabilities in SSIS, such as handling irregular input files, extracting database changes, implementing package configurations, and leveraging the advanced lookup features in SSIS 2008.