A Data Blog
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...
Take a look at my post over on SQL Shack about Managing SSRS security using PowerShell automation scripts
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...
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...
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...
Mini-Post! A small change to remember when looking to upgrade to SQL & SSRS 2016 is a change to the Report Manager URL format. If you have any apps or custom scripts that build or use existing report URLs (for...
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...
With SQL Server 2016 you now 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...
This training lab provided by Microsoft for the new SQL Server 2016 Mobile reporting functionality turned out to be a great tool for pulling together a quick Proof of Concept. I hope this info helps someone with the same task. When...
