Vendors/3rd-party Products

External Article

Taming Database Documentation with Flyway and MySQL

  • Article

Database object documentation is essential for explaining to busy developers, and the wider business, the purpose of each object and how to use it. The solution presented in this article consists of a SQL script to allow developers to add comments to MySQL database objects, without affecting the database version, and a simple way to generate a documentation report, in JSON. The SQL script will execute automatically as a callback, during any Flyway Teams migration run, and the report will allow the team to spot any gaps quickly.

2022-07-18

External Article

Cross-RDBMS Version Checks in Flyway

  • Article

How does one check that a database is definitively at the version that Flyway says it is? Or that a test teardown procedure leaves no trace in the database? Or verify that an undo script returns a database's metadata to that state it should be in for the version to which you're rolling back? This article shows how to do high-level version checks, by comparing JSON models.

2022-07-13

Blogs

Claude Code Helps Analyze Test Data Manager Log Files

By

I had a customer ask about analyzing their Test Data Manager (TDM) usage to...

PowerPoint to HTML with Claude AI

By

I had an idea for an animated view of a sales tool, and started...

Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!

By

Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...

Read the latest Blogs

Forums

Huge frustration - Database watcher with two elastic pools

By bjorn.c.w

Think there's a reason why this is still in preview, but have someone manage...

SQL Server 2025 Query Performance Tuning: Troubleshoot and Optimize Query Performance

By Site Owners

Comments posted to this topic are about the item SQL Server 2025 Query Performance...

Is it uncommon for Dev's to have a data model of the source data

By Coffee_&_SQL

This is a generic question. To the moderators, I wasn't sure where to place...

Visit the forum

Question of the Day

Creating JSON I

On SQL Server 2025, what happens when I run this code:

SELECT JSON_OBJECTAGG( 'City':'Denver')
GO

See possible answers