Forgetting to shutdown your Azure environments and burning through a month’s worth of Azure MSDN credit if you’re lucky (and racking up a large credit card charge if you’re not) is a pretty common experience … Continue reading Using the Azure REST API to Pause All AS Instances in a Resource Group
At some point in the past couple weeks/months, the Azure Analysis Services team managed to expose a few more metrics to the Azure AS Monitoring / Metrics blade. Last I checked, there were only 2 metrics … Continue reading Monitoring Azure Analysis Services Instances via Azure Portal
In order to access a tabular model, users must either be a member of the Analysis Services instance administrators group or granted access via a database role. For on-premise SSAS instances, this meant adding the … Continue reading Managing User Access to Azure Analysis Services Databases
Power BI is certainly picking up speed, but the number 1 ad-hoc reporting client in Analysis Services environments continues to be Excel. Not much of a surprise really… Excel is a super popular tool across … Continue reading Connecting to Azure Analysis Services via Excel – Easy Mode
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 – Building Blocks
Much of my client work these days is focused on performance… making slow Analysis Services servers run faster. The good part about these types of engagements is that there’s usually (not always) a good amount of low-hanging … Continue reading How Much RAM Do I Need For My SSAS Tabular Server?
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