O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

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

Managing Analysis Services

If you’re responsible for maintaining a cube once the development phase is complete, the remainder of this chapter should be of high interest to you. Now it’s time to switch to a new environment, SQL Server Management Studio, to review its features for managing Analysis Services servers, including server configuration and deployment options for moving Analysis Services databases between servers. We’ll also review your options for managing scalability with partitioning, storage modes, and aggregations. Then, we’ll take a look at the various processing methods available for keeping cubes as up-to-date as possible and at security for managing access to cube data. Finally, we’ll briefly examine the use of SQL Server Profiler ...

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