-
Stages of Data #1: A New Beginning
Last updated: Tuesday, April 13, 2021
Published in: CODE Magazine: 2018 - November/December
Kevin leaves his SQL Server-focused Baker’s Dozen behind and launches into a new series looking at the various stages of data warehousing. His first installment includes a look at reporting and storage layers, handy tips, and dealing with the business side of development.
-
The Baker’s Dozen State of the Union: 13 Points on SQL Server Data Warehousing and Business Intelligence
Last updated: Thursday, July 15, 2021
Published in: CODE Magazine: 2015 - May/June
Kevin takes a look at SQL Server “then and now,” and shows us just how important it is to understand the various tools involved in BI.
-
Baker's Dozen--Business Intelligence Developers
Last updated: Monday, December 27, 2021
Published in: CODE Magazine: 2014 - March/April
If you want to be a great SQL Server developer, you’ll want to pay attention to these 13 key points. Kevin Goff covers both best practices and common pitfalls of Business Intelligence.
-
The Baker’s Dozen: 13 Examples Using XMLA to Update Analytic Databases
Last updated: Monday, October 6, 2025
Published in: CODE Magazine: 2013 - September/October
In this article, Kevin Goff provides a comprehensive guide to using XMLA commands for updating Microsoft SQL Server Analysis Services (SSAS) analytic databases, emphasizing that unlike relational databases, OLAP updates require batch-oriented XMLA processing rather than T-SQL DML. He presents 13 practical scenarios—including full and incremental processing of dimensions and fact tables, managing rigid attribute relationships, maintaining indexes, and leveraging SSIS and .NET for automation—highlighting best practices and common pitfalls. Kevin’s detailed walkthrough equips developers with essential XMLA knowledge to efficiently populate, update, and maintain SSAS cubes in production environments.
-
The Baker’s Dozen: 13 Differences Between Analysis Services OLAP and Tabular
Last updated: Monday, May 23, 2022
Published in: CODE Magazine: 2013 - July/August
For over a decade, many Microsoft database developers have used SQL Server Analysis Services (SSAS) OLAP to create database cubes for advanced business analytics. SSAS OLAP offers many powerful features, although some developers view the learning curve of OLAP (and its supporting language, MDX) as very steep.
-
The Baker’s Dozen: 13 Tips for Basics of Data Warehousing and Dimensional Modeling
Last updated: Wednesday, June 8, 2022
Published in: CODE Magazine: 2013 - March/April
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)
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2012 - May/June
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
Last updated: Tuesday, February 19, 2019
Published in: CODE Magazine: 2010 - September/October
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.