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 … Continue reading ADLC Step 1: Create Initial Aggregation Designs
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 … Continue reading Aggregation Design Life-Cycle: Introduction
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 … Continue reading How To: Create a Copy of an Existing Aggregation Design
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 … Continue reading Passed 70-466 and 70-467 Exams + Study Guides
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 … Continue reading SSMS Templates for SSAS Developers