Deploy SQL Server Performance Dashboard Reports to Your SSRS Server

[SQLvariant]

Thanks to everyone who watched my demo last night on how to quickly deploy the Tiger teams' SQL Server Performance Dashboard reports to your SSRS Server [without downloading SSDT just to change the name of the report server!].

As promised, here is the link to the blog post about how the reports work: https://blogs.msdn.microsoft.com/sql_server_team/sql-server-performance-dashboard-reports-unleashed-for-enterprise-monitoring/

Here is the link to my PowerShell script in the Tiger team's "toolbox" repo up on GitHub: https://github.com/Microsoft/tigertoolbox/blob/master/SQL-performance-dashboard-reports/Deploy.ps1

For everyone who just wants to be able to deploy entire folders worth of SSRS objects (Reports, DataSets, & DataSources) to your SSRS servers with a single command, just run this in PowerShell [obvious requisite warning: this downloads code from the internet to your machine]:

Invoke-Expression (Invoke-WebRequest https://aka.ms/rstools)

The command mentioned above is Write-RsFolderContent and you will need to supply values for it's -ReportServerUri, -Path, & -Destination parameters.

I'm still finishing up the article I mentioned last night and will follow up with a link to it when it's finally published. 

I hope this helps you and please don't hesitate to ask me if you have questions about how this all works! 

:-)

[SQLvariant]

Hey Everyone,

I just wanted to follow up and post a link to my article that I mentioned "PowerShell Commands for SQL Server Reporting Services"

https://www.mssqltips.com/sqlservertip/4738/powershell-commands-for-sql-server-reporting-services/

The article will walk you through a few more of the details about how to deploy SSRS reports in bulk with the new PowerShell commands for SSRS.