T-SQL Trigonometric Functions in SQL Server

Introduction SQL Server includes several built-in mathematical functions that allow developers to perform complex calculations directly within queries. Among these are trigonometric functions such as SIN(), COS(), and TAN(), which are useful in scenarios involving engineering calculations, geographic data processing, simulations, and analytics. Although these functions are straightforward to use, developers occasionally encounter unexpected results […]

T-SQL in SQL Server 2025: JSON_ARRAYAGG

Learn how the JSON_ARRAYAGG() function works in SQL Server 2025.

Multiple Sequence Values

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