Whats new in SQL Server Tools Julie Koesmarno

What’s new in SQL Server Tools Julie Koesmarno, Program Manager @ Microsoft @Ms. SQLGirl

Own your career with interactive learning built by community and guided by data experts. Get involved. Get ahead. Explore your PASS community Free online webinar events Local user groups around the world Connect with the global data community . org Online special interest user groups Learning on-demand delivered to you Get involved

Missed PASS Summit 2019? Get the Recordings Download all PASS Summit sessions on Data Management, Analytics, or Architecture for only $399 USD More options available at PASSstuff. com

We are covering all bases to ensure our community can continue reaching new and exciting heights. Plans are underway for the in-person event you all know and love along with a new venture, a new opportunity: a PASS Summit 2020 Virtual Event. Find out more at PASS. org/summit

Thank you to our Event Sponsors

Thank you to our Global Sponsors

Session Evaluations https: //www. surveymonkey. com/r/H 87 C 3 Q 9

Agenda SQL Experiences Landscape + Updates on 3 SQL Tools

SQL Server Experiences Graphical Interfaces SSMS / Azure Data Studio SSDT VSCode Azure Portal Notebooks CLI and Scripting Drivers and Libraries SQL Server Engine Markdown Powershell SQL Python Bash azcli Mssqlctl Sqlpackage Mssql-cli Mssql-conf Powershell BCP, SQLCmd, Etc SMO Dac. FX Drivers (JDBC, OLEDB, Py. ODBC, Tedious/Node. js, Go) T-SQL DDL Trace Flags Startup Parameters

Let’s talk about these~ Graphical Interfaces SSMS / Azure Data Studio SSDT VSCode Azure Portal Notebooks CLI and Scripting Drivers and Libraries SQL Server Engine Markdown Powershell SQL Python Bash azcli Mssqlctl Sqlpackage Mssql-cli Mssql-conf Powershell BCP, SQLCmd, Etc SMO Dac. FX Drivers (JDBC, OLEDB, Py. ODBC, Tedious/Node. js, Go) T-SQL DDL Trace Flags Startup Parameters

but first Remember SQLSat. Sydney 2019 Keynote with Rolf Tesmer? Here’s a quick reminder… with IDE ; )

SSMS updates Latest version 18. 5 (Apr 7, 2020) Better integration with Azure Data Studio: • Generate script to Notebook • New Query & Notebook in Azure Data Studio Vulnerability Assessment, Data Classification. . and more … https: //docs. microsoft. com/sql/ssms/release-notes-ssms

Azure Data Studio Gloria DB Admin Anna Data Analyst Chen Data Scientist Emerging Not j ust f or Az Michael Database Developer Open-source, cross platform, modern IDE for SQL • • • Support SQL Server, Azure SQL * & Postgre. SQL for Windows, Mac. OS, Linux UI look & feel update Notebook experience – SQL, Troubleshooting / Incident response, Data Analysis, Kusto connection Extensions: machine learning, vendor extensions, Admin Pack, and more Easy deployment of SQL on container, BDC and more Visualization – Sand. Dance https: //docs. microsoft. com/sql/azure-data-studio/release-notes-azure-data-studio ure

I need to know which product has the fastest turnaround. . Let me query that! Here you go… Oh. . I need the product category. . Sure. . Here you go again… Thanks! This is for the last quarter, right? Do you mean sold products? --- Prepared by Cookie Monster -- 2020. 03. 01 -- Question from Marketing about how much we sell and what's the shorter manufacturing time. -SELECT TOP 10 * FROM Production. Product ORDER BY Name ASC; List and withproduct fast manufacture days. -- Get Product list category with fast SELECT manufacture days as Product. Name USEp. Name Adventure. Works 2017; , p. Product. Number GO 1 , p. List. Price AS Price SELECT , c. Name p. Days. To. Manufacture AS Product. Category Production. Product , FROM p. Name as Product. Name p WHERE p. Days. To. Manufacture < 4 , p. Product. Number , GOp. List. Price AS Price 2 , p. Days. To. Manufacture FROM Production. Product p INNER JOIN Production. Product. Subcategory s ON s. Product. Subcategory. ID = p. Product. Subcategory. ID INNER JOIN Production. Product. Category c ON c. Product. Category. ID = s. Product. Category. ID WHERE p. Days. To. Manufacture < 4 GO

I need to know which product has the fastest turnaround. . Let me query that! Here you go… Oh. . I need the product category. . Sure. . Here you go again… Thanks! This is for the last quarter, right? Do you mean sold products? Here you go again… You are a Rockstar! Thanks. -- Get Product list and product category with fast manufacture days USE Adventure. Works 2017; GO SELECT c. Name AS Product. Category , p. Name as Product. Name , p. Product. Number 3 , p. List. Price AS Price , p. Days. To. Manufacture FROM Production. Product p INNER JOIN Production. Product. Subcategory s ON s. Product. Subcategory. ID = p. Product. Subcategory. ID INNER JOIN Production. Product. Category c ON c. Product. Category. ID = s. Product. Category. ID WHERE p. Days. To. Manufacture < 4 AND EXISTS (SELECT TOP 1 1 FROM Sales. Order. Detail sod INNER JOIN Sales. Order. Header soh ON soh. Sales. Order. ID = sod. Sales. Order. ID WHERE sod. Product. ID = p. Product. ID AND soh. Order. Date BETWEEN '20140101' AND '20140331') GO

My dirty little scripts in the closet ….

23 DAYS LATER …

You know that list that you sent me last time about that fast manufacturer… Can refresh it, please? PANIC What list? PANIC Oh. . That list! Yea yea… PANIC Here you go again… PANIC I want to compare what the result back then and what it is now; if we have had any changes… Was the logic the same as what you did last time? Hello? PANIC

What’s the problem?

Reproducibility Code Review Auditing results / analysis Context Executable Code Documentation Results Visualization Analysis + Interpretation Executable

Remember School Science Project? Source: https: //feelslikehomeblog. com/2017/07/the-science-of-slime-its-way-more-than-polymers/

Notebooks Like what you saw? Join Rob Sewell’s session at 4 pm AEST on Track 1 https: //github. com/SQLDBAWith. ABeard/Jupyter. Notebooks

mssql-cli Open source cross-platform tool Interactive command-line tool for querying SQL Server Available on Windows, mac. OS, Linux https: //github. com/dbcli/mssql-cli (an alternative to sqlcmd)

Give Feedback coz this is our JOURNEY together! SSMS / SSDT / Dac. FX and more: https: //feedback. azure. com/forums/908035 -sql-server Azure Data Studio: https: //github. com/microsoft/azuredatastu dio/issues

Read more~ State of the SQL Server Tools https: //cloudblogs. microsof t. com/sqlserver/2019/11/06 /state-of-the-sql-servertools/

Recap Data Landscape is expanding and evolving. 1 2 3 SSMS Azure Data Studio mssql-cli It’s not going away~ Simplifying data landscape for every users Productivity on low graphics

Thank you