One of the major value propositions of Azure AS (and this is true for many cloud technologies) is flexibility – spinning up more resources when demand spikes and turn things off when they aren’t – … Continue reading Managing Your Azure AS Environment with PowerShell – Getting Started
Wow, right on the heals of Azure AS and just when you thought things couldn’t get any better for SSAS geeks of the world… Microsoft releases SP1 for SQL Server 2016… an voila, Tabular is … Continue reading Analysis Services Tabular Is (Finally) NUMA-Aware!
This post contains a list of various methods that can be used to process (i.e. load data into) an Azure AS tabular model. As you will see – not much has changed from the regular … Continue reading Processing an Azure AS Database
When brought in the perform a health check or performance optimization, one of the first steps in the process (after getting the perfmon and xevent traces running) is to document review the environment. In addition … Continue reading Interrogating the Azure AS Configuration Files via PowerShell
When I’m managing an Analysis Services environment, I’m not just interested in the performance of the workload… yeah that’s important, but I’m also interested in the users who are generating that workload… especially the top … Continue reading On-Premise Data Gateway: Capturing SSAS Query Activity By User