|Teaser: SSAS Cache Warming with PowerShell|
|Written by Darren Gosbell|
|Sunday, 16 November 2008 14:49|
You may be thinking oh-no, not another one. Allan Mitchell recently posted an example of an SSIS package that would warm the SSAS cache which is an updated version with a slightly simpler SSIS data flow from something Chris Webb originally blogged. Being a PowerShell fan as I read Allan's post I realised that most of the tasks mapped to native PowerShell cmdlets and I already had PowerShell code to execute an MDX command, so all I was missing was someway of reading in the trace data.
What I ended up with was the following 3 line script which uses 2 native and 2 custom cmdlets to do the same thing as Allan's SSIS package.Read more...
- Script to automate SSAS partition management (SQL + SSIS)
- PowerShell script to process all dimensions and cubes in one DB limiting workload
- SSIS package to backup all Analysis Services databases on one instance
- SSIS Package to process all dimensions in one SSAS Database
- SSIS Package to drop and create partitions based on data in SQL Server table