This is the fourth 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 previous post, we discussed the characteristics of effective/ineffective aggregations and why
Read more →Blog
This is the third 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 previous post, we discussed the process for creating the initial set
Read more →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 →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 →Last week while spending some time on the forums, I stumbled upon a thread where the user had presented 2 queries with seemingly identical logic but produced very different results. After a bit of troubleshooting I was stumped and fired off an S.O.S. tweet with the #ssashelp hashtag. Within the
Read more →One time I was tasked with developing a handful of custom reports for a legacy application. The data model was an absolute nightmare – overflowing with technical debt and being held together with duct tape and views…tons and tons of views. In this post, I’ll show you how NodeXL can
Read more →If you regularly follow this blog, then chances are likely that you are already well aware of the new Tabular mode in SQL Server Analysis Services 2012. If not, don’t sweat it – we won’t be diving into anything super technical in this post 8-) Analysis Services Tabular is a
Read more →