Quantifier predicates
Predicates in SQL are often complex and difficult to understand. In this article, Joe Celko explains the logic behind a few of the predicates: EXISTS, SOME, ANY and ALL.
2022-01-14
Additional Articles
Automating Flyway Undos
How to auto-generate first-cut undo scripts for every Flyway migration. For every new version of a database created by a Flyway versioned migration, we compare it to a 'source' directory containing object-level build scripts for the previous version. The SQL Compare engine does the rest, producing the associated undo script that will revert the database to the previous version, if required.
2022-01-12
Creating a SQL Server Agent Job to Run Python Scripts in a Virtual Environment
In this article we walk through how you can run Python scripts using SQL Server Agent, so you can setup scheduled jobs to run your Python code.
2022-01-12
Getting Started with Cloud-hosted Databases using Spawn
This article will get you started with Spawn, a hosted database cloning service running entirely on Amazons AWS.
2022-01-10
How to filter DAX for paginated reports
DAX is unlike SQL when filtering. In this article, Adam Aspin demonstrates how to filter DAX for paginated reports.
2022-01-10
Azure Policies and Management Groups
You can define policies for your Azure SQL Databases for security and meeting your organization’s standards. Management groups simplify policies over multiple subscriptions. Michael Wood explains Azure Policies and Management Groups.
2022-01-07
Using Flyway Teams with SQL Change Automation PowerShell Cmdlets
Use Flyway to run your database migrations, each time automatically creating a SQL Change Automation release object to provide object-level scripts and a build script for the new version, along with change reports and code analysis reports.
2022-01-07
Exploring Auto-fix in SQL Code Analysis
Phil Factor presents a useful but slightly flawed 'table report' script as an adventure playground for exploring SQL Code analysis issues. He demonstrates use of the auto-fix feature, to arrive at a pristine script free from wavy green underlines.
2022-01-05
How to return multiple sequence numbers with sp_sequence_get_range
Developers can work with multiple range values at once using sp_sequence_get_range. Greg Larsen explains how to return multiple sequence numbers with sp_sequence_get_range.
2022-01-05
Adding Users to Azure SQL Databases
Learn about the options to add users to Azure SQL Databases including SQL authentication logins, contained SQL users, contained Azure Active Directory users, mapped logins to users - including code examples you can copy and use immediately.
2022-01-03
Blogs
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Cleaning Up My Blog's SEO and AEO with Claude in GitHub Copilot
I’ve been running this blog on Hugo for a long time, and like most...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers