A short introduction to how deadlocks work and how you can affect their behavior inside your system.

Net Present Value and Internal Rate of Return in SQL Server

by Additional Articles

SimpleTalk

T-SQL

Many organizations store cash-flow data inside SQL Server and decision-makers often need metrics like Net Present Value (NPV) and Internal Rate of Return (IRR) to evaluate those cash flows. Is it possible to calculate NPV and IIR values in SQL Server without the use of external tools?

Half of All Engineers

by Steve Jones

SQLServerCentral

Will AI replace half of all engineers?

T-SQL Trigonometric Functions in SQL Server

by Imran2629

SQLServerCentral

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 […]

How Multi-Column Statistics Work

by Additional Articles

Brent Ozar Blog

The short answer: in the real world, only the first column works. When SQL Server needs data about the second column, it builds its own stats on that column instead (assuming they don’t already exist), and uses those two statistics together – but they’re not really correlated.

Spring Connections and Learning at PASS On Tour

by Steve Jones

SQLServerCentral

The spring PASS On Tour event is coming to Chicago in a few weeks.

T-SQL in SQL Server 2025: JSON_ARRAYAGG

by Steve Jones

SQLServerCentral

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

Microsoft On-Premises Data Gateway Administration

by Additional Articles

MSSQLTips.com

Azure

As a Microsoft Fabric Administrator, you have the responsibility to manage all the Microsoft Enterprise gateways installed and deployed across your entire data estate.