Category Archives: SSAS

INVENTORY – SQL- SSAS – SSRS – Excel Output – Email

Inventory Inventory is a vital information,whether you’re a consultant or an in-house DBA, you need to have a reliable inventory of the servers you manage.This inventory can take any number of forms but, ideally, will allow some aggregation of information.Β When … Continue reading

Posted in PowerShell, SQL, SSAS, SSRS, T-SQL | Tagged , , , , , , , | 2 Comments

SSAS – Automatic Inventory Generation – 24 Columns – HTML Attachment

Inventory is a vital information,whether you’re a consultant or an in-house DBA, you need to have a reliable inventory of the servers you manage. This inventory can take any number of forms but, ideally, will allow some aggregation of information. … Continue reading

Posted in SSAS | Tagged , , , , , , , , | 1 Comment

SSAS Cube Backup strategies and Step by Step approach to setup and configure backup

There are different ways to take Cube database backups. SQL Agent Job XMLA script for backup ROBOT job ASCMD command SSIS Package SSIS package AMO (Analysis Management Objects) PowerShell Scripts I feel AMO (Analysis Management Objects) does our job much … Continue reading

Posted in SSAS | Tagged | 8 Comments

SSAS – Find Cube Database Name, Size,Status and Total Size of SSAS Server

We are planning to take SSAS cube database backup since our backup tool does full file system backup in case of recovery, restoration is taking more time and hence as a first step we are started gathering the number of … Continue reading

Posted in PowerShell, SSAS | Tagged , , | 4 Comments