SQL Server Performance Dashboard Reports

Out of many good things I love following two great features in SQL Server 2005

1. SQL Server Dynamic Management Views or DMVs
2. SQL Server Reporting Services or SSRS

SQL Server 2005 exposes too much information about its internal working for a DBA to better tune the server but this information is hidden in different dynamic management views, counters and other SQL Server 2005 components. If you really want to master SQL Server 2005, you must have a very good knowledge of dynamic management views or DMVs.
Plus, if you want to master Reporting Services 2005 i.e. SSRS with techniques like:

1. Charting
2. Linked Reports
3. Creating Reports Portal
4. Passing Parameters between reports etc.

then look no further and download SQL Server Performance Dashboard Reports from here.
These reports not just exposes SQL Server 2005 internal statistics in an excellent graphical manner, they also provide queries to find SQL Server statistics by DMVs. In addition with these queries, you will also learn how Reporting Services works. You will learn how you can implement graphs, linked reports etc. So don’t waste more time:):) Start downloading SQL Server Performance Dashboard Reports.

Display data in your own way: Custom Report Item in Reporting Services 2005

Displaying a progress bar for each row in a report or displaying a traffic light type status indicator for each row in SQL Server Reporting Services (SSRS) is not possible directly because SSRS just provide you a set of very basic report items like Line, Image etc.

But since Microsoft always design products with extensibility in mind, so we have a solution here which is Custom Report Item or CRI.

Custom Report Items are there to provide you a framework in .NET which you can use to implement your own graphical controls to display your data in your own way. These controls can be used to do virtually anything under .NET framework.

Following are some excellent resources to start with:

Jazz up your data Using custom report items
http://msdn.microsoft.com/msdnmag/issues/06/10/SQLServer2005/default.aspx

Chris Harys Reporting Services Weblog
http://blogs.msdn.com/chrishays/archive/2005/10/04/CustomReportItemSample.aspx