devopsy.kinsta.cloud

Tag: redgate

  • Redgate Extends Effort to Integrate Database Management and DevOps Workflows

    Redgate Extends Effort to Integrate Database Management and DevOps Workflows

    Redgate has updated its Flyway platform for applying DevOps workflows to database platforms to now provide deeper integration into command line interface (CLI) tools and integrated developer environments (IDEs).

    In addition, the Flyway platform now enables state-based deployments using scripts that can be generated based on a specific schema.

    Finally, Redgate is also adding options that enable DevOps teams to choose whether they want to include backups as baselines, automate the backup process altogether or never allow any type of shadow database.

    Max Drobot, group product manager at Redgate, said these latest additions are intended to make it simpler for software engineering teams with varying levels of maturity to start automating the management of databases within the context of a DevOps workflow. Rather than trying to create the perfect process, it’s now simpler for DevOps teams to more easily experiment with automating database deployments without increasing risks, he added.

    While DevOps engineers and database administrators (DBA) often need to work closely with one another, each of these teams has historically developed a separate culture around different classes of tools. Since it first launched Flyway, Redgate has been making a case for a platform that helps narrow that divide by enabling DevOps engineers to, for example, spin up a database when needed versus waiting for a DBA to have the time that would otherwise be required.

    That approach doesn’t eliminate the need for a DBA, but it does serve to reduce the overall level of friction that often exists between DevOps teams and DBAs, noted Drobot.

    The need to reduce that friction will become that much more pressing as the amount of data that needs to be incorporated into the next generation of artificial intelligence (AI) applications continues to exponentially increase, he added.

    Additionally, DevOps teams as part of building and deploying more secure applications will also eventually need to programmatically apply policies and guardrails to the data being accessed by their applications, noted Drobot.

    Managing databases has, of course, become more challenging as the number and types of them has steadily increased. Provisioning and managing databases using legacy manual processes is simply no longer tenable, he said.

    Many organizations are already embracing platform engineering as a methodology for managing DevOps workflows at scale, so it’s now more a question of when database operations will become more centrally managed within the context of a software development lifecycle (SDLC).

    In the meantime, DevOps teams might want to review how application developers are selecting databases for building applications today. All too often, rather than adhering to corporate standards, those decisions are based more on personal preference. In fact, it’s not uncommon for IT teams to find themselves spending time migrating an application developed on one database to another that the organization actually supports.

    Each organization will, of course, need to decide on its own to converge the management of DevOps and database operations but given the pace at which modern applications are now being developed and updated in the age of AI, the amount of pressure being applied to achieve that goal is only going to continue to increase.

  • Redgate Automates Pulling of Test Data From Production Databases

    Redgate Automates Pulling of Test Data From Production Databases

    Redgate today added a Redgate Test Data Management (TDM) tool that automates the pulling of masked test data from databases running in production environments.

    David Gummer, chief product officer for Redgate, said this capability eliminates manual tasks that previously inhibited testing or resulted in personally identifiable information (PPI) being inadvertently used to test applications.

    Redgate TDM automatically classifies and masks data residing in SQL Server, PostgreSQL, MySQL or Oracle database before it is used to test an application. It then produces a copy or clone of that data that is a fraction the size of the original, said Gummer.

    That approach creates a repeatable process for DevOps teams that can withstand a regulatory audit of application development processes, he added. In fact, with the increased focus on software supply chain issues, more auditors are specifically reviewing how data is secured during the application development process.

    Designed to be invoked via a command line interface (CLI), within an integrated development environment or via a graphical interface, Redgate TDM reduces the friction that currently occurs when DevOps teams request test data from database administrators (DBAs), said Gummer. Many DBAs are either too busy to fulfill those requests or reluctant to provide access to sensitive data that would result in the organization running afoul of a compliance mandate.

    Developers then often resort to using anonymous data that doesn’t actually reflect the environment in which their application will ultimately be deployed.

    The amount of data that developers need to build applications is only going to increase. In the absence of any way to effectively automate the process of accessing that data, it ultimately takes longer to build and deploy stable applications. In many cases, applications are simply not tested as thoroughly as they should be before being deployed in a production environment, resulting in rollbacks that might otherwise be avoidable.

    Advances in artificial intelligence (AI) are making it easier to create test scripts, but much of the testing setup process is still based on manual processes that increase the overall level of toil.

    At a time when more organizations than ever are trying to increase developer productivity, automating relatively mundane tasks such as pulling test data can have a big impact. Developers want to spend as much time as possible focused on writing code. Everything else is a task that gets in the way of achieving that goal. While there is a general desire to empower developers, that doesn’t necessarily mean they want the cognitive load associated with building applications to increase. In fact, one of the reasons platform engineering has emerged as a methodology for managing DevOps workflows at scale is to reduce the current level of cognitive load developers experience today.

    Of course, DevOps teams are, by their nature, ruthlessly committed to automating as many processes as possible. The challenge is bottlenecks in those processes conspire to slow down the overall rate at which applications can be built and deployed despite the best intentions of all involved.

  • Redgate boosts team productivity in its SQL coding and formatting tool, SQL Prompt

    Cambridge UK, Tuesday, 7 November 2019– To help developers increase the speed and quality of their SQL coding, enhance efficiency, and take advantage of the latest improvements in SQL Server, Redgate has released a major upgrade for its most popular tool, SQL Prompt.

    Many individual developers and an increasing number of teams have already discovered the value of SQL Prompt, both as a coding productivity tool and as a way to encourage collaboration in DevOps. Rather than having to work out the correct syntax the hard way, SQL Prompt autocompletes code in SQL Server Management Studio (SSMS) and Visual Studio, and takes care of formatting. It also encourages teams to implement and share good SQL coding standards and practices, and promotes code reuse, improving the quality of the code that reaches production systems

    A new ranking algorithm in SQL Prompt v10 makes the code completion feature even smarter. As developers type code, it now gives them the most likely autocomplete suggestions first, based on what code has already been typed, and suggestions that have been used previously.

    Early feedback has already been very favorable. As Piotr Lipski, Business Intelligence Consultant at Bearing Point, comments: “After enabling the ranked option, I am getting the right thing on the very top of the IntelliSense list almost every time. Not sure what voodoo your developers put behind this but it saves me a lot of scrolling and clicking.”

    To improve the quality of coding, another new feature in SQL Prompt also auto-fixes errors in code. As users write code, SQL Prompt runs static code analysis in the background, checking the code for compliance with its built-in set of rules, and highlighting potential code issues and pitfalls. For rules where code simply needs to be corrected, SQL Prompt will auto-fix the code and remove the issue.

    This is especially useful when reviewing legacy code that needs to be brought up to standard. By cutting the time required to deal with trivial issues, it allows teams to focus on the more serious ones which might cause performance, reliability or instability problems.

    And in response to user feedback, two of the most popular requests have been addressed by enhancing the tab history feature in the SSMS version of SQL Prompt. Many developers have multiple tabs open in SSMS, particularly when they are resolving complex problems. The feature already lets users save, preview, rename and restore tabs. It now allows tabs that contain code that is needed often to be bookmarked, and groups tabs by date to make them easier to find.

    Finally, any tool that strives to help teams adopt SQL standards and current best practices can only do so if it adapts continually to support advances in the underlying database platform, SQL Server. SQL Prompt 10 supports all of the significant T-SQL enhancements introduced in SQL Server 2019, the release of which was announced at Microsoft Ignite on 4 November. Users can now, for example, assign data sensitivity classifications to their columns using the new ADD SENSITIVITY CLASSIFICATION command.

    Existing users of SQL Prompt can start using the new functionality immediately by updating to the latest version using the Check for Updates link in the Help menu. New users can explore the feature by downloading a fully-functional trial version of the software from the Redgate website. Once installed, SQL Prompt will appear in the standard menu of SSMS or Visual Studio and can be used just like any other feature of the IDE.

     

  • Redgate Software’s new data privacy approach endorsed with major awards

    Cambridge UK, Tuesday 15 January 2019 – As the leading Microsoft SQL Server tools vendor, Redgate Software constantly updates and develops its software further to keep pace with changes in technology and market conditions. Two years ago, it embarked on an initiative to help customers comply with increasingly stringent data privacy regulations, and its efforts in developing its new SQL Provision solution have been recognized with two major awards.

    SQL Provision received a gold in the Security & Copy Protection category at the 2019 Visual Studio Magazine Reader’s Choice Awards, and Redgate was also revealed as the Best Performing Company in Security & Infrastructure Software in the recent Megabuyte50 Awards.

    Launched in January 2018, SQL Provision offers companies a new way to provision copies of production databases for use in development and testing. Many developers like to work with such copies to test their changes against and ensure they are not breaking changes. Those copies, however, often contain personal data which legislation like the GDPR and the Payment Card Industry Data Security Standard require to be safeguarded.

    SQL Provision resolves the problem by masking sensitive data with data that is truly representative of the original and retains its referential integrity and distribution characteristics. It then uses the tried and tested virtualization technologies built into the Windows operating system to create copies, or clones, of the masked database in seconds. The clones are only around 40MB in size for a 1TB database, work just like normal databases and can be connected to and edited using any program.

    Importantly, the masked clones can be provisioned repeatably, reliably and quickly, and SQL Provision also provides an audit trail to demonstrate compliance with data privacy legislation. Hence the popularity of the solution with readers of Visual Studio Magazine, and recognition of Redgate’s contribution to security software by independent research provider, Megabuyte.

    As Simon Galbraith, Redgate CEO, comments: “The really good news for me is that the votes of Visual Studio Magazine readers for SQL Provision were backed by an independent and objective view of Redgate as a company which is actively developing new solutions to help customers develop databases faster, yet also keep the data within those databases safe. New data protection legislation is making compliant database DevOps an important approach for many companies, and as a leading software vendor, we think it’s our responsibility to research and develop solutions that can help.”

    Alongside the gold award for SQL Provision, Redgate also won some other notable Visual Studio Magazine awards. SQL Toolbelt received a gold for the fourth year running in the Databases and Data Development and Modeling category, SQL Prompt won a gold for the second year running in the Productivity Tools category, and Redgate’s ANTS Performance Profiler won a silver in the Performance, Profiling and Debugging Tools category for the fourth time.

    Redgate continues to develop SQL Provision to make it more valuable to users, and the product team is currently researching areas like masking templates which can be applied ‘off-the-shelf’, and providing alerts when databases are updated and new sensitive data needs to be masked.

     

  • Redgate Software demonstrates ethical selling approach with two big wins at the BESMA Awards

    Cambridge UK, Tuesday 27 November 2018 – The recent British Excellence in Sales Management Awards saw Redgate Software doubly rewarded for its efforts in instilling an ethical sales culture. The leading Microsoft data platform tools vendor won gold in both the Sales Director and Key Account Manager of the Year categories.

    Now in its 12th year, the BESMA awards represent the UK’s highest level of recognition for outstanding sales achievement, and highlight organizations which demonstrate best practice in sales. Long recognized as the sales industry’s top awards event, the quality of entries increases each year, and 2018 was no different. 800 entries were received from companies like IBM, Marriott Hotels, McAfee, PwC, and Rolls-Royce, and there were 80 finalists across 17 different categories.

    The entries were evaluated by a panel of high caliber judges headed by Kerry Nutley, Vice President Digital Sales at BT, and including senior executives from companies as varied as BAE Systems, Experian, Lloyds Register, Microsoft and Siemens.

    The awards dinner was held at the Grosvenor House Hotel, Park Lane, London, on 26 October 2018, where the Redgate sales team saw two of their peers being rewarded.

    In the Key Account Manager category, Mike Hallam, a BESMA judge and Director of Indirect Sales at Virgin Media Business, said prior to the winner being announced: “What we as judges are looking for are the finalists to explain to us what they see as the key strategic pillars for them to develop the relationship, how they overcome challenges and objections that the customer may have with them, and equally how they obviously grow the account.”

    Key to that was ethical selling – working for the customer, rather than simply focusing on a sale at any cost. In a crowded category with strong candidates from companies like PwC, SSE and Yell, the winner was James King, Redgate Account Executive.

    The Sales Director category was equally challenging, and the judges were looking for an individual who had shown motivation and leadership within a culture of responsible and ethical sales, delivering solid results.

    As Darren Bayley, a BESMA judge and Vice President of Marketing at Dentsply Sirona, said: “We were looking for someone truly outstanding, both in terms of leadership, strategy, and also delivering results. But really importantly as well, we were looking for someone who puts ethical selling right at the heart of their business.”

    Despite competing against an impressive line-up of finalist from the companies like Cognism, Natterbox and Vodafone, the winner was Cassi Roper, Redgate Regional Sales Director.

    Redgate was also a finalist in the Sales Employer of the Year category, and the Sales Team of the Year (under 50 people) category, and the awards are a validation of a two year journey for the sales team.

    As Cassi Roper said after the ceremony: “I’m delighted to win an award, but I’m also really proud that Redgate was a finalist in four categories. That’s a result of a huge amount of effort from the whole company in supporting the sales effort, opening new sales offices in Australia and Germany as well as the US, and putting customers at the heart of how we work.”

  • Redgate enhances the appeal of compliant database DevOps with new provisioning dashboard for SQL Clone

    Cambridge UK, Wednesday 24 October 2018 – The leading Microsoft SQL Server tools vendor, Redgate, has introduced a new at-a-glance dashboard to its database provisioning solution, giving users an easy way to manage, organize and make available masked copies of databases.

    Copies of production databases are commonly used in development to test changes against and ensure they are not breaking changes. Shifting left the testing in such a manner is one of the ways a DevOps approach can be applied to the database in order to speed up development and minimize deployment errors.

    Redgate’s provisioning solution uses the tried and tested virtualization technology built into 64-bit Windows to create database copies, or clones, which are a fraction of the size of the original. While they work just like normal SQL Server databases and can be connected to and edited with any program, they typically take up only megabytes of space, even for databases of 64TB in size.

    As importantly in an age when data breaches are prompting the introduction of stricter data privacy legislation, the provisioning solution also enables sensitive data in the clones to be masked at the time they are created.

    Rather than simply randomizing the data, it uses pseudonymization and anonymization techniques to ensure the database is truly representative of the original and retains its referential integrity and distribution characteristics. The sanitized copies can then be used to speed up development, accurately test code, and fix issues faster. Their small size also encourages a dedicated development model where developers are free to have their own personal copy of the database to work with.

    The increasing demand for and use of masked copies, however, can make managing multiple copies across disparate teams a complicated task. To address this, Redgate has developed a dashboard to make the searching, grouping, renaming and management of copies fast and easy.

    The copies in use can now be grouped by location, the database version they were created from, and the instance they are on, and searched by name, creation date or size from the dashboard. Importantly, if a developer tests a change which breaks their copy of the database, it can be reset to its original state in seconds rather than having to be deleted and recreated.

    The activity view additionally gives Database Administrators an instant picture of what has happened over the last seven days, who did it, and any errors that occurred. For errors that occurred previously, the log files can be retrieved in a couple of keystrokes.

    To increase security and further demonstrate compliance with data protection legislation, Active Directory role-based access can also be used so that users without appropriate permission only have access to masked copies of the database.

    As Rebecca Edwards, Redgate Product Marketing Manager, concludes: “At Redgate, we’re constantly talking to companies to discover what challenges they face in their desire to develop applications and databases faster while also keeping data safe. This latest addition to our database provisioning solution will help them comply with data protection legislation – and demonstrate compliance – while making their jobs easier.”

  • Redgate University launches, helping customers maximize their investment in award-winning SQL tools

    Cambridge UK, Wednesday 2 October 2018 – Redgate Software today announced the launch of  Redgate University, a new online resource designed to quickly train users on its tools and spread knowledge within customer teams. Covering everything from installation and configuration to ongoing operations, the range of free, video-based courses aims to help customers increase the value they get from working with Redgate’s products.

    Redgate’s tools have traditionally been used by database administrators (DBAs), but the growing importance of databases to DevOps, compliance and business operations mean that they are now central to operations across multiple teams. For example, according to the 2018 Redgate State of Database DevOps Survey, 76% of teams have developers who are responsible for both database and application development, while 75% say developers also build database deployment scripts.

    The new Redgate University enables businesses to give their development teams access to the knowledge and training they need, in a way that works for them. The self-paced modular videos, featuring a combination of presenters and step-by-step demonstrations can be watched online 24×7, enabling users to learn in a way that is convenient and straightforward.

    Importantly, each of the courses is divided into modules so users can self-select the learning they need to match the level of knowledge they already have. The classes in each module are also around five minutes or less in length, so the learning can be fitted into a busy day in bite-size segments.

    The SQL Source Control course, for example, has four modules so users can quickly choose from the basics like linking a database to the source control system already in place for applications to more advanced features like using object locking and setting up filters.

    The new courses join Redgate’s comprehensive range of support and training options, alongside existing webinars, its comprehensive Community Hub and a series of technical walk-through presentations.

    As Natali Stoeva, the Hub Marketing Manager for Redgate Software, explains. “We’re approaching one million users across the world, and a growing number of these are new to the database. That’s why we’ve launched Redgate University, providing everyone using our products with the skills and knowledge they need to succeed, whatever their job title or role. It’s part of our commitment to our users and customers, ensuring they can get a real return on investment from our tools, across the organization.”

    The initial range of courses on Redgate University can be accessed here, and include:

    • SQL Monitor
    • SQL Provision
    • SQL Source Control
    • SQL Change Automation (with SQL Source Control projects)

    The next batch of courses, expected to be available later this month, include other popular tools like SQL Prompt, SQL Data Compare and SQL Change Automation with migrations. Further courses are planned and users can also provide their own suggestions on tools and topics that should be covered via the Redgate University home page.

  • Redgate Data Masker part of adoption trend toward global enterprise use of data masking techniques

    Cambridge, UK, 5 September 2018, Redgate believes that Gartner’s latest – and timely – Market Guide for Data Masking provides a valuable insight into the increasing need for, and adoption of, data masking by companies to address threats and compliance requirements. It recommends companies “review your data security and compliance roadmap. Focus on vendors that offer more than one type of DM technology and support consistent policies across your DM scenarios, applications and platforms.” Redgate is listed as a data masking technology Representative Vendor.

    Published on 20 July 2018, the Market Guide predicts global enterprise use of data masking or similar de-identification techniques will increase from 15% in 2017 to 40% by 2021.

    Redgate feels that, driven by increasing privacy regulations, the growth in data, and the expanding use of analytics to extract more value from data, data masking is becoming a key way for companies to meet compliance requirements, and address insider and outsider threats.

    Data masking is needed because many companies use copies of their production databases in their development, testing and business analytics environments. Sensitive data in those databases, however, has to be protected by replacing it with fictitious data. That data in turn has to be realistic and truly representative of the original data in order to retain its referential integrity and distribution characteristics.

    Using random data will not work, which is where third party tools like Redgate Data Masker come in. They provide multiple methods to sanitize data in SQL Server and Oracle databases, use templates to remain consistent with existing data formats, and include replacement data sets such as names, zip codes and email addresses.

    Steve Jones, Microsoft Data Platform MVP, is not surprised. “Big enterprises, particularly in the financial sector, have been using bespoke data masking solutions for a long time, but the cost was a barrier for smaller players. We’re now seeing products like Redgate Data Masker give small to medium sized businesses the same advantages out of the box. They can continue to make the most of the data they have while remaining compliant with regulations like SOX, HIPAA and the GDPR.”

    Gartner’s Market Guide also recommends data masking solutions should provide tools to manage the full life cycle of masking data: deploying masking rules, scheduling or triggering a masking job, and monitoring the performance of static and dynamic data masking operations. It recommends that security and risk management leaders responsible for data security and compliance should “take advantage of innovative data-masking products at the data virtualization or application tier.”

    In February 2018, combined Data Masker with its SQL Clone tool, which uses the standard disk virtualization technologies built into the Windows operating system to create copies of databases in seconds. The copies, which are only around 40MB in size for a 1TB database, work just like normal databases and can be connected to and edited using any program.

    The SQL Provision solution that was created provides a single central management system for provisioning masked database copies with a process that is simple, repeatable, transparent, and auditable.

    “This is the way many companies will go,” concludes Steve Jones. “They need to provision masked copies of production databases for development, and by making it fast and secure, they can comply with privacy regulations, yet still get lots of value from their data.”

    A complimentary copy of the Gartner Market Guide, together with further information about Redgate Data Masker, SQL Clone and SQL Provision can be accessed from the Redgate website.

    Gartner does not endorse any vendor, product or service depicted in its research publications, and does not advise technology users to select only those vendors with the highest ratings or other designation. Gartner research publications consist of the opinions of Gartner’s research organization and should not be construed as statements of fact. Gartner disclaims all warranties, expressed or implied, with respect to this research, including any warranties of merchantability or fitness for a particular purpose.

     

  • New Redgate partner, Nexus Technology, demonstrates the growing importance of database DevOps in the banking sector

    Cambridge UK, Tuesday, 7 August 2018 – In its ongoing quest to offer clients expert on-the-ground advice as well as software to introduce DevOps to database development, Redgate Software has added Channel Islands based Nexus Technology to its worldwide partner roster.

    Over the last two years, Redgate has expanded and extended its portfolio of database development software to enable clients to include the database in their DevOps processes. By integrating with and plugging into the software already in use for applications, the faster development and release of features that DevOps promises can be delivered upon without the database being a bottleneck.

    At the same time, IT consultancy Nexus has been building a reputation in the Channel Islands for its skills in delivering technology solutions, from software development to project management, particularly in the banking and financial sectors. The consultancy’s expertise in advising customers how to drive productivity and revenue by using insights from data is a notable strength.

    As Dave Edge, Nexus Co-Founder and CTO comments: “Every company has data, but not all of them know what to do with it and they may be ticking along, unaware of how data can take their business up a gear. That’s why the new partnership is good news. It matches our skills in data analytics, forecasting and predicting, with Redgate’s software solutions that make database development faster while keeping data safe.”

    New legislation like the General Data Protection Regulation (GDPR), as well as increasing customer concerns about data breaches, also mean banks and other financial institutions are seeking ways to protect customer data while still being able to improve the services they offer.

    Conversely, perhaps, introducing DevOps to the development of the database as well as applications helps companies to stay compliant with data privacy legislation while streamlining the process. Laborious tasks are automated in a reliable, repeatable manner to remove human error from the equation, and an audit trail of what changes were made, who made them, and when they were deployed is provided that can be used to demonstrate compliance.

    Redgate’s software is already used by 91% of companies in the Fortune 100, and the new partnership with Nexus now means companies in the Channel Islands are in the ideal position to explore how too they can take advantage of database DevOps.

    As Cass Lloyd, Partner Manager for Redgate, concludes: “Once businesses start to demand more from their data, the way their databases are maintained and protected also becomes more critical. This often means adapting the development process as well as introducing new software. Our growing list of partners around the world demonstrates the value they can offer to companies who want to use our software to improve their database development, and Nexus is a welcome addition.”

     

  • New Redgate SQL Prompt release addresses technical debt in legacy SQL code

    Cambridge UK, Tuesday, 31 July 2018 – The latest release of Redgate Software’s most popular tool, SQL Prompt, elevates it from helping to develop and standardize new code to discovering problems in legacy code. The winner of the Visual Studio Magazine 2017 Reader’s Choice Gold Award in the productivity tools category, SQL Prompt plugs into SQL Server Management Studio and Visual Studio and enables developers to write, format, refactor and analyze SQL code.

    When SQL Prompt v9 launched in November 2017, it introduced a code analysis feature which spots code issues and hidden pitfalls as users type. It parses the code, as a compiler would, but rather than compile the code, it checks the syntax for compliance with a built-in set of over 90 rules. It then highlights each issue, or ‘code smell’, by underlining the offending line of code with a green squiggle.

    Developers can see immediately any issues they’ve introduced, and clear explanations and suggestions to improve their code and fix the errors are provided, along with links to further reading online. This ensures that all code committed to source control complies with a common set of coding standards and practices, and prevents issues from creeping into the build that might, now or eventually, cause performance, maintenance or security problems.

    That’s not the end of the story. The latest update to SQL Prompt allows users to analyze an entire script of legacy code, no matter how large, and see a list of all the issues contained within it. If users double-click on an issue, they’ll see that line highlighted in the code and can view more details. Code issues can also be grouped by type and exported to a CSV file which can be shared across a team or attached to a ticket in bug-tracking or task management software.

    This makes it easy to learn about the health of certain sections of the database code, or assign clean-up tasks, with each developer on a team assigned a set of issue types. By acting as a worklist for improving overall code quality, it makes it much easier to do code reviews, discover technical debt, and resolve small errors before they become big problems.

    It thus helps teams prevent technical debt from entering the code base, remove it from existing code, and ensure that released code conforms to the team’s defined coding standards.

    As Grant Fritchey, Microsoft Data Platform MVP, concludes: “When code analysis was introduced to SQL Prompt less than a year ago, it was a big move. As well as helping you write SQL code faster, it helped you write SQL code better. Extending the feature to legacy code means anyone can now use it to improve code that was written months, even years ago, as well as the code they’re working on right now.”

    Existing users of SQL Prompt can start using the new functionality immediately by updating to the latest version using the Check for Updates link in the Help menu. New users can explore the feature by downloading a fully-functional trial version of the software from the Redgate website. Once installed, SQL Prompt will appear in the standard menu of SQL Server Management Studio or Visual Studio and can be used just like any other feature of the IDE.