Creating a JSON Document II

Every Database Has Problems

The magic way to get better performance from your system is to write better code from the start.

Identities and Sequences V

Creating a JSON Document I

Creating a Simple and Flexible Random Password Generator in SQL Server

Generating temporary passwords is a common requirement in many applications. Users may need to reset a forgotten password, new accounts may require an initial password, or developers may generate test credentials. While password generation is often implemented in application code, doing it directly in SQL Server provides clear advantages. It centralizes the logic, ensures consistency […]

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.