Redgate Launches Extension for SQL Operations Studio
May 14, 2018

The latest Public Preview release of SQL Operations Studio, a cross-platform database development tool from Microsoft, has been enhanced with an extension from Redgate Software.

Redgate has further developed its free SQL Search tool to integrate with and plug into SQL Operations Studio.

Built on top of Visual Studio Code, SQL Operations 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.

SQL Search is the most popular tool Redgate has ever developed and the version for SQL Server Management Studio and Visual Studio 2017 has been downloaded more than half a million times. It saves developers time and removes frustration by finding fragments of SQL in tables, views, stored procedures, functions, and jobs. Importantly, it also searches across multiple object types and databases, and allows users to quickly navigate to wherever the fragments happen to be on a server.

The new extension for SQL Operations Studio gives developers who prefer this cross-platform tool the same functionality on the Windows, macOS or Linux platform. It was developed by Foundry, the Research & Development division of Redgate, to discover the appeal of Redgate extensions for cross-platform use, and explore the challenges of creating tools in the space.

The launch is an important one because, as Redgate’s 2018 State of Database DevOps Survey shows, 76% of organizations have developers in their team who work across both applications and databases. Their greatest challenge is synchronizing the application and database changes, and overcoming different approaches to development within multi-function teams.

SQL Operations Studio addresses part of the challenge by allowing developers to stay with their favored platform as they move between application and database development. Microsoft also, however, wants to build what it calls a rich tools eco-system for SQL Operations Studio, and its fourth major update in March included an Extension Manager to make it simple to discover and acquire additional functionality.

The Preview release of the SQL Search extension for SQL Operations Studio is now available and is the first step on Redgate’s cross-platform journey. As Jonathan Roberts, the Foundry Team Lead explains: “Redgate has a complete portfolio of database development tools which plug into SQL Server Management Studio and Visual Studio 2017 and bring DevOps to databases. We want to find out what added functionality users of SQL Operations Studio want, and how we can help deliver it to them. SQL Search is a natural extension to begin with because it’s a relatively small tool and the task of adapting it for macOS and Linux gave us some valuable insights.”

SQL Search is a recommended extension for SQL Operations Studio and can be downloaded through its Extension Manager Marketplace. Once installed, it can be used from within SQL Operations Studio in, literally, a couple of clicks and becomes part of the natural workflow.

The Foundry team is now actively seeking feedback from users to determine the next step on the cross-platform journey.

The Latest

September 20, 2018

The latest Accelerate State of DevOps Report from DORA focuses on the importance of the database and shows that integrating it into DevOps avoids time-consuming, unprofitable delays that can derail the benefits DevOps otherwise brings. It highlights four key practices that are essential to successful database DevOps ...

September 18, 2018

To celebrate IT Professionals Day 2018 (this year on September 18), the SolarWinds IT Pro Day 2018: A World Powered by Tech Pros survey explores a "Tech PROactive" world where technology professionals have the time, resources, and ability to use their technology prowess to do absolutely anything ...

September 17, 2018

The role of DevOps in capitalizing on the benefits of hybrid cloud has become increasingly important, with developers and IT operations now working together closer than ever to continuously plan, develop, deliver, integrate, test, and deploy new applications and services in the hybrid cloud ...

September 13, 2018

"Our research provides compelling evidence that smart investments in technology, process, and culture drive profit, quality, and customer outcomes that are important for organizations to stay competitive and relevant -- both today and as we look to the future," said Dr. Nicole Forsgren, co-founder and CEO of DevOps Research and Assessment (DORA), referring to the organization's latest report Accelerate: State of DevOps 2018: Strategies for a New Economy ...

September 12, 2018

This next blog examines the security component of step four of the Twelve-Factor methodology — backing services. Here follows some actionable advice from the WhiteHat Security Addendum Checklist, which developers and ops engineers can follow during the SaaS build and operations stages ...

September 10, 2018

When thinking about security automation, a common concern from security teams is that they don't have the coding capabilities needed to create, implement, and maintain it. So, what are teams to do when internal resources are tight and there isn't budget to hire an outside consultant or "unicorn?" ...

September 06, 2018

In evaluating 316 million incidents, it is clear that attacks against the application are growing in volume and sophistication, and as such, continue to be a major threat to business, according to Security Report for Web Applications (Q2 2018) from tCell ...

September 04, 2018

There's a welcome insight in the 2018 Accelerate State of DevOps Report from DORA, because for the first time it calls out database development as a key technical practice which can drive high performance in DevOps ...

August 29, 2018

While everyone is convinced about the benefits of containers, to really know if you're making progress, you need to measure container performance using KPIs.These KPIs should shed light on how a DevOps team is faring in terms of important parameters like speed, quality, availability, and efficiency. Let's look at the specific KPIs to track for each of these broad categories ...

August 27, 2018

Protego Labs recently discovered that 98 percent of functions in serverless applications are at risk, with 16 percent considered "serious" ...

Share this