Identities and Sequences IV

Using OPENJSON

Identity Defaults

How to determine the last value used by a sequence in SQL Server

I’ve been a fan of sequences ever since they were added in SQL Server 2012. Prior to that, developers had a choice of IDENTITY columns or a roll-your-own table mechanism.

IDENTITY vs SEQUENCE in SQL Server – which should you use?

This guide explains how IDENTITY columns and SEQUENCE objects differ in SQL Server, and how you might decide which one is appropriate for a given design.

Identities and Sequences III

An Unusual Identity

T-SQL in SQL Server 2025: JSON_OBJECTAGG

Learn about the new JSON_OBJECTAGG function in SQL Server 2025.

Identities and Sequences II

Vectors in SQL Server 2025

Introduction SQL Server 2025 introduced new features, including vectors. The main purpose of vectors is to create a new semantic search with the help of AI. Modern AI models represent text as vectors (embeddings) that capture semantic meaning. Similar meanings produce vectors that are close to each other in this vector space, allowing AI systems to […]