Operations | Monitoring | ITSM | DevOps | Cloud

Smarter handling of Flyway validation issues | The Tony and Tonie Show

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.

Inclusive Engineering at Redgate

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.

Tracking and Improving PostgreSQL's Cache Hit Ratio | The Tony and Tonie Show

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.

How Do the Templates in SQL Prompt Enable Team Collaboration - Frank Geisler

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..

Introducing AI-Enhanced Data Generation to Redgate Test Data Manager

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.

Coffee chat with Aaron Bertrand

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.

Making Full Use of Environment Variables for Flyway | The Tony and Tonie Show

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.