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

May 22, 2018

DEVOPSdigest asked experts from across the IT industry for their opinions on the top tools to support DevSecOps. Part 2 covers DevOps and development ...

May 21, 2018

While DevSecOps, much like DevOps itself, is more about changing IT culture than employing certain types of technology, some tools can be an important support. To find out what the right tools are, APMdigest asked experts from across the IT industry for their opinions on the top tools to support DevSecOps. Part 1 covers the testing phase ...

May 17, 2018

The top two business priorities for CIOs of midsize enterprises (MSEs) in 2018 are growth and digital transformation. However, 57 per cent of MSEs are not yet delivering digital initiatives, according to findings from Gartner Inc.'s 2018 CIO Agenda Survey ...

May 15, 2018

Almost every company is facing the challenge of digital transformation today. This means rethinking and retooling your company to compete and succeed in an increasingly digital world. While digital transformation is not only about technology, the right tools can help. To find out what these right tools are, APMdigest asked experts from across the IT industry for their opinions on the essential tools to support digital transformation ...

May 08, 2018

With data breaches consistently being in the news over the last several years, it is no wonder why data privacy has become such a hot topic and why the European Union (EU) has put in place General Data Protection Regulation (GDPR) which will become enforceable on May 25, 2018, which is less than a month away ...

May 03, 2018

The prospect of increased workloads, combined with shrinking mainframe skillsets, has huge implications for mainframe DevOps. The only way for organizations to solve this skills gap crisis is by optimizing developer productivity. Drilling down a level further, what does this all mean for mainframe DevOps? ...

May 02, 2018

When it comes to operations and development, DevOps has changed the traditional compartmentalized style of development by eliminating silos. But what about the security team? Security is largely still siloed from operations and development. No doubt, many DevOps teams have some security controls baked into their automation processes, but a recent survey shows there are still alarming gaps ...

April 30, 2018

According to the 2018 Global Security Trends in the Cloud report, 93 percent of respondents faced challenges when deploying their current on-premises security tools in the cloud, and 97 percent lacked the tools, cross-functional collaboration and resources to gain proper insight into security across the organization. These numbers indicate a big problem in DevSecOps that needs to be addressed ...

April 26, 2018

Moving more workloads to the cloud is a top IT priority, so eventually it will be time to consider how to make those critical legacy applications cloud ready. In Part 1 of this blog, I outlined the first four of eight steps to chart your cloud journey. In addition, consider the next four steps below ...

April 25, 2018

Clearly, moving applications to the cloud delivers significant advantages. So what's standing in the way of full cloud adoption? For many companies it's those burdensome (but critically important) legacy applications. Moving more workloads to the cloud is a top IT priority. So, eventually it will be time to consider how to make those critical legacy applications cloud ready. Consider the following eight steps to chart your cloud journey ...

Share this