What is SSRS in Sql server

Posted by Mesh_2010 under Sql Server on 5/2/2011 | Points: 10 | Views : 2201 | Status : [Member] | Replies : 5
Hi

1. What is SSRS in Sql server, please describe detail.
2. What is difference between SQL Server 2005 and 2008

Thanks
RameSH sinGH



Responses

Posted by: Prabhakar on: 5/2/2011 [Member] [MVP] Starter | Points: 25

Up
0
Down
Hi ramesh

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can be used to prepare and deliver a variety of interactive and printed reports. , .

Go to this link . . and read about SSRS
http://msdn.microsoft.com/en-us/library/ms159106.aspx



Best Regard's
Prabhakar

Mesh_2010, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Ray.chayan on: 5/2/2011 [Member] Starter | Points: 25

Up
0
Down
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:
1) SSIS
2) SSAS
3) SSRS

The advantages of SQL Server 2008 over SQL server 2005 is given bello w.

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

Posted by: Mesh_2010 on: 5/2/2011 [Member] Starter | Points: 25

Up
0
Down

thanks Ray chayan

Thanks
RameSH sinGH

Mesh_2010, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Ray.chayan on: 5/2/2011 [Member] Starter | Points: 25

Up
0
Down
Welcome Ramesh,
I am very much happy by helping you. If it really helps you then please mark my answer.

Mesh_2010, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Susanthampy on: 5/19/2011 [Member] [MVP] Bronze | Points: 25

Up
0
Down
hi,

refer this,

http://msdn.microsoft.com/en-us/library/ms159106.aspx

Regards,
Susan

Mesh_2010, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response