Last week during the Day 1 Keynote at PASS Summit, Rohan Kumar – General Manager of Database Systems, Microsoft – announced about a new lightweight cross platform tool for SQL Developers and DBAs called as ‘Microsoft SQL Operations Studio‘. A sneak peak of the tool was also provided during a demo at the Microsoft booth in the Exhibit Hall –
There was quite a buzz about this new shiny tool in the social media and rightly so. The primary IDE which developers and DBAs use to connect to their database instance – SQL Server Management Studio(SSMS) works with Windows only, but you will be able to run Microsoft SQL Operations Studio on either Mac, Linux or Windows. Isn’t it awesome?
One of the biggest highlights of SQL Server 2017 is its cross platform support – you can run your workloads on not only Windows, but also Linux and Docker containers. This enhances the need of a cross platform tool which can ideally replace SSMS in near future, if not at least assist Developers/DBAs who would require to work on multiple platforms and provide more in-built capabilities.
Reading through Microsoft documentation in the link here —
In a few weeks, users will be able to download and evaluate this free, light-weight tool for modern database development and operations on Windows, Mac or Linux machines for SQL Server, Azure SQL Database, and Azure SQL Data Warehouse. Increase your productivity with smart T-SQL code snippets and customizable dashboards to monitor and quickly detect performance bottlenecks in your SQL databases on-premises or in Azure. You’ll be able to leverage your favorite command line tools like Bash, PowerShell, sqlcmd, bcp and ssh in the Integrated Terminal window. Users can contribute directly to SQL Operations Studio via pull requests from the GitHub repository.
I liked the slide posted by Jason in Twitter which shows the capabilities of SQL Ops Studio vs SSMS vs SSDT —
Exciting times ahead and I look forward to the public preview of this tool. Hopefully it will be more faster, lightweight and powerful than the current SSMS IDE!
Read my latest post on SQL Operations Studio for more details —