Azure Data Studio CrossPlatform Cloud and OnPremise Database

Azure Data Studio Cross-Platform, Cloud and On-Premise Database Tool Andrew Loree

Got a question? Andrew Loree www. andyloree. com andy@andyloree. com

Expectations & Assumptions What is your role? • App Developer • SQL admin/platform DBA • Something else?

Goals – To Understand… • What is Azure Data Studio • Data Studio vs SSMS • FAQ • See it in action - demos • Getting around • Server Groups • Source Control and Workspaces • Extensions and Authoring your own

What is Azure Data Studio? • Formerly preview named SQL Operations Studio • Cross-platform database tool for Microsoft onpremises and cloud data platforms • Windows • Mac. OS • Linux • Based from VSCode, modern, keyboard focused coding experience • Now Multi-database - Pos

What is Azure Data Studio? Modern • Lightweight - Zero install option • Releases ~ frequent releases • Open-sourced - https: //github. com/Microsoft/azuredatastudio • Electron– built with html, css and JS • Keyboard centric - did I mention that? • Themes – darkness is upon us

Azure Data Studio vs SSMS is… • NOT easily/fully extensible • NOT lightweight • NOT easy to navigate via keyboard • NOT 64 -bit Azure Data Studio is… • NOT a replacement of SSMS • NOT the only tool you will ever need • NOT just for developers

Azure Data Studio vs SSMS Azure Data Studio IS… • easily extensible • unified experience across different data sources • a non-wizard experience • all about the keyboard Consider Data Studio another tool in the toolkit

Azure Data Studio vs SSMS Shell Features Feature Azure Data Studio SSMS Azure Sign-In Yes Dashboard Yes Extensions Yes Integrated Terminal Yes Object Explorer Yes Object Scripting Yes Project System Yes Select from Table Yes Source Code Control Yes Task Pane Yes Theming Yes Dark Mode Yes Azure Resource Explorer Preview Yes Generate Scripts Wizard Yes ImportExport DACPAC Yes Object Properties Yes Table Designer Yes https: //cloudblogs. microsoft. com/sqlserver/2018/09/25/azure-data-studio-for-sql-server/

Azure Data Studio vs SSMS Query Editor Feature Azure Data Studio SSMS Chart Viewer Yes Export Results to CSV, JSON, XLSX Yes Intelli. Sense Yes Snippets Yes Show Plan Preview Yes Client Statistics Yes Live Query Stats Yes Query Options Yes Results to File Yes Results to Text Yes Spatial Viewer Yes SQLCMD Yes Operating System Support Feature Azure Data Studio Linux Yes mac. OS Yes Windows Yes SSMS Yes https: //cloudblogs. microsoft. com/sqlserver/2018/09/25/azure-data-studio-for-sql-server/

Azure Data Studio vs SSMS Database Adminstration Feature Azure Data Studio SSMS Backup / Restore Yes Flat File Import Preview Yes SQL Agent Preview Yes SQL Profiler Preview Yes Always On Yes Always Encrypted Yes Copy Data Wizard Yes Data Tuning Advisor Yes Error Log Viewer Yes Maintenance Plans Yes Multi-Server Query Yes Policy Based Management Yes Poly. Base Yes Query Store Yes Registered Servers Yes Replication Yes Security Management Yes Service Broker Yes SQL Mail Yes Template Explorer Yes Vulnerability Assessment Yes XEvent Management Yes https: //cloudblogs. microsoft. com/sqlserver/2018/09/25/azure-data-studio-for-sql-server/

Azure Data Studio FAQ Cost? Free for private and commercial use Will SSMS be open sourced? Are SSMS (and SSDT) dead? No No, dev continues and SSMS is the flagship Windows tool, but Azure Data Studio will continue to allow for customer choice in tools and platforms

Azure Data Studio FAQ I want feature X, will you add it? File an issue on github, active development So is SMO API now available on Linux/Mac. OS? Only a subset of the SMO API has been ported, but will continue under the SQL Tools Service https: //github. com/Microsoft/sqltoolsservice What about SQL Powershell SQL PS Cmdlets on Linux/Mac. OS are on the roadmap

Demo: Getting around Azure Data Studio • Code & Terminal • Snippets & Shortcuts • Customizing • Dashboards & Insight Widgets • Server Groups

Demo: Source Control and Workspaces • GIT & Open Folder • Workspaces

Demo: Extensions and Authoring Your Own • Show installing and disabling extensions • Setting up dev environment • VSCode • Node. js - https: //nodejs. org/en/ • Add Yeoman package – npm install yo generate-sqlops • Building your own in VSCode • Got a cool extensions? At to the marketplace https: //github. com/Microsoft/azuredatastudio/blob/release/extensions/extensio ns. Gallery. json

Whats new with Azure Data Studio • Keep up to date from the release notes or for advance info watch github commits • SQL 2019 Preview Extension adds… • Juypter Notebooks! – TSQL Support coming soon • Azure Resource Explorer – Cloud data tools in one place • External Table Wizard • Big. Data cluster support

Demo: SQL 2019 Preview Extensions • SQL 2019 Preview Extension adds… • Azure Resource Explorer – Navigate Azure SQL and SQL DW • External Table Wizard • Big. Data cluster support

Got a question? Andrew Loree www. andyloree. com andy@andyloree. com