Browse by Tags

• 2005
• 2008
• 2008 R2
• Business Intelligence
• Data Warehouse
• Integration Services
• PowerShell
• SSIS
• XMLA

• Spotlight session at PASS 2011 - Temporal Snapshot Fact Table

  I’m very happy to announce that my proposal for the Spotlight session I’ve been invited to deliver at PASS 2011 has been accepted! Temporal Snapshot Fact Table You are designing a BI Solution and your customer ask you to keep a snapshot of the status Read More... Posted Sunday, May 29, 2011 4:44 PM by Davide Mauri | 7 Comments Filed under: 2005, 2008, 2008 R2, Analysis Services, Business Intelligence, Data Warehouse, Integration Services, SSAS, SSIS

• SSAS Backup and other useful PowerShell scripts

  Today I was looking for a Powershell script to automatize the backup of Analysis Services database also capable to manage retention. In such search I stubled upon the SSASBackp PowerShell script created by Idera which is also released for free. There’s Read More... Posted Friday, July 30, 2010 7:34 PM by Davide Mauri | 5 Comments Filed under: Analysis Services, PowerShell, SSAS, XMLA