Put simply, SQL works, and no replacement option has measured up in the same way. As an example, SQL was the first programming language to return multiple rows per single request.

A public preview of SQL Server 2025 adds new vector capabilities already found in rival databases, along with JSON support and change event streaming.

Tony Patton discusses the merits of stored procedures versus placing SQL directly in the code. Find out which one is best for your particular situation.