Solved

SSRS/SSIS/SSAS changes between versions

Posted on 2010-08-26
8
837 Views
Last Modified: 2016-02-14
What are the changes of SSRS/SSIS/SSAS between 4 versions SQL 2000, 2005, 2008  thru SQL2008 R2? Please provide a summary. Thanks.
0
Comment
Question by:ksfok
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +1
8 Comments
 
LVL 16

Accepted Solution

by:
vdr1620 earned 500 total points
ID: 33533030
0
 

Author Comment

by:ksfok
ID: 33533422
Thanks. What about SSAS?
0
 
LVL 16

Expert Comment

by:vdr1620
ID: 33533614
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:ksfok
ID: 33537656
Above info for SQL Sever 2008 R2(SQL Server 2010)?
0
 
LVL 16

Expert Comment

by:vdr1620
ID: 33538397
all the above are for 2005 and 2008.. i would suggest to use google a little for many other articles including one's for sql 2008 R2
0
 
LVL 30

Expert Comment

by:Reza Rad
ID: 33539523
in 2008 R2 there is no outstanding new feature in these technologies.
maybe sql server 2011 will come with new features
0
 
LVL 30

Expert Comment

by:Reza Rad
ID: 33539577
sorry in first post, I meant SSIS only.
and there are new BI evolution going to start with 2008 R2:
http://blogs.msdn.com/b/usisvde/archive/2009/12/23/explore-bi-features-of-sql-server-2008-r2.aspx
http://www.dbta.com/Articles/Editorial/Trends-and-Applications/BI-in-SQL-Server-2008-R2-Empowering-Business-Users-56067.aspx

2008 R2:
New Features for BI (Business Intelligence)
Reporting Service Enhancements

    * Map and spatial data visualization
    * Report Builder 3.0
    * ATOM data feeds
    * AJAX Report Viewer
    * Shared Data Sets
    * Enhanced SharePoint Integration for SharePoint 2007 and SharePoint 2010
    * New 2010 SOAP Endpoint
    * Aggregates of Aggregates and much more

Managed Self Service BI

Power Pivot for Excel

    * Brings analysis service to users desktop
    * Allows IT users to create solutions in Microsoft Excel interface
    * Data will be refreshed periodically

Power Pivot for SharePoint

    * Management dashboard for SharePoint administrators
    * Power Pivot health information, hardware resources and data refreshes will be available



Master Data Services

    * Helps an organization to manage master data
    * Data will be standardized, streamlined, and organized into relationships for analysis

0
 
LVL 3

Expert Comment

by:novaspoonman
ID: 33695833
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question