Entries Published On 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, why we need them…and then …
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 dimensional data model with appropriately …
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 a backup copy of the …
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 through in preparation for these …
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 few of your own. Snippets …