30 November 2017


30 November 2017


Would you like to see Redgate tools inside SQL Operations Studio?

You may already have heard about Microsoft’s new DevOps platform for database development, SQL Operations Studio, or “SQL Ops Studio”. The preview version was announced at PASS Summit on 1 November, and Foundry, the R&D division of Redgate has been researching the feasibility, practicality and appeal of cross-platform data tools for a while.

You can play a big part in what happens next.

What is SQL Operations Studio?

SQL Operations Studio

Built on top of Visual Studio Code, SQL Ops Studio is a free lightweight tool for modern database development and operations that runs on Windows, macOS and Linux. It’s been designed for developers without a deep knowledge of database administration, so that they can manage databases and maintain them.

What’s different?

One of the most surprising revelations of Redgate’s 2017 State of Database DevOps Survey was that 75% of developers are responsible for developing both the application and the database. That’s why SQL Ops Studio has so much potential.

SQL Ops Studio has introduced itself with the look and interactive style of Visual Studio Code, and looks set to build on that by introducing some of the more familiar features for dealing with data. It’s relatively easy to get up and running, and will probably become the favored go-to tool for application developers.

What’s your opinion?

What do you think of SQL Ops Studio? Have you tried it? Are you or your organization already working across multiple platforms (Windows, macOS, Linux)?

Like every Foundry project, we rely on your expertise and experience to help us understand the potential and create a solution. We’d like to hear about your thoughts and plans.

We’ll always endeavor to compensate you for your time; be it with an Amazon Gift Card, paying particular attention to your requirements or even a free license of the software that’s developed as a result, so please sign up to participate in our cross-platform data tools research project.

Share this post.

Share on FacebookShare on Google+Share on LinkedInTweet about this on Twitter

Related posts

Also in Blog

Thinking about microservices? You need DevOps first

With the rise of new virtualization technologies using containers, people are starting to think more and more about using microservices in their organizations. They’ve been getting a lot of attentio...

Also in Software development

Are your automated tests slowing you down?

Slow, unreliable tests prevent teams doing great work, and make continuous delivery impossible.

This was true for our SQL Source Control team when I started working with them. From pushing a commit t...

Also about Foundry

How might classification and better documentation improve data safety?

In this post, we imagine how auto-classification of data can be used to build better documentation that helps you trust that your organization can use data without posing a risk or compromising regu...

  • Will Spurgeon

    Yep, definitely would love to see SQL Prompt formatting options for OpsStudio, as I’m guessing it will eventually be the defacto tool for most SQL developers.

  • Paulo Correia

    I think, it’s a must

  • Denis Voituron

    Yes… it’s will be great 🙂
    SSMS is not really for developers, but OpsStudio is created for us… So, to use the best SQL extension in this tool will be very interesting.

  • Matthew Clark

    I believe SQL Prompt would need to be a plugin too for Ops Studio. Im looking into SQL Prompt for 20-40 devs but think need to wait to see what happes on Ops Studio as that seems like should be a move for us as well for better productivity.

  • Aymel Sanchez

    Yes, for sure. A must!