After a few modifications, the stable version of SSRS Performance dashboard reports is released and available for download.
The reports are a simple set of Custom reports which run towards the Report Server database and can be used to view performance, configuration and security information about your SQL Server Reporting Services installation.
The reports can be easily
Continue reading […] SSRS Performance Dashboard – released […]
I really want to use a XML query with a CTE. But how?
The rules are that the WITH XMLNAMESPACES has to begin with ; to distinguish it from other statements, and so does the CTE definition.
Well, the solution is simple:
Just use the following syntax:
?View Code TSQLWITH XMLNAMESPACES(’http://schemas.schema.com/SomeSchema’ as ns)
SELECT ([some fields])
Continue reading […] Using CTE with XMLNAMESPACES […]
I have created a set of SSRS Dashboard reports and soon I will publish them for download.
For now, you can get some more information about the project by going to the SSRS Performance Dashboard home page.
You can also view some screenshots by visiting the SSRS Performance Dashboard screenshots page.