Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

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

Reviews

Start your review of SQL PowerShell 2019 - The Lingua Franca for the Data Platform

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.