External Article

Searching a Flyway Database

As a database gets larger, and development more complex, so it becomes increasingly necessary to be able to search for strings in the source files and the database itself. Maybe you need to find when a table first got created, when a foreign key was added, or to find out which tables lack documentation. I'll show you how to answer these sorts of questions by running simple 'wildcard' searches on your Flyway migration files, or source files, as well as more targeted searches on certain parts of your database model.

Blogs

Slides from SQL Saturday Los Angeles 2022

By

If you attended my talk at SQL Saturday Los Angeles 2022, then you can...

Creating a HEAD utility for Windows 10

By

One of the things I did often in my first career job was create...

Distributed Replay: The Little Engine That Almost Could

By

Honestly, sincerely, no kidding, I love Distributed Replay. Yes, I get it. Proof positive...

Read the latest Blogs

Forums

Substitute 0 and 1 values in 1 column

By pedroccamara

Hello everyone, Hi have this column named Sex and it only has value 0...

Finding difference in two databases/tables

By yrstruly

I have compared two tables with the same data in two different databases(aslo the...

Help me understand SSIS Environments

By planetmatt

Ok, so I understand what they are, they're collections of parameter assignments that you...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers