Code Mahek
  • Blog
  • About
  • Contact
  • Random Clicks
  • Resume
  • Ava Chat Bot

Fragrance
​of Programming

Microsoft Sql Operations Studio

11/10/2017

Comments

 
Recently during the keynote at PASS summit 2017, Microsoft SQL Operations Studio announced as a tool of cross platform compatibility (Windows / Linux / Mac) capable of operating MS RDBMS including SQL Server. 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
In the blog post, Microsoft SQL Operations Studio (MSOS from here on, for brevity) was described as a cross-platform, lightweight tool for modern database development and operations. Along with SQL Server, it will be used to work with other Microsoft data offerings like Azure SQL Database and Azure SQL Data Warehouse.

​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.
​Jason posted a slide on twitter in which he shows the capabilities of SQL Operation 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
Like VS Code and other editors, MSOS will provide easy access to code snippets (in the T-SQL language, in this case) and dashboards to monitor performance in the cloud or on the Azure cloud.
As for more of that VS Code goodness, Microsoft said "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."
This tool seems to be an open source tool published in the GitHub repository. Like the Visual Studio Code, it seems that it seems possible to use it displaying the integrated terminal, and seems to be able to execute the query while executing the OS command.
Picture
Source: Microsoft
Comments
comments powered by Disqus

    RSS Feed

    Categories

    All
    Azure
    C#
    Cloud
    CodeProject
    CSharp
    DotNet Core
    Jetbrains
    .NET
    Rider
    Source Generators
    SQL
    Tech News
    Ubuntu
    Visual Studio 2015
    Visual Studio 2019
    Windows
    Windows 10

    Archives

    May 2020
    February 2019
    January 2019
    December 2018
    May 2018
    December 2017
    November 2017
    October 2017
    September 2017
    July 2017
    May 2017
    April 2017
    May 2015
    April 2015
    March 2015

    View my profile on LinkedIn

Location

Contact Us

    Subscribe Today!

Submit
  • Blog
  • About
  • Contact
  • Random Clicks
  • Resume
  • Ava Chat Bot