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 →Archive for April 2013
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 →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 →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 →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 →