A Data Blog
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...
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...
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...
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...
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.
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...
Check out my article on What’s New in Reporting Services (SSRS) 2017 over on SQL Shack!
There are many flavours of version control out there. Github, Bitbucket, Perforce etc. Ranging from publicly free to enterprise level. This project called for an interface with Perforce, which makes this post somewhat niche but similar principals could be applied...
Check out my post about Considerations for On-premises data in Power BI over on SQLShack
I am excited to announce that Dr Greg Low will be speaking in person at our next Glasgow SQL User Group session on the 23rd May! We had a great remote session with Paul Randal last month with a good turnout...
