O'Reilly logo

SQL Server MVP Deep Dives Vol. 2 by Kimberly Tripp, Paul Randal, Paul Nielsen, Brad McGehee, Greg Low, Louis Davidson, Kalen Delaney

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 54. Scripting SSAS databases – AMO and PowerShell, Better Together

Darren Gosbell

Have you ever found yourself clicking repetitively through an action in Business Intelligence Development Studio (BIDS)? Or struggling to compose XML for Analysis (XMLA) Create or Alter statements? Then read on to find out how to make your life a whole lot easier.

For designing and building Analysis Services databases, Microsoft has given you a great tool in the form of BIDS. For administrative tasks, you have SQL Server Management Studio (SSMS). These are both great GUI tools, but like all GUI tools, they fall short when you need to perform repetitive actions or when you have to automate a series of actions. Fortunately, both of these GUI tools have ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required