…brew your own Business Intelligence


Latest Posts

  • Accessing SSAS Instance Configuration Info via Powershell
    Over the past few months I’ve been working on a lot of scripts for collecting SSAS-related configuration and performance information. So far, most of the scripting has been done via PowerShell (which I’m really starting to appreciate) but on a few rare occasions I’ve had to dip my toes into...
    Read more
  • Quickly Analyze Large Objects in #SSAS Databases with WinDirStat
    There are tons of solid free tools out there that make life much easier for SSAS developers. A while ago, I blogged about the Top FREE tools for SSAS 2012 Developers most of which I still use on a daily basis. But even that list is getting a bit stale...
    Read more
  • Troubleshooting #SSAS Performance Issues
    For the past 2 years, I’ve spent quite a bit of time across several clients addressing performance issues with Analysis Services solutions. Now that may sound like your own personal hell, and I totally understand why. Analysis Services is complicated enough just to get it off the ground and into production....
    Read more
  • Performance Monitoring for Analysis Services – Part1
    One of the really cool benefits of being a Linchpin Teammate, besides working with some wicked smart SQL-people, is getting to participate in the Notes From the Field series over at site SQLAuthority.com. Note: SQLAuthority.com is a site that was built by Pinal Dave (b | t) and has become...
    Read more
  • SSAS Tabular, Telerik, Multi-Value Parameters with DAX
    Earlier this summer, I started working with a new client to develop the next version of their reporting platform. This client already had the reporting requirements and good jump start on the underlying data model but had run into some serious performance issues when trying to report directly from the relational data model...
    Read more
PASS Summit 2015