Azure Data Studio - Object Explorer In this video Erin shares new functionality within Object Explorer for Azure Data Studio and talks about the benefit of trying out the Insider build. Azure Data Studio is an Open-Source project available at github.com/microsoft/azuredatastudio.
Download Insider build: github.com/microsoft/azuredatastudio#tr…
Azure Data Studio is a cross-platform database tool designed for data professionals. It can be used on Windows, macOS, and Linux, supporting both on-premises and cloud data platforms. Key features include:
SQL Code Editor with IntelliSense: This feature offers a modern, keyboard-focused SQL coding experience that improves daily tasks with features like multiple tab windows, a rich SQL editor, IntelliSense, keyword completion, and code navigation. It also supports source control integration with Git.
Smart SQL Code Snippets: These are pre-written SQL scripts that generate proper SQL syntax for a variety of tasks, such as creating databases, tables, views, and other database objects, and updating existing database objects. Azure Data Studio also supports custom SQL code snippets.
Customizable Server and Database Dashboards: Users can create rich, customizable dashboards to monitor and troubleshoot performance bottlenecks in their databases.
Connection Management (Server Groups): Server groups organize connection information for the servers and databases you work with.
Integrated Terminal: This feature allows users to use their favorite command-line tools (such as Bash, PowerShell, sqlcmd, bcp, and ssh) directly within the Azure Data Studio user interface.
Extensibility and Extension Authoring: Azure Data Studio's functionality can be extended through extensibility points for data management activities and support for extension authoring.
Azure Data Studio is ideal for users who primarily edit or execute queries, need quick visualization of result sets, execute most administrative tasks via an integrated terminal, have minimal need for wizard experiences, do not need deep administrative or platform-related configuration, and need to run on macOS or Linux.
SQL Server Management Studio (SSMS), on the other hand, is more suited for complex administrative or platform configuration, security management, performance tuning, use of database diagrams and table designers, access to Registered Servers, and use of live query stats or client statistics.
The source code for Azure Data Studio and its data providers is available on GitHub under a source code EULA that grants rights to modify and use the software, but not to redistribute it or host it in a cloud service.