Browsed by
Category: SSRS

Managing Scheduled Reports

Managing Scheduled Reports

SQL Reporting Services has come a long way since 2000, but there are still plenty of ways it can be improved to benefit the end user the DBA.  Manually initiating a subscription is a tedious task in SQL Server Reporting Services. Each subscription in Reporting Services is setup as a SQL Server Agent job, but the job names are not intuitive, rather named as a Unique Identifier as shown below. In my current employment, the reporting server has over 400…

Read More Read More

Avoid SELECT *

Avoid SELECT *

Buffer Usage The Data Flow Task (DFT) of SSIS uses a buffer (a chunk of memory) oriented architecture for data transfer and transformation.  When data travels from the source to the destination, the data first comes into the buffer – required transformations are done in the buffer itself and then written to the destination. The size of the buffer is dependent on several factors – one of which is the estimated row size.  The estimated row size is determined by…

Read More Read More

Execute a Subscribed Report (Data Driven Subscription)

Execute a Subscribed Report (Data Driven Subscription)

A procedure that creates the effect of a data driven subscription by replacing the fields in an existing subscription with the supplied values, executing the report and then replacing the original values. INPUT:  @ScheduleID – The Job Name in SQL Server @EmailTo – The TO address of the email @EmailCC – The Carbon Copy address of the email @EmailBCC – The Blind Copy address of the email @EmailReplyTo – The Reply TO address of the email @EmailBody – Any text that you…

Read More Read More