Explore Azure Data Studio, a lightweight, cross-platform tool for data professionals, in this comprehensive conference talk from PASS Data Community Summit. Discover the origins and evolution of this Microsoft tool, designed for managing and maintaining various data platforms beyond just SQL Server. Learn when to use Azure Data Studio versus SQL Server Management Studio through practical demonstrations. Gain insights into key features including dashboards, user snippets, database management, profiling, charting, scripting, and data visualization with SandDance. Master essential tasks like backup and restore operations, schema comparisons, and PowerShell integration. Dive into advanced capabilities such as Plan Explorer, Trusted Notebooks, and Docker support. Witness demonstrations of Big Data Clusters and source control integration. Equip yourself with valuable tips and tricks to enhance your efficiency as a data professional in this rapidly evolving field.
Overview
Syllabus
Introduction
SQL Server
Azure Data Studio
When should we use Management Studio
When should we use Azure Data Studio
Session overview
Dashboard
User Snippets
Change Database
Run Profiler
Create Charts
Create a Script
Sanddance
Backup and Restore
Schema Compare
Powershell
Plan Explorer
Trusted Notebook
Docker
Demo
Big Data Cluster
Big Data Cluster Demo
Source Control Demo
Taught by
PASS Data Community Summit
