Today at PASS Summit Microsoft announced a new SQL “Tool” for running queries against SQL Server, called the Microsoft SQL Operations Studio.
So what is the Microsoft SQL Operations Studio
This appears to be a new cross platform (Mac, Linux, and Windows) for running queries against SQL Server.
Perhaps this is a replacement for SQL Server Management Studio, or may just a subset of what SSMS does today, however it works cross platform, unlike SSMS.
This is the “free modern data operations tool for SQL everywhere”
Doing a quick search I wasn’t able to find any reference to this yet, so this is brand new and not even released yet.
More from Stedman Solutions:
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!
I Googled “Microsoft SQL Operations Studio” to check into it since I heard about it at the PASS Summit, and the first link returned was to . . . here.
The second link, however, also posted 1 November, was to https://blogs.technet.microsoft.com/dataplatforminsider/2017/11/01/sql-server-2017-and-azure-data-services-the-ultimate-hybrid-data-platform/
The mention of MSOS in that post is maybe a third of the way down the page, when they say:
These new cross-platform capabilities have made SQL Server accessible to users of Windows, Linux and Mac. At PASS Summit, we are excited to provide a sneak peek at Microsoft SQL Operations Studio. 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.
Looks like it is still in its infancy, but it could be a product to watch.