My break time browsing list for 27th Aug
Reading Time: 2 minutes Here’s some interesting posts and videos that I’ve been looking at this week.
Tagged: powershell
REST API automation with PowerShell in Azure
Reading Time: 6 minutes The Power BI REST API opens a wealth of capabilities in consuming metadata about your content as well as batch processing of security changes, content deployment and backups of deployed reports. Although I talk specifically about Power BI, these methods...
Retrieve Azure Tenant Id using PowerShell
Reading Time: < 1 minute CodeSnippets #1 I have an idea to do a series of short blog posts over the year with helpful PowerShell functions, SQL code or problems I’ve encountered. The kind of thing I wouldn’t bother writing about as it would barely...
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...
How to build a SQL Server Virtual Lab with AutomatedLab in Hyper-V
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...
Managing SSRS security using PowerShell automation scripts
Reading Time: < 1 minute Take a look at my post over on SQL Shack about Managing SSRS security using PowerShell automation scripts
AD Group Auditing with Powershell
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...
SSRS Log Monitoring
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...
SPN & Delegation backup script
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...
