Craig Porteous on Power BI Governance & Phil Grayson on streamlining SQL Server

June meetup
Title
3 ways to bring Power BI under Source Control

Summary
People love creating content in Power BI but how do we track changes or backup all these new reports? We’ll look at 3 different ways to bring your reports under source control and how to automate the process using Microsoft Flow, AzureDevOps and PowerShell.

Bio
Craig (@cporteous) is a Data Platform MVP working with Incremental Group as a Data Engineer. He has more than 10 years working with the Microsoft Data Platform and related technologies, supporting global BI Environments, automating processes with PowerShell and implementing BI Solutions. Craig is actively involved in the SQL community as a co-leader of the Glasgow SQL User group & creator of the DATA:Scotland Conference in Scotland.

Title
Standardise, optimise and streamline your SQL Server estate.

Summary
The Community Edition of Aireforge Studio is a free tool that focuses on making estate management simple. Learn how to compare configurations, users, settings, jobs and more, between 2 or 2000+ instances of SQL Server and Azure SQL Database. Also learn how to quickly documentation the configuration of your estate and how this process can be used to attached point in time snapshots with reports and tests that can be viewed or compare against later. Finally, the talk with cover how these tasks can be automated for alerting and integrated into build or deployment pipelines.

Bio
After spending 14 years creating one of the world’s largest central healthcare systems, Phil Grayson (@databoffin) now works as a consultant for xTEN, where his varied but in-depth experience has helped to transform IT systems worldwide. Phil is a proud Friend of Redgate, Chief Ticket Creator at Aireforge, organiser of Data & Gravy, Leeds SQL User Group and a frequent volunteer at SQLBits