![]() ![]() In addition to viewing that information, users can back up and restore databases, edit the data in database tables and perform other management tasks from inside the dashboards.Ī server groups function enables users to organize the servers and databases they work with into different groups to help streamline management processes, with color coding to distinguish between the groups. The tool includes separate server and database dashboards, which can be configured with insight widgets to provide at-a-glance views of performance levels, system usage and other metrics. Users of Azure Data Studio can create customizable dashboards to monitor and troubleshoot performance bottlenecks and other issues in databases and at the server level. Both Azure SQL Database and Azure SQL Data Warehouse are also supported, and as of November 2018 the tool included preview support for Azure SQL Database Managed Instance, a version of the cloud database system that's almost functionally equivalent to SQL Server. Users can drill down into the underlying data and initiate management actions based on what they find.Īzure Data Studio supports SQL Server from the 2014 release to the SQL Server 2019 preview that Microsoft also made available in September 2018. An insight widget uses JSON code to automatically generate a chart or graph that displays information about an individual database or a SQL Server system, depending on the T-SQL query. A screenshot of Azure Data Studio's user interface, with the management dashboard for a SQL Server system displayed.Īnother key feature in Azure Data Studio is the ability to create insight widgets that visualize the results of T-SQL queries to make it easier for DBAs and other users to see what's happening in their databases. Users can also create custom code snippets for actions that aren't covered by the built-in ones. The code snippets are templates that generate the T-SQL syntax needed to perform different administrative actions, from updating existing database objects to creating new databases, tables and views. In the T-SQL editor, users can save the results of database queries as text, JSON or Excel files in addition to query development, the editor supports the creation of stored procedures, scripts and other database objects.Īzure Data Studio also provides a set of T-SQL code snippets that can be used to streamline the process of writing T-SQL statements. The tool includes built-in features like multi-tab windows, a T-SQL editor, smart code navigation and integration with the Git open source version control system for tracking source code. An integrated terminal window enables users to execute database management commands with Bash, PowerShell, sqlcmd and other command-line tools from within Azure Data Studio's UI. ![]() Features of Azure Data StudioĪzure Data Studio uses Microsoft's Visual Studio Code source code editor as its foundation the management tool was forked from Visual Studio Code, and as in the latter technology, the open source Electron framework serves as a cross-platform application building block. The company has issued new releases with added features on a monthly basis since launching the SQL Operations Studio preview, a practice it plans to continue with the GA version. It first became available as a public-preview technology in November 2017 and remained in preview mode until September 2018, when Microsoft made the product generally available and changed its name to Azure Data Studio. As a result, Azure Data Studio is aimed not only at database administrators, but also at software developers and other non-DBAs who manage databases as part of their jobs.Īlso referred to as SQL Ops Studio in its original incarnation, the tool offers a consistent user experience across Windows, Linux and macOS clients. The lightweight software is designed to make routine database development, querying and administration work easier than it is with Microsoft's more-functional SQL Server Management Studio ( SSMS) software. Azure Data Studio is a free Microsoft desktop tool, initially called SQL Operations Studio, that can be used to manage SQL Server databases and cloud-based Azure SQL Database and Azure SQL Data Warehouse systems. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |