|
By Josh Pamplin
Over £2 billion has been earmarked for the IT modernisation of the NHS. Let's explore some of what this means for IT teams and how Redgate can help. The NHS, England’s national health service, has always been a marvel – a complex, interwoven system delivering life-saving care to millions. But behind the clinical brilliance lies an equally intricate network of databases, servers, and IT systems that keep the whole operation humming.
DB-Engines reveals PostgreSQL as the DBMS of the Year 2024, beating Snowflake and Microsoft's Azure SQL Database and SQL Server. One of Redgate’s community websites, DB-Engines, is today announcing that PostgreSQL is the DBMS of the Year for the second year in a row, winning for the fifth time overall after also being top-ranked in 2017, 2018, 2019, and 2023. Second in the rankings was Snowflake, followed by Microsoft in third place.
DB-Engines reveals Snowflake as the DBMS of the Year 2024, beating PostgreSQL and Oracle. DB-Engines is today announcing that Snowflake is our DBMS of the Year for 2024, the third time it has claimed the top spot having previously been ranked first place in 2021 and 2022. Second in the rankings was PostgreSQL, followed by Oracle in third place. Snowflake has emerged as the most popular database management system over the past year, outpacing all other 423 monitored systems.
|
By Stephanie Herr
Read on to learn about how you can automate even more things with Flyway like project setup and state-based deployments. We’ll share how you can get the latest version and things you need to know when upgrading.
|
By Mri Pandit
This is a guest post from Mri Pandit. Information is the cornerstone of business operations, and data is now the most critical asset for any organization. But as reliance on data grows, so do the risks associated with breaches, fraud, and non-compliance. For most organizations, particularly in highly regulated sectors like finance, security and compliance are no longer optional – they’re essential for survival.
|
By Kathi Kellenberger
Many of my customers are using Flyway Enterprise to create migration scripts that will then be used to deploy database changes. They’ve been using Flyway Desktop, but some of them have expressed interest in using command line instead of the desktop.
|
By Graham McMillan
In mid 2024, one of Redgate’s coaches, Clare, pulled together a team to focus on improving inclusivity within Redgate’s Engineering organisation. This group was designed to work alongside the wider company initiatives, under the guidance of Engineering leadership. Inclusivity is a very broad topic, and the group wanted to avoid becoming overwhelmed with all the possible options.
|
By James Hemson
We’re excited to reveal our latest effort towards simplifying and accelerating the test data management process: AI Synthetic Data Generation, part of Redgate Test Data Manager. Officially introduced in a session at the recent PASS Data Community Summit, the capability uses machine learning to rapidly generate realistic yet entirely synthetic data – all while maintaining data integrity and with data privacy built-in as priority.
|
By James Wood
Have you heard about DORA in the past few months? That’s the Digital Operational Resilience Act, not DevOps Research and Assessment (DORA) on this occasion, which has been gathering pace and attention as the deadline for implementation approaches.
|
By Matt Hilbert
Every IT and data team in Financial Services is already faced with many challenges. They manage large database estates with Personally Identifiable Information (PII) that is particularly sensitive, requiring governance and process protection. They have to constantly adapt to changing customer expectations with better products, more seamless experiences, and five-nines availability. They’re expected to deliver new features and services quickly, while keeping data safe.
|
By Redgate
Flyway's JSON output provides a lot of useful information about the migrations files, database, and version changes, in a format that automated processes can read and use. This article demonstrates how we can crate a Flyway callback that uses this JSON output to automatically send simple, human-readable notifications of what happened during a migration, helping developers stay informed about version changes that could impact their work.
|
By Redgate
In this episode of The Tony and Tonie Show the pair discuss using PowerShell-based tokenization to compare two SQL migration files. How it ignores non-functional changes like comments or formatting and pinpoints the first meaningful change in SQL logic, providing detailed feedback on its location and nature. Make sure to subscribe to our channel if you want to watch more from Tony & Tonie.
|
By Redgate
Today, all the hosts (Louis Davidson, Ryan Booz, Kellyn Gorman, Steve Jones, and Grant Fritchey) get together for a festive adjacent discussion about AI, content, books, community, vector, PIVOTing, observability, and we end up with a brief discussion on gluten-free gingerbread men (because we did!) All this, though absolutely none of us broke into song like a Hope/Crosby musical!
|
By Redgate
Managing database security, compliance, and performance across a complex estate is no easy task. In this video, Tony and Tonie discuss how Redgate Monitor Enterprise brings all the data you need into one place. They speak about how it helps DBAs track user permissions, ensure configuration compliance, create custom reports, and implement resilient high-availability monitoring, and more.
|
By Redgate
In this video Tony and Tonie discuss the quick way to verify whether a Flyway validation error is a real cause for concern, due to retrospective metadata changes, or just the result of a developer valiantly adding formatting and documentation to improve the code. If the latter, developers can safely run Flyway repair to resume normal migrations.
|
By Redgate
In this Advochats episode of Simple Talks, we welcome a new Advocate to the podcast - Kellyn Gorman! And since Kellyn is the Oracle Advocate, this week's show focusses on how Oracle differs from other data platforms that the advocates have used.
|
By Redgate
In this latest episode, Tony and Toney discuss PostgreSQL's buffer cache hit ratio (BCHR), a metric tracked by Redgate Monitor to help you assess the health and performance of your databases. By correctly interpreting this ratio and using it with other relevant memory and IO metrics, you can identify potential bottlenecks in query execution before they impact users.
|
By Redgate
Frank Geisler, CEO of GDS Business Intelligence GmbH, explains how the templates in SQL prompt enable team collaboration. SQL Prompt enables users to write high quality SQL faster. As well as autocompleting your code, SQL Prompt takes care of formatting, object renaming, and other distractions, so you can concentrate on how the code actually works..
|
By Redgate
On this episode of Simple Talks, Louis hangs out with Aaron Bertrand and talks hockey, curling, football, hybrid cars and even some technology. One of the big (non-sports) themes of the episode is that Aaron is a problem-solver and is interested in how issues can be overcome with technology - even if his focus now and in the conceivable future is being a top-level expert with some of the aspects of SQL Server.
|
By Redgate
In this episode of The Tony and Tonie Show, the pair discuss how Environment Variables make interactive use of Flyway much easier, and how they are essential when developing callback scripts. This article explains the range of configuration details you can provide and how, and demos a PowerShell script to auto-convert the parameter values stored in Flyway.conf files into environment variables.
- January 2025 (5)
- December 2024 (6)
- November 2024 (6)
- October 2024 (9)
- September 2024 (7)
- August 2024 (12)
- July 2024 (10)
- June 2024 (4)
- May 2024 (5)
- April 2024 (12)
- March 2024 (13)
- February 2024 (8)
- January 2024 (3)
- November 2023 (10)
- October 2023 (3)
- September 2023 (4)
- August 2023 (5)
- July 2023 (6)
- June 2023 (4)
- May 2023 (3)
- April 2023 (5)
- March 2023 (4)
- February 2023 (6)
- January 2023 (6)
- December 2022 (1)
- November 2022 (4)
- October 2022 (2)
- September 2022 (2)
- August 2022 (2)
- July 2022 (2)
- June 2022 (3)
- May 2022 (8)
- April 2022 (2)
- March 2022 (6)
- February 2022 (4)
- January 2022 (6)
- December 2021 (6)
- November 2021 (3)
- October 2021 (3)
- September 2021 (7)
- August 2021 (1)
- July 2021 (10)
- June 2021 (5)
- May 2021 (10)
- April 2021 (13)
- March 2021 (7)
- February 2021 (8)
- January 2021 (7)
- December 2020 (19)
- November 2020 (1)
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.