SQL PowerShell 2019 - The Lingua Franca for the Data Platform
PASS Data Community Summit via YouTube
Overview
Discover how PowerShell serves as a universal language for data platform management in this conference talk from PASS Data Community Summit. Learn to seamlessly navigate between Azure Data Studio, SQL Server, Azure SQL Database, and Excel using a single tool. Explore object-based approaches to data manipulation, aligning with PowerShell's native object-oriented paradigm. Gain insights into documenting and sharing PowerShell code through PowerShell Notebooks, enhancing collaboration with colleagues. Master the art of integrating various Microsoft data products, understanding cross-product data management techniques. By the end of the session, acquire the skills to leverage PowerShell for efficient data operations across multiple platforms and learn to create shareable, reusable PowerShell Notebooks for improved teamwork and productivity.
Syllabus
Intro
About me
Agenda
GitHub repo
Azure Data Studio
Get Azure Data Studio
Import SQL Server Module
Import Data from Excel
Get Excel Sheet Info
Import Excel Worksheets
Save Notebooks
Jupyter Books
SQL Server Module
Central Management Servers
Power BI Assets
Taught by
PASS Data Community Summit