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
Recently, while discussing role-based security in SSAS Tabular models with a few colleagues, the following question came up: Is it possible to write a DAX query in such a way that row-level security is bypassed? … Continue reading Is it possible to circumvent role-based row-level security with a well-crafted DAX query?
While testing the performance of ROLAP (with a ColumnStore index on the fact table) for another post (I’m still working on), I noticed something that made me stop and think “wtf?” What I noticed was … Continue reading Real Time OLAP = TRUE
Over the course of the last 8 months, I’ve had the pleasure of working with an insanely talented team on a bad-ass project that will provide tremendous value to one of the client’s major lines … Continue reading Putting the Suitcase Away (for now)