SQL Server Uncategorized
Managing the Report Content Using Report Manager : Subscriptions
In last article Managing the Report Content Using Report Manager: Caching we looked at caching and maintaining the history of the SSRS report. In this article we will be focusing on subscriptions. Reporting services comes with two methods of subscriptions: Windows File Share : Using this method you can place your report in the shared [...]
Managing the Report Content Using Report Manager: Part I
What is Report Manager? Report Manager ships with Microsoft SQL Server Reporting Services and is a web application for managing deployed reports. The features of the report manager can be divided into following types:- General Features: Creation of folders, folder hierarchies and data sources. Printing, searching, hiding, renaming, deleting ,downloading and moving the reports and data [...]
Transactions in SQL Server Part I – An Introduction
A basic requirements in most SQL Server based applications is implementing a database operation (DDL or DML) in a single unit of work. The DDL requirement is more from a DBA’s perspective rather than the application, since any application would perform only INSERTs, UPDATEs and DELETEs on the existing data, and a DBA would be [...]