SSRS Performance Dashboard - released!

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 […]

 

Using CTE with XMLNAMESPACES

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)
,CTE AS
(
SELECT ([some fields])

Continue reading […] Using CTE with XMLNAMESPACES […]

 

SSRS Performance Dashboard reports coming soon

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.