…brew your own Business Intelligence

Posts Tagged ‘PowerShell’

Managing Your Azure AS Environment with PowerShell – Building Blocks

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 – so that you’re only paying for what you need. In order to take advantage of […]

Read more

Managing Your Azure AS Environment with PowerShell – Getting Started

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 – so that you’re only paying for what you need. Consider your own Analysis Services environment. […]

Read more

Load Testing SSAS with PowerShell

Load testing an SSAS database is one of those tasks that everyone should be doing but very VERY few people actually do… and I can only suspect the reason is because it’s hard. Here are the general steps involved: Capture the query workload using an xEvents (basic example, autorestart option) Shred the xEvents […]

Read more

PowerShell: Checking For Large SSAS String-Store Files

In a recent blog post, Why You Need to Routinely ProcessFull, I discussed an issue where we’d run into the 4GB file size limit on SSAS string store files. In an ideal world, we’d fully reprocess the SSAS databases on a regular basis which would eliminate this issue…and maybe even […]

Read more