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
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
This post shows how I created, generated data for and used "StorageDimension" with PowerBI to slice and dice by that dimension.
This blog post shows how I created, generated data for and used a "Duration" dimension with SQL Server and PowerBI
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