…brew your own Business Intelligence


Latest Posts

  • Ever wondered what’s captured in the SSAS Flight Recorder?
    During a recent engagement involving an Analysis Services health assessment, one of the things I noted was that the Flight Recorder was enabled. During the post-assessment review with the client, where we walked through the report and recommendations, I quickly explained what the Flight Recorder was, why it should be...
    Read more
  • Reflecting on 2015: Making Work Fun Again
    What an incredible year! Though if you’d asked me back in January how I thought this year would go, the response would likely have been “don’t know, don’t care“. Not wanting to go into all the gory details in this post (perhaps sometime in the future, maybe) I’ll simply say...
    Read more
  • Implementing a Data Strategy and Roadmap
    At the very last minute (just before unplugging for the holiday break) I decided to attend a workshop hosted by Georgia chapter of Data Management International (DAMA-GA)…and what a good decision that turned out to be! I’d be lying if I told you I was looking forward to this event....
    Read more
  • Performance Monitoring for Analysis Services – Data Collection
    Welcome back! This is the second post in a series of posts focusing on performance monitoring for Analysis Services. In the first post we covered why performance monitoring is important and the types of issues it can help us avoid. Now it’s time to take the next step and figure out how...
    Read more
  • 3 Methods for Shredding Analysis Services Extended Events
    Troubleshooting Analysis Services performance issues is hard. In complex and/or high concurrency environments (e.g. scale-out solutions) it can be a nightmare. Throw in a transient issue (i.e. one that can’t be reproduced on command or at some predictable time) that only occurs in production and you’re only option is to...
    Read more
PASS Summit 2015