Operations | Monitoring | ITSM | DevOps | Cloud

Data, and the way enterprises use data in areas like development and testing, has not traditionally been a focus for business leaders but that’s now changing. Data is more varied and complicated than ever before, for example, with enterprises using two or more different database platforms – and 40% using four or more. It’s also spread wider and further, with enterprises hosting their databases in a combination of cloud and on-premises infrastructures.

DevOps is now the norm for virtually every IT team in every sector. By integrating and automating software development processes, it removes laborious, manual tasks and enables teams to deliver value to end users faster and more efficiently.

The role of effective Test Data Management (TDM) is often underestimated in the software development process, yet it is a cornerstone for ensuring quality, compliance, and efficiency throughout the software development life cycle. As Bloor say in their Test Data Management Market Update 2024, “… many enterprises are, to quote one vendor we spoke to, “still in the stone age” when it comes to TDM.

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.

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.

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.

This is a guest post from Mri Pandit. 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.

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.

The rise of the digital era has led to increasing concerns among individuals around the protection of their personal data. In 2022, for example, 24% of individuals exercised their right to Data Subject Access Requests, and this rose to 28% in 2023 according to Statista research results.

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.