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

July 16, 2018

The key to mainframe DevOps success is in quickly identifying and removing major bottlenecks in the application delivery lifecycle. Major challenges include collaboration between mainframe and distributed teams, lack of visibility into the impact of software changes, and limited resource flexibility with scaling out necessary testing initiatives. Now let's take a closer look at some of these key challenges and how IT departments can address them ...

July 11, 2018

How much are organizations investing in the shift to cloud native, how much is it getting them? ...

July 10, 2018

In the shift to cloud native, many organizations have adopted a configuration-as-code approach. This helps drive up application deployment velocity by letting developers and DevOps teams reconfigure their deployments as their needs arise. Other organizations, particularly the more regulated ones, still have security people owning these tools, but that creates increased pressure on the security organization to keep up. How much are organizations investing in this process, and how much is it getting them? ...

June 28, 2018

More than a third of companies that use serverless functions are not employing any application security best practices and are not using any tools or standard security methodologies to secure them, according to the State of Serverless Security survey, conducted by PureSec ...

June 27, 2018

The popularity of social media platforms and applications is spurring enterprises to adopt "social business" models to better engage with employees and customers and improve collaboration, according to a new study published by ISG ...

June 25, 2018

The previous chapter in this WhiteHat Security series discussed Codebase as the first step of the Twelve-Factor App and defined a security best practice approach for ensuring a secure source control system. Considering the importance of applying security in a modern DevOps world, this next chapter examines the security component of step two of the Twelve-Factor methodology. 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 ...

June 21, 2018

DevSecOps is quickly gaining support and traction, within and beyond information security teams. In fact, 70% of respondents believe their culture can embrace the change needed to fuse Security and DevOps, according to a new survey of 80 security professionals by Aqua Security ...

June 20, 2018

The larger the company size, the higher the proportion of low IT performers, according to the State of DevOps: Market Segmentation Report from Puppet, based on the 2017 State of DevOps Survey data ...

June 18, 2018

An overwhelming 83 percent of respondents have concerns about deploying traditional firewalls in the cloud, according to Firewalls and the Cloud, a survey conducted by Barracuda Networks...

June 14, 2018

Despite the vast majority of cloud management decision-makers believing that DevOps and microservice enablement are important, very few believe that their organizations are capable of delivering them today — a gap that is costing the average enterprise $34 million per year, according to new report from the Ponemon Institute ...

Share this