Among the many new features coming w/ SSAS 2017, object-level security for tabular models is at (or close to) the top of the list for a few clients I work with. In fact, for 1 … Continue reading Object-Level Security for Analysis Services Tabular
It wasn’t until just a few weeks ago, while performing a design assessment on a very large tabular model, that I was finally able to appreciate one of the most underrated improvements made in SSAS … Continue reading Model Development Performance Improvements for Tabular Models Using Compatibility Level 1200+
Much of my client work these days is focused on performance… making slow Analysis Services servers run faster. The good part about these types of engagements is that there’s usually (not always) a good amount of low-hanging … Continue reading How Much RAM Do I Need For My SSAS Tabular Server?
Earlier this week, while discussing high-concurrency architecture options for SSAS multidimensional, a colleague asked about options for SSAS tabular and mentioned there was very little information available online specific to tabular…and so, a blog post … Continue reading SSAS Tabular: Scale-Out Query Architecture
Lately, I’ve been spending quite a bit of time troubleshooting some performance issues related to PowerView reports running against a SQL Server Analysis Services 2012 Tabular data source. One of the first steps in the … Continue reading SQL Profiler EventClass & EventSubClass Column Descriptions for SSAS 2012