Reporting Services – Page 14 – SSRS, Reporting Services, SQL Server, Business Inteligence, Pentaho, T-SQL

August 2, 2019August 4, 2019

SSRS Reporting Service URL commands

When you would like to access Report Server from your application or just link reports, you can use URL of Report Server for such a task. URL access to Reporting Services supports few useful commands you can handle visualisation your reports.

There are following sets of commands you can change look your Reporting Services.

HTML Viewer Commands (rc:) – you can collapse expand Report Viewer toolbar, Zoom Report, Go to specific page, etc.
Report Server Commands (rs:) – export format of reports, list Reporting Services repository, etc.
Report Viewer Web Part Commands (rv:) – SharePoint mode

Find more info here: https://bit.ly/2SYlgr0 .

Find few examples bellow.

Hide Toolbar with parameters.

http://dwh/Reportserver?/Blog/ReportSales7 - Interactive sorting&rc:Parameters=Collapsed

Go to second page.

http://dwh/Reportserver?/Blog/ReportSales0 - Detail data&rc:Section=2

List reports in directory.

http://dwh/Reportserver?/Blog/&rs:Command=GetChildren

Get PDF format of report.

http://dwh/Reportserver?/Blog/ReportSales0 - Detail data&rs:Format=PDF

July 21, 2019July 21, 2019

Extended events get description

Useful query to get basic overview of extended events, actions and targets and their description.

SELECT p.name AS [Package-Name], o.object_type, o.name AS [Object-Name],  o.description AS [Object-Descr], p.guid AS [Package-Guid]
FROM sys.dm_xe_packages AS p
JOIN sys.dm_xe_objects  AS o ON p.guid = o.package_guid
WHERE o.object_type = 'event'

SELECT p.name AS [Package-Name], o.object_type, o.name AS [Object-Name], o.description AS [Object-Descr], p.guid AS [Package-Guid]
FROM sys.dm_xe_packages AS p
JOIN sys.dm_xe_objects  AS o ON p.guid= o.package_guid
WHERE o.object_type ='action'

SELECT p.name AS [Package-Name], o.object_type, o.name AS [Object-Name], o.description AS [Object-Descr], p.guid AS [Package-Guid]
FROM sys.dm_xe_packages AS p
JOIN sys.dm_xe_objects  AS o ON p.guid = o.package_guid
WHERE o.object_type = 'target'

July 19, 2019July 19, 2019

Extended events query plan

I need to cover few scenarios related to SQL statements or procedures and their Execution plans and IO statistics:

To monitor stored procedures performance running on server
To get execution plan from procedures not easily accessible from management studio
- Procedures called from Service Broker applications
- Complicated access to execution plan (Huge nested level of SQL statement – cursors)
Compare batches in testing labs

I decided to use Extended Events as lightweight solution for such a scenario.