Chapter 6

Analysis Services

Information in this chapter:

• Logging into Analysis Services

• Securing Analysis Services Objects

• Summary

Logging into Analysis Services

Microsoft SQL Server Analysis Services is a different kind of database engine from the traditional database engine that database administrators are used to working with. Analysis Services is designed as an Online Analysis Processing (OLAP) database engine. This database engine is especially designed for large amounts of data analysis and pre-aggregation of data.

Microsoft SQL Server Analysis Services was introduced in SQL Server 7 and it has been constantly improved release after release up through and including the SQL Server 2012 release. While the Microsoft SQL Server database ...

Get Securing SQL Server, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.