Subqueries in MySQL

A subquery is a type of query that is embedded—or nested—into a data manipulation language (DML) statement. The subquery itself is typically a SELECT statement, although you can also use a TABLE statement or VALUES statement. Even so, the SELECT statement continues to be the most common choice for subqueries, and that’s the one I focus on in this article.

Useful Commands for Snowflake Transactions

In this article, we look at how to create transactions when using Snowflake along with several commands specific to working with transactions.

Analyze Azure Cosmos DB data with Synapse Serverless SQL Pools

In this tip, we guide you through the setup of Azure Synapse Link so you can query Azure Cosmos DB data with the Synapse Serverless.

Converting Data Across Time Zones: An In-Depth Primer

If only the entire world used UTC, wouldn’t life be so much easier? We can dream, can’t we? While some software applications can live in an ecosystem where all dates and times can be stored in a single time zone with no conversions needed, many cannot.

Cross-RDBMS Code Quality Reports in Flyway

This article demonstrates how to run basic cross-RDBMS code quality checks using SQL Fluff. We analyze the results in PowerShell to produce reports and analytics on the number or types of issues found.

Using sp_prepare and sp_execute to utilize prepared SQL statements

Learn about prepared statements in SQL Server, what they are, and how to use them along with the commands sp_prepare and sp_execute.

Express.js or Next.js for your Backend Project

In this article, I will introduce two JavaScript frameworks that can be used to build backend projects.

Setting up for Team-based Database Development using Flyway Desktop

This article provides a simple demonstration of how a small team of developers might set up a Flyway Desktop project to manage, automate, and control database development.

Should You Use SQL Server 2022’s STRING_SPLIT?

SQL Server 2022 improved the STRING_SPLIT function so that it can now return lists that are guaranteed to be in order. However, that’s the only thing they improved – there’s still a critical performance problem with it.

The Importance of a Good Data Model in Power BI Desktop