Wednesday, September 26, 2018

Azure Data Studio

Microsoft Development team is going to be introduced Azure Data Studio in SQL Server 2019 which was released under the preview name SQL Operations Studio in previous version. Azure Data Studio is a lightweight, modern, open source, cross-platform database tool for data professionals using the Microsoft family of on-premises and cloud data platforms on Windows, MacOS, and Linux.
Azure Data Studio offers a modern editor experience with Intellisense, code snippets, source control integration, and an integrated terminal. It is engineered with the data platform user in mind, with built in charting of query result sets and customizable dashboards.
With the help of this tool, now that SQL Server can run on all the major platforms, the Mac and Linux users were having to use third party tools to manage SQL server. Currently you can edit whole table, but not limited data that you need to run query, and edit only the results of that query. 
  1. Edit and run queries in a modern development environment with lightning fast Intellisense, code snippets, and source control integration.
  2. Quickly visualize data with built-in charting of your result sets.
  3. Create custom dashboards for your servers and databases using customizable widgets.
  4. Easily manage your broader environment with the built-in terminal.
  5. Analyze data in an integrated notebook experience built on Jupyter.
  6. Enhance your experience with custom theming and extensions.
  7. And explore your Azure resources with a built-in subscription and resource browser.
  8. Supports scenarios using SQL Server Big Data Cluster.
Those of us who don't want to run Microsoft's OS in a VM are really appreciative of the efforts they're making with things like this and VS code in making them cross-platform. Keep in mind, this is in preview, and provides an open source extension platform, so if you want that functionality, you can likely build it if it ends up lacking that in the final release.
Reference:https://docs.microsoft.com

No comments:

Post a Comment