Webinar review of: Intro to Azure Data Studio and the Plan Explorer Extension by Kevin Kline and Warwick Rudd on 8/28/2019
Kevin Kline is a Principal Program Manager at SentryOne. Warwick Rudd is a Principal Consultant at SQL Master Consulting.
Here’s a partial list of the webinar contents that were discussed and demoed by Rudd and Kline.
Azure Data Studio (ADS) History
- SQL Operations Studio was the original and released 11/2017. It was quickly replaced by Azure Data Studio on 9/2018
When Sql Server Management Studio (SSMS) is better to use.
- Security and User Management
- Performance Tuning
- Query Store
- Live Query Stats
- Data Tuning Advisor
- Importing / Exporting
- DACPACs
- Managing High Availability
- Disaster Recovery tasks
- Availability Groups
- Database Mirroring
- Log Shipping
- Replication
When Azure Data Studio (ADS) is better to use.
- Need to quickly chart or visualize result sets
- Performing DBA tasks via scripts
- SQL Server 2019 features only in ADS
- Big Data Clusters
- Notebooks
- Polybase
Demos, lots of great demos by Rudd.
- Dashboards
- Custom Insights for Dashboards
- T-SQL Snippets
- Code Definitions
- Query Executions and result outputs
- Source Control
- Extensions
- Allows total customization of ADS
- Tons of administration and other extensions
- i.e. SQL Server Agent, SQL Server profiler, powershell, schema compare
- SQL Notebooks – Able to build your own toolkit inside cells. Code and data can be shared.
- SentryOne Plan Explorer – Query plan tool on steriods
Resources
- Tons of urls listed in the slides
A critical takeaway is that Azure Data Studio is constantly being updated by Microsoft. The 10+ product releases since 9/2018 prove it. By the time you read this, it will probably be updated again! Azure Data Studio is a tool that DBAs need to master and keep in their SQL Server toolbox. Right?
I give the webinar ‘Intro to Azure Data Studio and the Plan Explorer Extension’ by Kevin Kline and Warwick Rudd a thumbs up.
Ad
Whizlabs – 165 Practice Questions for Microsoft Azure Exam AZ 400 | Buy Now
Edureka – DevOps Training by Edureka Gain expertise in various Devops processes and tools like Puppet, Jenkins, Nagios, GIT for automating multiple steps in SDLC, Ansible, SaltStack, Chef. Know More!
Whizlabs – Practice Tests for Exam AZ-400: Microsoft Azure DevOps Solutions
Whizlabs – Online Training for Agile Certified Practitioner (PMI ACP)® Certification Exam | Enroll Now
Edureka – Data Science Training by Edureka Drive Business Insights from Massive Data Sets Utilizing the Power of R Programming, Hadoop, and Machine Learning.
Ed2Go –Intermediate SQL – By the end of this course, you’ll be able to use a wide range of advanced SQL techniques with confidence.
Advertisement
Amazon Prime Visa - Get a Amazon Gift Card instantly upon approval of Amazon Prime Visa
Chase Checking - Open your Chase checking account and get a bonus!
Chase Freedom Flex - Earn unlimited cash back with the Chase Freedom Flex credit card.
Chase Freedom Unlimited - Earn cash back with the Chase Freedom Unlimited credit card.
Chase Saphire - Open your Chase Saphire Preferred or Reserve and get bonus points and more!
Discover - Get a bonus when you open an eligible Discover account.
Marriott Bonvoy Credit card - Open your Marriott Bonvoy Credit card and get a new Cardmember bonus!
Rakuten - Sign up for Rakuten and earn cash back on your purchases at 3500+ stores. 20M+ members in the U.S. have earned over $3.2B in Cash Back at their favorite stores.
Schwab - Open a Schwab account and get up to $1,000 depending on your net deposit.
Xfinity - Open an Xfnity mobile or internet account and get a bonus