…brew your own Business Intelligence

Home

Latest Posts

  • Load Testing SSAS with PowerShell
    Load testing an SSAS database is one of those tasks that everyone should be doing but very VERY few people actually do… and I can only suspect the reason is because it’s hard. Here are the general steps involved: Capture the query workload using an xEvents (basic example, autorestart option) Shred the xEvents...
    Read more
  • Analysis Services Extended Events – AutoRestart Option
    The MSDN documentation and SSMS support for Analysis Services xEvents is severely lacking when compared to the database engine. In fact there wasn’t even a GUI for SSAS xEvents until SQL 2016… which meant anyone who wanted to create an xEvents trace had to craft another cryptic XMLA command. To...
    Read more
  • Agile Fail: Funny User Story Edition
    If you’ve ever worked on an “Agile” project, chances are you’ve come across some hilariously written user stories…perhaps even some that were so ridiculous you started questioning the string of choices and decisions you’d made that ultimately led you to being involved with this project in the first place. Don’t be afraid and don’t...
    Read more
  • Engaging the Formula Engine Cache with SSAS Tabular
    One of the more subtle architectural differences between tabular and multidimensional instances is caching. Multidimensional is a disk-based technology and performance for query workloads (in many cases) depends heavily on cache utilization. Tabular, on the other hand, is a memory-based technology with (nearly) zero dependence on disk IO and is therefore much less...
    Read more
  • Atlanta Modern Excel User Group
    Recently, I was approached by a colleague, Damu Venkatesan (@vdamu), to help manage a new user group: Atlanta Modern Excel User Group. I told him I was flattered but not quite sure how I could contribute other than helping out with the basic administrative responsibilities as I don’t consider myself...
    Read more
PASS Summit 2016