Entries Published On 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 it is today. The quality …
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 that they’re SSAS-mode agnostic. Basically …
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 the ridiculously silly world of …