Microsoft SQL Operations Studio

By Samir Behara on November 9, 2017 • ( 5 )

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 –

The first demo of Microsoft SQL Operations Studio is starting @ 12pm. Come to the Microsoft booth to see our new tool! #PASSsummit pic.twitter.com/uNchRr4WNK

— SQL Ops Studio (@sqlopsstudio) November 1, 2017

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?

Rohan just announced Microsoft SQL Operations Studio @pass coming soon for SQL Server developers and admins on Windows, Linux and macOS pic.twitter.com/5ITfz33tM4

— SQLServer Data Tools (@sqldatatools) November 1, 2017

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.

SQL 2017

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 —

My one photo of a slide I took, in case the slide deck is not available, from the DevOps with SQL Server 2017! Many thanks @sqldatatools! pic.twitter.com/UwDDxtukYm

— Jason E Bacani (@JEBacaniSQLDude) November 2, 2017

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!