How to send Flyway logging and error output to JSON and consume it in PowerShell to produce ad-hoc database migrations reports, including any errors that occurred, the version of the database, runtimes for each migration script and more.
Apple buys a company every few weeks. The data integration for this must be a large effort.
This article digs deeper into the ways that Dynamic Data Masking works with different data types.
In this article, Joe Celko explains interpolation and covers a bit about the history and what we all did before computers.
Using metadata to drive software is very useful, which means that having clean data and lots of metadata can help create better software.
You need a fast, general-purpose way to save the results of a query or batch or procedure into any sort of worktable, such as a temporary table or a table variable or table valued parameter. A simple SELECT…INTO isn't versatile enough for these requirements, and the alternative ways to handcraft the list of columns are slow and error prone. Phil Factor shows how to create a 'table-build generator' that will do all this, and save you a lot of time, especially if you use a lot of working tables in your code.
Learn how to manage and troubleshoot Kerberos authentication for SQL Server using the Kerberos Configuration Manager.
One of the interesting things about modern software is how updates are handled.
A short look at temporal tables and how to deal with the system generated historical tables.
Learn how to configure and use SQL Server Management Studio to do run the same query against many different SQL Servers and consolidate the results.
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
You can find the slides and SQL scripts for my session “Spice up your...
Wa:083849450961 Jl. RC. Veteran. 9, dan No.9A, RT.9/RW.3, Bintaro, Kec. Pesanggrahan, Kota Jakarta Selatan,...
Wa:083849450961 Jl. Mangga Raya No.20, RT.4/RW.3, Duri Kepa, Kec. Kb. Jeruk, Kota Jakarta Barat,...
Comments posted to this topic are about the item Training the next generation
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers