DZone
Thanks for visiting DZone today,
Edit Profile
  • Manage Email Subscriptions
  • How to Post to DZone
  • Article Submission Guidelines
Sign Out View Profile
  • Post an Article
  • Manage My Drafts
Over 2 million developers have joined DZone.
Log In / Join
Refcards Trend Reports Events Over 2 million developers have joined DZone. Join Today! Thanks for visiting DZone today,
Edit Profile Manage Email Subscriptions Moderation Admin Console How to Post to DZone Article Submission Guidelines
View Profile
Sign Out
Refcards
Trend Reports
Events
Zones
Culture and Methodologies Agile Career Development Methodologies Team Management
Data Engineering AI/ML Big Data Data Databases IoT
Software Design and Architecture Cloud Architecture Containers Integration Microservices Performance Security
Coding Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks
Culture and Methodologies
Agile Career Development Methodologies Team Management
Data Engineering
AI/ML Big Data Data Databases IoT
Software Design and Architecture
Cloud Architecture Containers Integration Microservices Performance Security
Coding
Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance
Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks
What's in store for DevOps in 2023? Hear from the experts in our "DZone 2023 Preview: DevOps Edition" on Fri, Jan 27!
Save your seat
  1. DZone
  2. Software Design and Architecture
  3. Cloud Architecture
  4. Introducing Azure Data Studio

Introducing Azure Data Studio

Let's take a look at an introduction to Azure Data Studio as well as explore the SQL Server connections that it has.

Grant Fritchey user avatar by
Grant Fritchey
·
Oct. 11, 18 · Tutorial
Like (3)
Save
Tweet
Share
8.36K Views

Join the DZone community and get the full member experience.

Join For Free

If you're watching Microsoft Ignite or tracking the information coming out of it on social media, then you know that Azure SQL Studio has been changed to Azure Data Studio. I've got an early release on some of the bits. Let's explore what's going on.

Azure Data Studio

The core concept here is to have a development tool that gives you a common framework for working with data, not just SQL data, but CosmosDB and others. Further, a tool that you can run where you work. Do you have a Mac? Cool. Use Azure Data Studio. Running Linux? Cool. Use Azure Data Studio. Still on Windows with me? We also get Azure Data Studio.

The first thing I'm excited about is the load time. It's fast. Really fast. Out of the box, it has SQL Server connections, and you can see the opening screen here:

After connecting, I've got a whole new set of exploration mechanisms:

Immediately, I'm excited. Why? Backup info is front and center. I get that this is meant as a development platform, but how wonderful that they're letting us know the current status on backups, even in a development tool. You see that on the right. On the left, they have some tasks set up. Across the top is info about the server you're connected to. In the middle are the databases. Double-clicking a database shows the objects in the database, in that same kind of listing. There's no hierarchy of objects, so tables, views, etc., are just mixed together. You can search for an object quickly.

Also, you can customize these charts, adding your own, putting in monitoring and whatnot. It's handy.

I also opened up the query window, after all, this is about development. It is not your grandpappies query editor. This thing is pretty slick. There are all sorts of functionality above and beyond what is offered in SSMS. This is a development tool.

As such, source control is built in as a fundamental part of the tool. I haven't hooked that up just yet, but I'll write another post once I've got it done.

There's More!

There are also all kinds of plug-ins already available. This is but a subset:

I'd like to point out two that I think are really interesting. First, Redgate SQL Search. That's right, we're already available in Azure Data Studio. The second one I want to point out is right at the bottom, SQL Server Profiler.

Now don't get excited. Especially, don't get excited if you're a huge Profiler fan. However, please do get excited if you're on Team Extended Events. While this may say Profiler, it's just a front-end for Extended Events. Here's a screenshot:

It does resemble Profiler, but don't worry. I'm very impressed — and quite happy — that this functionality is coming with the tool right out of the gate. If the sacrifice we have to make is calling Extended Events, Profiler, so be it.

Conclusion

There is so much more to Azure Data Studio that I could be showing you. However, I just wanted to give you an immediate taste. If you're a data developer in the Azure stack, and not just on SQL Server, you really need to get a hold of Azure Data Studio and start to work it into what you do. You're going to be pleased.

Just don't look at the execution plans yet.

Data (computing) azure

Published at DZone with permission of Grant Fritchey, DZone MVB. See the original article here.

Opinions expressed by DZone contributors are their own.

Popular on DZone

  • Microservices Discovery With Eureka
  • What Is a Kubernetes CI/CD Pipeline?
  • Bye Bye, Regular Dev [Comic]
  • Better Performance and Security by Monitoring Logs, Metrics, and More

Comments

Partner Resources

X

ABOUT US

  • About DZone
  • Send feedback
  • Careers
  • Sitemap

ADVERTISE

  • Advertise with DZone

CONTRIBUTE ON DZONE

  • Article Submission Guidelines
  • Become a Contributor
  • Visit the Writers' Zone

LEGAL

  • Terms of Service
  • Privacy Policy

CONTACT US

  • 600 Park Offices Drive
  • Suite 300
  • Durham, NC 27709
  • support@dzone.com
  • +1 (919) 678-0300

Let's be friends: