Speaking at SQLGrillen

Speaking at SQLGrillen

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 online forums as the way I’d contribute to the community. Nothing else seemed plausible or achievable,…

By Craig 4th July 2018 0

Spinning plates and Power BI Licensing

Spinning plates and Power BI Licensing

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 inbox with 120 Sessions, blogging has taken a back seat. We want to say a…

By Craig 3rd May 2018 0

Top 10 things to document in SSRS

Top 10 things to document in SSRS

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 the years. I luckily didn’t experience any catastrophic failures where I needed ALL of these…

By Craig 27th February 2018 0

I published a PowerShell Module!

I published a PowerShell Module!

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 skills progressed over the last 12 months. It was a few  months ago that I…

By Craig 16th January 2018 0

Managing Power BI Dataset Refresh Failures

Managing Power BI Dataset Refresh Failures

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 to speak about it at the Glasgow PowerShell & DevOps user group meeting in November…

By Craig 30th November 2017 0

TSQL Tuesday #96: Who made a difference

TSQL Tuesday #96: Who made a difference

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 year, #SQLGLA. This was by no means a solo effort of course & I’d like…

By Craig 14th November 2017 0

Administering SSRS with PowerShell

Administering SSRS with PowerShell

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 module and see what else the module offers. The first thing you’ll want to do is…

By Craig 12th September 2017 0