…brew your own Business Intelligence

Archive for April 2013

ADLC Step 1: Create Initial Aggregation Designs

This is the second post in a series of posts covering the Aggregation Design Life-Cycle (ADLC). Introduction Create Initial Aggregation Designs Remove Ineffective Aggregations Capture Query Workload Run Usage-Based Optimization (UBO) Wizard Create Custom Aggregations Final Thoughts In the last post, we discussed aggregations at a basic level…what they are, […]

Read more

Aggregation Design Life-Cycle: Introduction

This is the first post in a series of posts covering the Aggregation Design Life-Cycle (ADLC). Introduction Create Initial Aggregation Designs Remove Ineffective Aggregations Capture Query Workload Run Usage-Based Optimization (UBO) Wizard Create Custom Aggregations Final Thoughts When it comes to maximizing Analysis Services query performance, nothing beats a solid […]

Read more

How To: Create a Copy of an Existing Aggregation Design

During the development and on going maintenance of a SSAS database, there are times when you’ll want to have a backup copy of an existing aggregation design.  The primary use case to consider is when you are creating customized aggregations (either manually or via the Usage-Based Optimization Wizard).  By having […]

Read more

Passed 70-466 and 70-467 Exams + Study Guides

Earlier this month, I passed the following two exams putting me 1 away (70-462) from the MCSE Business Intelligence certification. 70-466 – Implementing Data Models and Reports with Microsoft SQL Server 2012 70-467 – Designing Business Intelligence Solutions with Microsoft SQL Server 2012 Below is an outline of the material I worked […]

Read more

SSMS Templates for SSAS Developers

Templates and Snippets are two nice little features in SSMS that allow you to quickly generate standard code statements.  They come with a fairly substantial list of generic statements to get you started, but if you’re OCD and/or lazy (like most good DBAs and developers) you can customize the existing ones or add a […]

Read more