How to build a SQL Server Virtual Lab with AutomatedLab in Hyper-V
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 primarily used it for creating proof of concept environments, ranging from single SQL servers, testing…
Managing SSRS security using PowerShell automation scripts
Take a look at my post over on SQL Shack about Managing SSRS security using PowerShell automation scripts
Managing SQL Reporting Services subscription failures
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 go into a lot of detail in my post on SQL Shack about a simple…
Writing for SQL Shack
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 issues Ill blog about over on SQL Shack though. It’s a great opportunity to contribute…
SSRS Log Monitoring
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 regularly. It still baffles me that SSRS doesnt have better error monitoring/logging for subscriptions in…
SSRS 2016 URL Format changes
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 2014 & below) you should be ok as the old format is still valid (…for now?)…
SOLVED: SSRS 2016 behind a Network Load Balancer
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 confirm. Ill leave the post intact as Im sure others will go through the same…
SSRS 2016 Brand Package breakdown
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 a giant leap in the right direction for the BI platform. There is a great…
SQL Server 2016 Training Lab
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 I completed the lab on a local SQL 2016 instance (instead of the Lab VM)…