Learn T-SQL Querying

Troubleshoot query performance issues, identify anti-patterns in your code, and write efficient T-SQL queries with this guide for T-SQL developers

• Printed book:
  • US
• Kindle book:
  • US

How to Query JSON Data Quickly in SQL Server, Part 1: Pre-2025

Before SQL Server 2025, if you want to store JSON data in Microsoft SQL Server or Azure SQL DB, and you want fast queries, the easiest way is to:

SQL Declare Variable Code Examples

This tutorial will discuss using variables with SQL DECLARE along with various examples.

The Version Store Won’t Clear If ANY Database Has Open Transactions.

Short story: what the title says.

JSON Data Extract from SQL Server 2025

JSON is a complex data type used for representing objects with various properties. With JSON you follow the key-value pattern where the key is a string and the value can be of different data types. What are some common ways to work with JSON in SQL Server?

How to Build an AI-Powered T-SQL Assistant with Python & SQL Server

If you’re a SQL Server DBA or developer looking to harness AI for your everyday scripting workflows, this article will walk you through building an AI-powered T-SQL assistant using Python and SQL Server.

SQL ConstantCare® Population Report: Fall 2025

In this quarter’s update of our SQL ConstantCare® population report, showing how quickly (or slowly) folks adopt new versions of SQL Server, the data is very similar to last quarter

IoT Meets OLTP: How to Handle Backfilling Challenges in Real-Time Systems

This is the true story of a 64-core SQL Server brought down by poor assumptions about its data. A clustered index designed for neat, sequential IoT inserts was overwhelmed when the real readings arrived late, out of order, and in bulk. The same risk lurks in any high-write system with unpredictable insert patterns. This article shows what can go wrong and how to avoid it.

JSON_CONTAINS Function in SQL Server 2025

I have data coming into my SQL Server database as JSON. Before I start parsing it which is quite intensive, I need to check if some values are present in the JSON. Is there a function I can use to do this? Let’s see what the new JSON_CONTAINS function in SQL Server 2025 can do.

Unlocking the Power of FULL OUTER JOIN in SQL: Performance, Use Cases & Examples

Discover how the FULL OUTER JOIN in SQL can simplify queries, improve performance, and solve real-world data problems