This is NOT a New Year’s Resolution
Reading Time: 5 minutes The single, finite resource in all my achievements and responsibilities is time. Does anyone know where I can find more?
How to secure Reporting Services with Group Managed Service Accounts
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...
Project Death March
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...
Glasgow Hacktoberfest Workshop
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...
Speaking at SQLGrillen
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...
Spinning plates and Power BI Licensing
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...
Top 10 things to document in SSRS
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...
I published a PowerShell Module!
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...
Clustering the Power BI Data Gateway for High Availability (and Low visibility?)
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...
Managing Power BI Dataset Refresh Failures
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...
