SQLServerCentral.com Articles tagged AMO

Create SQL Server Analysis Services Partitions using AMO

Mon, 19 Nov 2012 07:00:00 UT

When you have SSAS cubes with millions of rows of data, it is very helpful to create partitions. If you have a few cubes you could probably do this manually, but if there are many or if you want to automate this process you should look for smarter solutions such as programming the creation of partitions dynamically.

Managing Data Dictionaries in DW and DSS Database Applications

Tue, 20 Dec 2011 07:00:00 UT

Second in the series of tools & techniques to help manage aspects Of Enterprise BI implementation.

Script a cube using Windows PowerShell and AMO

Tue, 12 May 2009 06:00:00 UT

This installment of "Windows PowerShell and AMO" covers how to script a cube from a SQL Server Analysis Service instance to XMLA format file.

Script dimensions using Windows PowerShell and AMO

Fri, 01 May 2009 06:00:00 UT

Part 11 of our series on "Microsoft Windows PowerShell and SQL Server 2008 AMO" discusses how to generate a script for given dimension of the Analysis Service database to XMLA format file.

Detach and attach Analysis Service Database using Windows PowerShell and SQL Server 2008 AMO

Fri, 17 Apr 2009 06:00:00 UT

This installment of our series on " Microsoft Windows PowerShell and SQL Server 2008 AMO" examines the various types of Analysis service database detach and attach methods.

Process Dimensions in an Analysis Service database

Wed, 11 Mar 2009 06:00:00 UT

Continuing our series on our "Microsoft Windows PowerShell and SQL Server 2008 AMO," Part 8 covers how to process a dimension in an Analysis Service database using Windows PowerShell and SQL Server 2008 AMO.

Get alerts within 15 seconds of SQL Server issues
SQL Monitor checks performance data every 15 seconds, so you can fix issues before your users even notice them. Start monitoring with a free trial.

Get SSAS Database Properties with PowerShell and AMO

Mon, 05 Jan 2009 07:00:00 UT

Learn how to use Windows PowerShell and AMO to retrieve the database properties of SQL Server Analysis Service.

Discover Analysis Service's Properties using Windows PowerShell and AMO

Fri, 12 Dec 2008 07:00:00 UT

Part 2 of this series illustrates how to use Windows PowerShell and AMO to get the various Server properties of SQL Server Analysis Service.

Managing SQL Analysis Service Objects with SSIS and AMO

Fri, 02 May 2008 06:00:00 UT

You can manage SSAS objects using AMO and SSIS which enables you to have detailed control of SSAS Administrative tasks.