SSRS is Microsoft's answer to business reporting. It provides a unified, server-based, extensible, and scalable platform from which to deliver and present information. Its scope extends from traditional paper reports to web-based delivery and interactive content. SSRS can also be configured to deliver reports to peoples' inboxes, file shares, and so on. SSRS is capable of generating reports in various formats, such as the web-oriented Hypertext Markup Language (HTML) and desktop application (Microsoft Excel and CSV) formats, thus allowing users to manipulate their data in whatever format is required. In addition, SharePoint can be used as a front end for SSRS, allowing reports to be presented directly in corporate portals.
SSRS is just one of the components in the Microsoft Business Intelligence (BI) platform. Combined, those components provide an excellent platform for enterprise data analysis. The Microsoft BI platform includes the following:
The advantages of SQL Server 2008 over SQL server 2005 is given bello
In sql server 2005, There is no option to compress backup files, but in sql server 2008,there you find it.
Storing backup file takes 5 minutes without compression in sqlserver 2005,but it takes only 3 minutes in sql server 2008 for storing backup files with compression.
CPU is used to compress the data before it is written to disk,so less data is written to disk.
There are many new features, so it depends on what you need. If you store large files in SQL Server, migrated from Oracle and want to use date and time data types, need to encrypt your databases, etc you will definitely want to look at 2008. The nice thing is that it upgrading should be much easier from 2005 to 2008 than it was from 2000 to 2005.
Server 2008 also added CMS which is Central Management Server. It only works with Windows Authentication but it allows you to management multiple SQL Servers at once. If SQL Server systems are popping up like weeds it will appear in the CMS provided that they point to the CMS via SSMS. It's a really cool feature.
One of my favorite is that fact that Reporting Services no longer requires IIS as it makes direct calls to HTTP.SYS.
Mesh_2010, if this helps please login to Mark As Answer. | Alert Moderator