Azure Data Studio ❤ SQL People

Target Audience:

SSMS Users


Azure Data Studio is not replacing SSMS, but it is accelerating the speed of development, by adding feature that would take years to add to SSMS. These tools work together, hand-in-hand in some places. How so? Well, in SSMS 18+ you can right-click in many places and launch ADS with your current connection context. ADS fills in the gaps in SSMS, and opens new opportunities.
One of the biggest features available in ADS but not SSMS are SQL Notebooks. Everyone should be using notebooks, even if just to show new employees how to connect to the environment. ADS also has the ability to install extensions so that you can work / edit in other languages, like PowerShell, Python, or even Docker containers. If you work with Postgres & SQL Server, ADS has been a no-brainer to use since earlier this year.
With the June release, ADS on Windows gained the ability to launch some of the SSMS wizards (like scripting out a database), without even having to open SSMS. With so many connections between SSMS and ADS, you should go ahead and start using ADS as your “daily-driver” as much as you can. There’s so much more out there to be done in the data world, and ADS helps you break down those barriers and enhance your value to your employer, pretty much instantly.
Find something in ADS you don’t like? ADS is open-source so you can either fix it yourself and do a PR. Or you can log an issue on GitHub and converse directly with the Engineers building next month’s version of ADS.

Why I Want to Present This Session:

SQL Notebooks is going to change the workflow of every data professional on the planet

Additional Resources:

The following two tabs change content below.
Aaron Nelson is a Consultant with SolidQ with over 15 years of experience in Architecture, Business Intelligence, Development, and Performance Tuning of SQL Server. He was recently awarded a 6th Microsoft MVP for SQL Server (Data Platform). Aaron holds certifications for MCITP: Business Intelligence Developer, Database Administrator, & Database Developer. Aaron leads the PowerShell Virtual Chapters of PASS, and volunteers for the local PASS Chapter AtlantaMDF, and helps organize SQL Saturday events in Atlanta.
Previous Post
Power BI for the Data Systems Administrator
Next Post
PowerShell for Power BI (and some ETL)

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.