SQLBits 2018
Administrating SSRS without boring web based clicks
Automate SSRS management using Microsoft's PowerShell module
Do you manage one or many SQL Server Reporting Services instances? Do any of them have multiple folders, dozens of reports or hundreds of subscriptions?
Historically, managing and/or migrating these subscriptions, reports and folders has been incredibly time-consuming. But what if you could leverage open source PowerShell module from Microsoft to simplify these and other SSRS management tasks? And what if those tasks could be accomplished 500 times faster than the web-based GUI?
Join this session and you'll see all of this action using real-world scenarios!
Historically, managing and/or migrating these subscriptions, reports and folders has been incredibly time-consuming. But what if you could leverage open source PowerShell module from Microsoft to simplify these and other SSRS management tasks? And what if those tasks could be accomplished 500 times faster than the web-based GUI?
Join this session and you'll see all of this action using real-world scenarios!
Speakers
Cláudio Silva's other proposed sessions for 2026
Performance of a T-SQL query - The mystery, the investigation and the root cause! - 2026
Accelerating Query Store data analysis with sp_QuickieStore - 2026
dbatools - Wheel of Fortune - 2026
Cláudio Silva's previous sessions
Let me show you why data types still matter
Selecting the right data types is still important. Let's see some examples of why!
Writing T-SQL code for the engine, not for you "more demos" by popular demand
Often because of how quickly we want to write a T-SQL query we create more extra work for the engine.
People underestimate the power of rewriting a T-SQL query, but in the right cases, it will provide better performance.
Let's look at some scenarios where this is true!
Hear me out - Don't go offline because of your index deployment strategy
Want to avoid downtimes or big blocking operations when managing indexes on busy systems?
In this session, we will talk about some common problems that can lead to unexpected downtimes and how we could avoid them.
Lift and Shift with dbatools - Azure SQL Managed Instance edition
Migrating from On-Prem SQL Server to Azure SQL Managed Instance requires a set of pre-requirements that can become much easier if we can validate and repeat the steps needed.
No matter if it's an Offline or Online migration, dbatools can make your life easier.
Administrating SSRS without boring web based clicks
Automate SSRS management using Microsoft's PowerShell module