Just don't look at the execution plans yet. 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. However, I just wanted to give you an immediate taste. There is so much more to Azure Data Studio that I could be showing you. If the sacrifice we have to make is calling Extended Events, Profiler, so be it. I'm very impressed - and quite happy - that this functionality is coming with the tool right out of the gate. It does resemble Profiler, but don't worry. While this may say Profiler, it's just a front-end for Extended Events. However, please do get excited if you're on Team Extended Events. Especially, don't get excited if you're a huge Profiler fan. The second one I want to point out is right at the bottom, SQL Server Profiler. That's right, we're already available in Azure Data Studio. I'd like to point out two that I think are really interesting. There are also all kinds of plug-ins already available. I haven't hooked that up just yet, but I'll write another post once I've got it done. This is a development tool.Īs such, source control is built in as a fundamental part of the tool. There are all sorts of functionality above and beyond what is offered in SSMS. It is not your grandpappies query editor. I also opened up the query window, after all, this is about development. You can search for an object quickly.Īlso, you can customize these charts, adding your own, putting in monitoring and whatnot. There's no hierarchy of objects, so tables, views, etc., are just mixed together. Double-clicking a database shows the objects in the database, in that same kind of listing. Across the top is info about the server you're connected to.
On the left, they have some tasks set up. 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. Out of the box, it has SQL Server connections, and you can see the opening screen here:Īfter connecting, I've got a whole new set of exploration mechanisms: The first thing I'm excited about is the load time. Note: After downloading Azure Data Studio, say Yes to enabling preview features so that you can use extensions.
#AZURE DATA STUDIO LOGO DOWNLOAD#
Download Azure Data Studio and review the release notes to get started.
#AZURE DATA STUDIO LOGO WINDOWS#
Still on Windows with me? We also get Azure Data Studio. The June release of Azure Data Studio is now available. Further, a tool that you can run where you work.
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. I've got an early release on some of the bits. 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.
0 kommentar(er)
