Since I wrote about the Snowflake query tags generated by Power BI earlier this year, one important piece of functionality has been added: an OperationID that allows you to link a SQL query in ...

Following on from my post two weeks ago about how to get the details of Power BI operations seen in the Capacity Metrics App using the OperationId column on the Timepoint Detail page, I thought it was ...

This C++ program allows you to send SQL queries as strings or entire .sql files containing several queries to any Sqlite3 or HDF5 databases. It performs its tasks without using any dot command, so it ...

At Microsoft Build 2025, we announced the public preview of SQL Server 2025. Built on a foundation of best-in-class security, performance, and availability, SQL Server 2025 empowers customers to ...

This package provides utilities for building SQL query strings in a safe, composable, and parameterized manner. It is designed to prevent SQL injection vulnerabilities and enhance code readability ...

DBeaver is a free, open-source, cross-platform SQL client and database administration tool. It is designed to support a wide variety of SQL and NoSQL databases, including MySQL and PostgreSQL. Its key ...

A common SQL habit is to use SELECT * on a query, because it’s tedious to list all the columns you need. Plus, sometimes those columns may change over time, so why not just do things the easy way? But ...

OpenAI’s AI LLM (Large Language Model) can handle programming languages as well as human languages, that’s well established. SQL developers rejoice – SQL code is included! Therefore, it follows that ...