|
|
Home > Computers and Information Technology > Computer Technology & Equipment > Servers
An OLAP Report Review: Microsoft SQL Server Analysis Services 2005
|
| Published Date:
February 2007
Published By:
BARC
Page Count:
50
Order Code:
R3485-8
|
|
|
|
Nigel Pendse's review of Microsoft's mass market OLAP server now includes previews of Katmai (SQL Server 2008) and PerformancePoint - the financial analytical application scheduled for release in late 2007
Although more than two years later to market than Microsoft had originally announced, SQL Server & Analysis Services 2005 have represented a significant advance on the previous releases in many areas. For example, data access capabilities, including from relational sources, have improved greatly.
This review evaluates the extended scope of Analysis Services including:
- Its close integration with SQL Server 2005
- Improved security features
- Extended time-series intelligence.
It also explores the implications of the replacement of Data Transformation Services by Integration Services, and explains other new features including the move of MDX calculations from the client to the server and the resulting scalability characteristics.
Although Analysis Services offers a greater scalability and new features, the review warns that it is now a much more technical product than its predecessor making the product more suitable for professional developers, rather than end users.
Among high-scoring features, the review describes its database structural flexibility, security and multi-user capabilities. There is also an assessment of its relatively low scoring performance in respect of its portability support and exception alerting. Despite the market leading position of this product, beware of problems with patchy local support provided by Microsoft for multidimensional technology.
Please note: The report file is password protected. Password will be delivered with PDF file. The PDF file may not be saved, however, one hard copy may be printed.
|
Similar Products
• Server Hardware and System & Network Management Software Market 2007-2010 - Bundled Report
Published Oct 2008 by Infiniti Research Limited
• Server Hardware and System Integration & Migration Services Market 2007-2010 - Bundled Report
Published Oct 2008 by Infiniti Research Limited
• Server Hardware & System Software Market 2007-2010 - Bundled Report
Published Oct 2008 by Infiniti Research Limited
• Perspectives on the HP ESS EMEA Analyst Summit 2008
Published Oct 2008 by IDC
• Western European Server Update, September 2008
Published Oct 2008 by IDC
• Western European Update, August 2008
Published Oct 2008 by IDC
• Lenovo Joins the Party and Starts Shipping x86 Servers
Published Oct 2008 by IDC
• Lenovo Launches ThinkServer Line for SMBs: Leveraging or Challenging IBM's Heritage?
Published Oct 2008 by IDC
• VMworld 2008 - Virtualisation Gets Cloudy
Published Oct 2008 by IDC
• Enterprise Security Appliance Spending by Size of Business and Vertical Industry, 2007-2012 (Data File)
Published Oct 2008 by In-Stat
|
|
|
|
0 items
