Did you know that the general program for PASS Data Community Summit 2024 (November 4-8) was recently unveiled? This year’s lineup includes over 150 different sessions being delivered by over 140 speakers!   One of the many reasons why attendees love PASS Summit is the volume of high-quality educational content they can take away from the conference and implement in their day-to-day work. Taking a few days off work to connect, share and learn with the data community pays dividends as the learnings from the conference typically helps to save attendees – as well as their res ..read more

Redgate Monitor is an essential tool for DBA teams worldwide, providing real-time monitoring of SQL Server and PostgreSQL performance. With RedgateMonitor, you can easily track deployments, errors, and other events on the timeline. This feature, called annotations, allows you to quickly identify the root cause of performance issues and take corrective action. Redgate Monitor’s timeline is a powerful tool that helps you stay on top of your database performance and keep your systems running smoothly.  You’ll use a PowerShell script to add the annotations to the timeline with just a handful ..read more

Redgate recently published the 2024 State of the Database Landscape report, which explores how the challenges for data professionals now encompass a lot more than managing and monitoring their database estates for high availability and optimum performance. Database DevOps, multiple database platforms, the cloud, AI, and making data available for development and testing have now also become part of the daily conversation. Nearly 3,800 database professionals from a range of sectors in organizations of every size around the globe participated in the survey behind the report, providing an opportu ..read more

Historically, Flyway has been a migrations-based database deployment tool. It greatly improves database deployments by tracking what migration scripts have been executed against a target database and applying any pending migration scripts. Since Redgate acquired Flyway in 2019, we’ve been incorporating Redgate’s database comparison technology into the paid editions (Flyway Teams/Enterprise) so that users can benefit from the best of both worlds: State – object level history to see how each object has changed over time Migrations – full control over how database changes are deployed Flyway Te ..read more

With the rise in the quantity and the complexity of data organizations now need to handle, the nature of the data that you store is driving the reason for your database platform of choice. Sometimes you have a mix of data, where some is relational and some is heterogeneous, which cannot be contained in a relational format. So that’s why, as an organization, when you evolve your business, you have to switch to a different flavor of database, which is not relational. For example, if you’re a mortgage company, you store a lot of documents for your customers and you might want to move to a docume ..read more

The 2024 State of the Database Landscape survey showed that 79% of businesses are now using two or more database platforms (vs 62% in 2020). Businesses revealed that this growth was largely due to the differing use cases across each platform, as well as the need to increase flexibility. Despite these recognized benefits, increasing the diversity of your database platforms can bring its own set of challenges, including skillset requirements, data integration complexities, security, and monitoring. So, how can database professionals overcome these challenges? Here are four key steps to take towa ..read more

I don’t know about you, but after the pandemic I was really left with a newfound appreciation for attending in-person events and connecting with people in real life. Don’t get me wrong, I love the flexibility that comes with hybrid events, and I attend my fair share of virtual meetups throughout the year, but they never seem to have as much of a lasting impact on me. Shortly after joining the Events team at Redgate in 2023, I was very lucky to be able to attend my first PASS Data Community Summit. There was something very special about seeing the data community come together to connect, share ..read more

Deploying database code using pipelines in various CI/CD tools is a common practice among our customers who use Flyway. To enhance security and avoid hardcoding sensitive information like connection strings, they frequently employ variables and secrets in the pipelines. Recently, Redgate introduced a new way to configure target database connections with Flyway CLI 10 called environments. In this article, I’ll demonstrate how to use environments inside your pipeline commands both with and without creating an environments section in the toml configuration file. Customers may want to avoid adding ..read more

You may have heard of test data management (TDM). It’s part of the software delivery process – some would say a crucial part, involving the creation, management, and maintenance of environments for software development and testing. By provisioning fresh, production-like data, it allows developers to test their proposed changes early, thoroughly, and repeatedly with the right test data, when they need it and where they need it. All of which results in robust, reliable database deployments, fewer bugs, and shorter lead times for changes. It’s not new either. As far back as 2016, the definitive ..read more

We recently sat down with James Phillips, CIO at Rev.io, to talk about test data management (TDM) and the growing attention it’s getting from the C-suite. It’s been prompted by the recognition that provisioning test and development environments with realistic production-like data improves the quality of code being developed, reduces errors, and deliver new features to customers faster. But what do development environments look like without test data management in place, what challenges does that present, what are the real quantifiable benefits and, most importantly, how do you introduce it? L ..read more