It is the start of season 2, and we are kicking it off with Scott Stauffer talking about coffee, video games, the glorious innovation of technology over our years, guide dogs, AI, and so much more. Without giving away too much, in the show there is a discussion about guide dogs.

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.

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.

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!

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.

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.

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.

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.

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

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.