SSAS: Automate SSAS Backups With PowerShell

I was looking for a solution to automate SSAS backups using PowerShell. By "automate", I mean the following: Backup one or more SSAS databases in an SSAS instance to a network location Automatically cleanup backups that are older than [x] days Schedule the backups via SQL Server Agent with minimal overhead Backup multiple host instances/databases … Continue reading SSAS: Automate SSAS Backups With PowerShell

Advertisements

SQL Server – PIVOT Data With TSQL

Note: Although I wrote this in year 2012, it is still valid. If you are looking to convert rows to a CSV string and vice versa in Oracle, please read my related post on that here. If you are a serious PIVOT'er, I know that you would use Excel or Power Pivot or Power BI. … Continue reading SQL Server – PIVOT Data With TSQL

Poor Man’s Cube Style Slice & Dice In A Query

This weekend I had the privilege of volunteering the Give Camp in Charlotte.  Give Camp itself is an annual national event where technical people volunteer their time over the course of a weekend to build a solution for a charitable or non-profit organization that could use the help. In my case, I was with in … Continue reading Poor Man’s Cube Style Slice & Dice In A Query