Azure SQL Data Warehouse: Support for SQL Operations Studio
Azure SQL Data Warehouse supports the latest preview release of SQL Operations Studio. SQL Operations Studio is a free, lightweight tool for modern database development and operations. It provides:
- A Transact-SQL (T-SQL) code editor with IntelliSense, so you can run on-demand T-SQL queries and view and save results as text, JSON, or Excel.
- Customizable server and database dashboards to monitor and quickly troubleshoot performance bottlenecks with SQL Data Warehouse.
- Connection management with server groups to organize connection information for the servers and databases.
- An integrated terminal for you to use your favorite command-line tools, such as Bash, PowerShell, sqlcmd, bcp, and ssh.
To begin, you can download the tool and follow the Azure SQL Data Warehouse tutorial. SQL Operations Studio is open-source, so join us to improve the experience by contributing directly at the GitHub repo. You can also contribute to the SQL Data Warehouse SQL Ops Extension by adding scripts to create insight widgets in the GitHub repo.