Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SSRS/SSIS/SSAS changes between versions

Posted on 2010-08-26
8
Medium Priority
?
851 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
  • 3
  • 2
  • 2
  • +1
8 Comments
 
LVL 16

Accepted Solution

by:
vdr1620 earned 2000 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

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

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

When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
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.
Suggested Courses

579 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