A Data Blog
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 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: 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 Take a look at my post over on SQL Shack about Managing SSRS security using PowerShell automation scripts
Reading Time: 6 minutes Here’s another handy Powershell script Ive created. It borrows components from another(credited at the bottom of the post) and expands on the repadmin functionality in the Active Directory Powershell module. The main aim of this is to keep track of...
Reading Time: 4 minutes This is something Ive put together to keep track of errors coming through the SSRS logs. We capture the majority of priority errors through other methods but I find some still slip through if you’re not checking your log files...
Reading Time: 3 minutes I use SPNs quite extensively to allow Reporting Services to talk to databases severs, Sharepoint etc. It’s a core component of any new server setup I perform. We also employ Kerberos delegation that allows credentials to be passed down from the...
