What Exactly Is a CTE in T-SQL? A Comprehensive Guide with 7 Examples

Learn how to use CTEs through the use of a number of examples.

Integrating Python with MongoDB

This article gives an overview of MongoDB and outlines steps to integrate python with MongoDB

Using SQLite with Flutter

Learn how you can build a basic Flutter application that interacts with a SQLite database.

Double Standby

Gentlest of Reminders, Don't Stop Learning

I was on the road for just over two weeks. I was able to travel around to a few places and present some sessions. But, better than that, thanks to SQL Konferenz, I was able to go to a couple of sessions and learn some stuff. I'm lucky/cursed in my position at Redgate. We have […]

Opening Multiple Symmetric Keys

The Upgraded Stored Procedure

Using the OPENJSON Type

OPENJSON and Versions

The Impact of Small Changes

A year ago, I started a monthly blogging event for the PostgreSQL community, inspired by T-SQL Tuesdays. I decided to call it PGSQL Phriday. (Time will tell if my insistence on trying to use a literation was a good idea or not.) Like the event for the SQL Server community, we ask someone to be […]