|Category: Business Intelligence|
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