…brew your own Business Intelligence

Archive for October 2015

Reflections: SQL Saturday 452 (Charlotte BI Edition)

This past weekend, I drove up to Charlotte, NC to attend what has become one of my favorite SQL Saturdays on the east coast. The folks at CBIG (the local SQL Server Business Intelligence user group) are always super-enthusiastic and have done a fantastic job growing this event into what […]

Read more

PowerShell Scripts for Collecting SSAS-related Perfmon and xEvent Trace Data

Here are two more PowerShell scripts I’ve been using for a while now to collect SSAS-related performance data. Each script is structured as a PowerShell function w/ a single call at the bottom of the script so that they can be executed ad-hoc. One cool thing about these scripts is […]

Read more

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