Category: SQL Server 2016
Reading Time: < 1 minute CodeSnippets #2 This is a query I would run when I needed to quickly make bulk changes to Reporting Services subscriptions. It’s part of an “emergency fix” toolkit. Maybe a DB has went down and I have to quickly suspend...
Reading Time: < 1 minute This is something I worked on about a year ago, implementing before I left my previous employer. We had a massive overhead for managing our Reporting Services (SSRS) environments and this became a win-win solution for security and administration. It...
Reading Time: < 1 minute A few weeks back I wrote an article on SQL Shack on how to build a SQL Virtual Lab using the AutomatedLab module in PowerShell. This is an incredibly powerful module and great for any number of situations. I have...
Reading Time: < 1 minute Take a look at my post over on SQL Shack about Managing SSRS security using PowerShell automation scripts
Reading Time: < 1 minute This is a solution I’ve had to put in place in almost all BI positions in some form or another. Its something that remains a “custom workaround” through all versions of SQL Server Reporting Services, right up to 2016. I...
Reading Time: < 1 minute News! I’m now splitting my blog posts between here & SQL Shack. You’ll see mostly non-SQL content here. I’m still working with Powershell a lot so Ill post any handy scripts I put together here. All SQL based how-to’s and...
Reading Time: 4 minutes This is something Ive put together to keep track of errors coming through the SSRS logs. We capture the majority of priority errors through other methods but I find some still slip through if you’re not checking your log files...
Reading Time: < 1 minute Mini-Post! A small change to remember when looking to upgrade to SQL & Reporting Services 2016 or above is a change to the Report Manager URL format. If you have any apps or custom scripts that build or use existing...
Reading Time: 2 minutes UPDATE 1 (19/07/2016): After posting this to twitter last night I got some instant help from the Senior Program Manager for SSRS at Microsoft. Thanks to Riccardo Muti for the info. I will update here again when Ive been able to...
Reading Time: 4 minutes Starting with SQL Server 2016 you have the ability to customise the SSRS Report Manager’s look & feel. This comes in the form of applying a “Brand Package”. Its not free reign over the css for the site but its...