SQL Server 2008 Reporting Service

Features in Repoting Service

• “Grab and Go” reporting experience enabled through the Report Part Gallery
• Support for maps and geospatial visualizations with integration to Bing maps and support for SQL spatial data types

• Additional visualizations including indicators, sparklines and data bars
• Support for consuming SharePoint lists and PowerPivot models as data sources
• Support for Madison and SQL Azure data sources
• Render any report as a data source to PowerPivot or other applications through ATOM data feeds
• Deliver reports more efficiently with the re-engineered report engine
• Limit memory usage and conflicts with non-memory bound reports
• Optimize report performance with on-demand processing and instance-based rendering
• Reach users across the organization with reports rendered in the format that makes the most sense for them
• Rendering options offer a variety of formats including HTML, PDF, CSV, XML, and Image (TIFF) as well as Microsoft Office Word and Excel
• Use subscriptions to deliver reports at a specific time and/or location
• Deliver reports through e-mail or post them to a shared folder on your network
• Enable business users to subscribe to reports, or create data-driven subscriptions to centrally manage automatic multi-recipient report delivery
• Use the Microsoft Report Viewer controls in Visual Studio to embed reports directly into your business applications or leverage the Report Viewer Web Server control to host reports in ASP.NET projects
• Publish reports to a Microsoft Office SharePoint report library or embed reports directly into portals by using the Reporting Services Report Viewer Web Part for renderings within SharePoint
• Schedule report execution, manage report subscriptions, and control access to reports through the Web-based Report Manager
• Integrate Reporting Services with Microsoft SharePoint Technologies for central manageability of reports in a familiar Office environment
• Deploy and manage all of your Reporting Services configuration options by using Reporting Services Configuration Manager

Small Script for resetting the identity column value in MS SQL Server

Normally on Microsoft Technologies we use Access or MS- Sql Server as a database. In a Software development scenario we use

Development Server ->Testing Server -> Production Server -> Client Server .

Now in this given scenario if people use Idendity Column in SQL Server Database then they come accross the problem of reseting it's value atleast i faced it and come to a solution as a script which can solve my problem at any stag as i need to reset all my identity columns on every stag. see it below

use <db_name>

DECLARE @reset_id varchar(200)

DECLARE reset_cursor CURSOR FOR

select Table_schema+'.'+Table_Name as tname from information_schema.tables

where Table_Type='BASE TABLE'

OPEN reset_cursor;

FETCH NEXT FROM reset_cursor

INTO @reset_id;

WHILE @@FETCH_STATUS = 0

BEGIN

DBCC CHECKIDENT(@reset_id,RESEED,0)

print @reset_id;

FETCH NEXT FROM reset_cursor INTO @reset_id;

END;

CLOSE reset_cursor;

DEALLOCATE reset_cursor;