A Data Blog
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: 3 minutes For this month’s #tsql2sday, Jeff Mlakar asked for people to share a story about a project you worked on or were impacted by that went horribly wrong. (Jeff’s Invitation) One such story stands out from early on in my career...
Reading Time: 2 minutes Paul Broadwith (@Pauby)& I (@CPorteous) are running a Hacktoberfest workshop on Saturday the 27th of October @ Incremental Group, the Garment Factory, Montrose St, Glasgow Who is it for? If you’ve never used version control before, played around with...
Reading Time: 6 minutes SQLShack recently published a blog post I wrote on contributing to “the” community, the SQL community in my case. In that article I concentrated heavily on blogging as the medium, not speaking. I always saw bloging and helping people on...
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...
