Solved

SSRS/SSIS/SSAS changes between versions

Posted on 2010-08-26
8
827 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 500 total points
Comment Utility
0
 

Author Comment

by:ksfok
Comment Utility
Thanks. What about SSAS?
0
 
LVL 16

Expert Comment

by:vdr1620
Comment Utility
0
 

Author Comment

by:ksfok
Comment Utility
Above info for SQL Sever 2008 R2(SQL Server 2010)?
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 16

Expert Comment

by:vdr1620
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

763 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

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now