A Data Blog
Reading Time: 1 minute It’s been a few months now since I last blogged, here or on SQLShack. I started as a Data Engineer with Incremental Group back in March and with SQLGLA prep heating up and the Call for Speakers blowing up my...
Reading Time: 1 minute Today is my last day at Monster Worldwide and it occurred to me in the lead up to it that there is quite a few components of SSRS and metadata that I’ve documented, put under source control or extracted over...
Reading Time: 2 minutes I’ve been working with Power BI metadata a lot lately. Analysing and sourcing information about the security, content and workspaces we hold and I always found myself re-using authentication code or I’d end up approaching problems differently as my PowerShell...
Reading Time: 4 minutes The functionality to cluster the Power BI Data Gateway for high availability was introduced with the November update of the Data Gateway. This has been in the works for a while though I must admit the workaround I describe back...
Reading Time: 1 minute I’ve been working on Power BI administration a lot lately. It’s something I’ve used to begin implementing coding standards around PowerShell at my employer. Although I blog about the topic in some detail over on SQL Shack, I also decided...
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: 3 minutes For this TSQL Tuesday I am thankful for the non-technical topic and the reason for that is the exact topic of this post. 4 days ago I hosted the only free data platform event in Glasgow & even Scotland this...
Reading Time: 1 minute If you’ve not seen anything about this yet, jump over to the Glasgow SQL User Group site or to the event’s page and sign up.
Reading Time: 4 minutes I’ve covered a lot of SSRS security tasks using PowerShell over on SQL Shack where I connect directly using the New-WebServiceProxy command. For T-SQL Tuesday I wanted to do a quick comparison between my original method and the official Reporting Services...
Reading Time: 1 minute Check out my article on What’s New in Reporting Services (SSRS) 2017 over on SQL Shack!
