Utah County SQL Server User Group

Welcome to the Utah County Chapter

Next Meeting




Powershell, Power BI and Docker

  • In-Person @ 1220 S. 630 E. American Fork, Utah, United States (map)
  • 15:00 - 17:00 (UTC-07:00) Mountain Time (US & Canada)
  • Language: English

Come to our monthly meeting to visit, network, ask questions and increase your knowledge and skill.  Details are below, see you there!

Featured Presentation:

Powershell, Power BI and Docker

Aaron Nelson, Senior Consultant - Data & AI Microsoft

In this presentation, we’ll see how we can move smoothly from Azure Data Studio, to SQL Server, to Azure SQL Database, to Excel. And we’ll do it all with a single tool, PowerShell. We’ll also see how we can take an object-based approach to working with data. In doing so, we’ll be speaking PowerShell’s native language, objects. I'll show you how PowerShell lets us dynamically create a Power BI dataset and publish the data to the Power BI Service. Based on this we’ll see how to create environments for Dev, QA, and Prod in a reliable, repeatable way, support multi-tenant solutions, and reuse the same report with different data for each customer. Finally, I'll show you how to get started with SQL-on-Linux containers in Docker. In 5 lines of code and enough time to get coffee, we’ll have SQL Servers that we can query. We’ll cover everything you need to get started as well as how containers support QA and Dev environments.

About Aaron:
Aaron Nelson is an author, public speaker, blogger, and leader in the community. He has over 15 years of experience in architecture, Business Intelligence, development, and performance tuning of SQL Server. Aaron has received many certifications and is a six time winner of the Microsoft MVP Award. Aaron leads the PowerShell Virtual Group of PASS (SQLPS.io), is a board member of PowerShell.org, and is a volunteer at his PASS Local Group, AtlantaMDF.




Back to Top