Aaron Bertrand in Database Administration

SQL Server 2025 : Zstandard Backup Compression

Whether you are a bank or a hot dog stand, creating backups is a boring but essential part of managing...

Edward Pollack in Database Administration

TempDB Resource Governor Space Controls in SQL Server 2025

TempDB is a system database in SQL Server that manages temporary objects for all databases on a server. Because it...

Edward Pollack in SQL Server

SQL Server Developer Edition has for years provided a free data platform to test and develop applications in an environment...

Simple Talk Editor in SQL Server

On Monday, May 19, 2025, SQL Server 2025 was announced as finally going to be in public preview. Instead of...

Dennes Torres in T-SQL Programming

The new JSON field type and new functions in Azure SQL brings a new world of possibilities for JSON manipulation...

Rodrigo Ribeiro Gomes in T-SQL Programming

One of the cornerstones of AI is a concept called embeddings. Virtually every AI model, whether for text, video, or...