Cambridge, UK
Apr 15, 2021   |  By Redgate
To help organizations explore and manage the advantages the cloud provides, the latest release of Redgate's popular database monitoring tool, SQL Monitor, now supports Amazon EC2 and RDS, and Azure SQL Database and Azure Managed Instances as well as on-premises SQL Server.
Apr 14, 2021   |  By Annabel Bradford
My blog post from February 1 explains that Redgate took the opportunity to purchase the assets of PASS with the main goal of supporting the community. The PASS association ran for 21 years bringing together a community to connect, share, and learn. The community of course lives on, however the association no longer exists as it once did. Working with SQL Server and the data platform is what unites us all. Data is at the heart of everything we do.
Apr 12, 2021   |  By Lindsay Hegarty
As the manager for enterprise applications and data at the University of the Sunshine Coast in Queensland, Australia, I face a lot of unique challenges. The university itself has around 25,000 students, 1,000 permanent staff and another 1,000 seasonal staff who assist with key academic sessions. They’re spread out across the flagship campus at Sippy Downs and a number of satellite campuses and research and teaching facilities in other locations.
Apr 12, 2021   |  By Grant Fritchey
This question was raised at the recent Redgate Summit: How does the implementation of a microservices architecture affect the implementation of a database DevOps approach? I could even rephrase it a little: Does a microservices architecture affect a database DevOps approach?
Apr 7, 2021   |  By Collette Johnson
Since 2018, over 2,400 SQL Server professionals have provided valuable insights into how they monitor and manage their estates, and what challenges they’re facing, through the only industry-wide survey of its kind. The results of the annual survey have not only benefited the community but also helped us better understand how we could shape our own product development to deliver more value where organizations need it.
Apr 7, 2021   |  By Maxime Drobot
There’s no doubt the cloud is having a big impact on the nature and make-up of SQL Server estates. The 2021 State of Database DevOps report from Redgate, for example, showed that 58% of organizations now use the cloud either wholly or in combination with on-premises servers, compared to 46% in the same report a year earlier.
Apr 5, 2021   |  By Grant Fritchey
I work in computers and my son works in manufacturing, but both of us loathe a single phrase: We have always done it this way. Please allow me to be clear on this. If you can back up this statement with “Because…”, and you list out valid points, even if I disagree with them, we’re all good. However, frequently, if you follow up this statement with the simplest of questions, “Why?”, you don’t get good answers.
Mar 29, 2021   |  By Grant Fritchey
When you begin to automate your deployments, you’re also going to start automating your testing. After all, a deployment, in and of itself, is a test. However, pretty quickly, you are going to come to the question that’s the title of this post: Who is responsible for building tests?
Mar 22, 2021   |  By Grant Fritchey
When I first started trying to figure out how to automate database deployments, over 15 years ago, I will freely admit, I was both skeptical and reluctant. I had to be dragged up to the notion that automating getting the database code out the door wasn’t just an excuse by the developers to find a way to bypass the DBA team. As per the traditional, biased, story, our favorite word was “No!”.
Mar 16, 2021   |  By Grant Fritchey
Almost every time I teach a class on DevOps, one of the questions that comes up is: How do we do code reviews in this automated process? There are actually a number of answers to this question. Let’s walk through a few.
Apr 12, 2021   |  By Redgate
Ever wanted to get a look at SQL Monitor? Chris Kerswell from Redgates Solution Engineering team takes us through the easiest way there is - using the SQL Monitor demo site! In this video, Chris shows us how to access the site and some of the key features available or interesting things to have a closer look at.
Apr 6, 2021   |  By Redgate
In this video Solution Engineer Dave Ong will provide you with an insight into Flyway, Redgate’s cross database solution to help you manage database migrations and achieve your DevOps goals. We will look at how you can leverage both versioned and repeatable migrations with both manual and CI/CD deployments that can be unlocked with the power of Flyway.
Mar 29, 2021   |  By Redgate
Switching branches quickly and testing Pull Request code when working on database changes is no easy thing, but fear not! Join Chris Unwin in this video to find out how you can set up SQL Clone to allow developers to preserve changes when switching branches, and how teams can review code against a live DB, rather than relying on the raw code in version control.
Feb 3, 2021   |  By Redgate
Do you need to mask data consistently, every single time? In this video, Chris Unwin shows us how to use Redgate Data Masker for SQL Server to deterministically mask sensitive values so they can always be used for the same purpose, each time you mask a new copy.
Feb 2, 2021   |  By Redgate
In this video you’ll get an overview of how Redgate’s SQL Change Automation PowerShell module can plug into Jenkins using pipeline-as-code to build and deploy your SQL Server Databases. For more information, feel free to email in, leave a comment below or visit the Redgate website!
Jan 21, 2021   |  By Redgate
Azure DevOps pipelines allow you to create powerful automated workflows. Combining YAML pipelines with Redgate's SQL Change Automation and SQL Clone allow you to create production-like environments on-the-fly for database code review.
Jan 8, 2021   |  By Redgate
In this Data Masker Headscratcher, Chris shows us how to mask a Heap table by creating a temporary Unique Key constraint, enabling substitution rules to run.
Jan 8, 2021   |  By Redgate
In this video you’ll get an overview of how Redgate’s SQL Change Automation PowerShell module can plug into GitLab using pipeline-as-code to build and deploy your SQL Server Databases.
Jan 5, 2021   |  By Redgate
From version control to continuous delivery, Redgate Deploy lets your teams automate database development processes so you can accelerate software delivery and ensure quality code.
Dec 21, 2020   |  By Redgate
SQL Change Automation's Drift Reports give you important insights into how your target database environment may have "drifted" -- before you deploy. In this video, we go from defining database drift into the internals of how the drift report works, then demo the three options you have to configure the drift report.

Our solutions make life easier for development, operations, and IT leaders by solving the database challenges in delivering software at speed.

Solutions for every stage in your Compliant Database DevOps journey:

  • Standardize team-based development: Prevent rework and conflicts, build consistency and quality into your code, and gain time for development that adds value, with standardized best practices for database development.
  • Automate database deployments: Unlock agility and performance across the full software lifecycle, with database continuous integration, continuous delivery, and shift-left testing that let you rapidly respond to user requirements.
  • Monitor performance and availability: Avoid performance issues, minimize downtime, and support efficient recovery with proactive visibility and insight into your database estate.
  • Protect and preserve data: Decrease the risk of breaches, protect business critical data, and meet compliance requirements while supporting data demands from developers and testers.

Discover how Compliant Database DevOps empowers your team.