Information about Report subscriptions is held in ReportServer.dbo.Subscriptions table. ExtensionSettings XML Fragment with root node <ParameterValues> Contains information about the format and destination of the report. Each <ParameterValue> element has child <Name> and <Value> nodes : named according to classical … Continue reading →
For measuring short durations, such as telephone calls or handling times. Q1 Linear Grain? The question I haven’t answered is whether the dimension should be at the finest grain for all durations. The grain I am using is seconds but … Continue reading →
Is it worth the effort? Advantages Can encapsulate a set of defaults. Pre-configurations of a very general report, for example. Disadvantages Links between reports take users to the master source folder. (!) Dynamic parameter defaults don’t survive linking. Instead the … Continue reading →
Display All Values on a Graph’s Axis Set Interval in Axis Options section to 1. Auto is normally too sparse for my liking on date axes. Setting an Interval expression disables auto-settings although the layout will still be adjusted automatically (staggered … Continue reading →
SSSB Endpoint Authentication Certificate Don’t forget to give this a long lifetime (if security policy allows) by using EXPIRY_DATE, otherwise the certificate expires after a year. CREATE CERTIFICATE [BrokerCertificateDec15] WITH SUBJECT = N’certificate_subject’, EXPIRY_DATE = N’2025-12-31′; Expiry of the certificate … Continue reading →
The SSRS Execution Account is a default Windows credential used by SSRS when running a report to access resources (e.g. file shares for image files) or databases for report datasources that do not require credentials and where Integrated Security is specified. … Continue reading →
Some functions for obfuscating data to protect personally identifiable data. Aims: fast enough to process a large table resulting data is “sufficiently” obfuscated resulting data retains enough characteristics that it makes some sense in context. transformations are repeatable so that … Continue reading →
Taking a database offline is probably less invasive than a detach-move files-reattach sequence. — Get file name and current location of files. SELECT name AS LogicalFileName, physical_name AS FileLocation, state_desc AS Status FROM sys.master_files WHERE database_id = DB_ID(‘RedgateMonitor’); USE MASTER — Alter … Continue reading →
Options for including literal values in scripts – syntax that I find particularly hard to remember. The feature is named Table Value Constructor. It was introduced in 2008 – see this article. Source of Merge statement MERGE INTO dbo.TargetTable AS Target … Continue reading →
Hiding Objects for Export CSV Titles and headings (other than column headings) are typically not required in CSV export. Text and column objects can be individually hidden from csv output: set the DataElementOutput property of the object to NoOutput PDF, Excel, etc Show … Continue reading →