It’s built on an extensible microservices architecture and includes the SQL tools service built on. SQL Operations Studio has been forked from Visual Studio Code with the objective to make it highly extensible. They will now be able to use a free database development and operations tool from Microsoft that runs natively on their OS of choice. Many users who use or plan to deploy SQL Server 2017, which became generally available in September 2017, also use Macs as their clients. SQL Operations Studio comes at an opportune time for users who use clients running macOS or Linux. They also have the ability to create rich customizable dashboards to monitor and quickly detect performance bottlenecks in your SQL databases on-premises or in Azure. Database developers can increase their productivity with smart T-SQL code snippets and rich graphical experiences to create new databases and database objects (such as tables, views, stored procedures, users, logins, roles, etc.) or to update existing database objects. They can easily generate and execute CREATE and INSERT scripts for SQL database objects to create copies of their database for development or testing purposes. Bash, PowerShell, sqlcmd, bcp and ssh) in the integrated terminal window right within the SQL Operations Studio user interface. Users can leverage their favorite command line tools (e.g. Microsoft SQL Operations Studio takes a prescriptive approach to performing routine tasks, allowing users to get tasks done fast while continuing to learn on the job. These individuals often do not have time to learn the intricacies of their database environment, making hard to perform even the most routine tasks. It’s easy to connect to Microsoft SQL Server with SQL Operations Studio and perform routine database operations-overall lowering the learning curve for non-professional database administrators who have responsibility for maintaining their organization’s SQL-based data assets.Īs more organizations adopt DevOps for application lifecycle management, developers and other non-professional database administrators find themselves taking responsibility for developing and operating databases. SQL Operations Studio is a free, light-weight tool for modern database development and operations for SQL Server on Windows, Linux and Docker, Azure SQL Database and Azure SQL Data Warehouse on Windows, Mac or Linux machines.ĭownload SQL Operations Studio to get started.
We are excited to announce that SQL Operations Studio is now available in preview. For the most up to date information please visit our monthly Azure Data Studio blog post and download and install the latest release here.
UPDATE: SQL Operations Studio is now GA and renamed to Azure Data Studio.
0 kommentar(er)
