Aaron Bertrand in Featured Common SQL Server Problems: Network Related or Instance Specific Error Occurred This is the first in a series of articles meant to provide practical solutions to common issues. In this post,... 07 July 2025 6 min read
Edward Pollack in SQL Server Columnstore Index Improvements in SQL Server 2025 Learn about the improvements to columnstore indexes in SQL Server 2025, including detailed demonstrations for each of these new changes.… 30 June 2025 11 min read 51
Joe Celko in Theory and design State Transition Constraints in SQL: Temporal Rules & Validation Implement state transition constraints in SQL Server using FOREIGN KEY references, temporal attributes, CTE path validation, and stored procedure wrappers.... 24 June 2025 14 min read 32
Matt Gantz in Database Administration Replacing a Column in a Large Active SQL Server Table In a previous post I showed how to use a batching strategy to remove large amounts of data from a... 19 June 2025 11 min read 11
Aaron Bertrand in SQL Server SQL Server 2025 ZSTD Backup Compression Guide SQL Server 2025 adds Zstandard (ZSTD) backup compression with LOW, MEDIUM, and HIGH levels. Compare ZSTD vs MS_XPRESS performance, syntax,... 11 June 2025 15 min read 1
Edward Pollack in SQL Server TempDB Resource Governor Space Controls in SQL Server 2025: A Complete Guide SQL Server 2025 introduces the ability to use Resource Governor to help manage TempDB resources automatically. This article dives into... 09 June 2025 15 min read 21
Louis Davidson in T-SQL Programming DISTINCT and UNION: What happens when you use them together? When I was perusing my LinkedIn feed the other day, I came across this thread about using SELECT *. In... 26 May 2025 11 min read 4
Edward Pollack in SQL Server SQL Server Developer Standard Edition: A Gift to Developers! SQL Server Developer Edition has for years provided a free data platform to test and develop applications in an environment... 21 May 2025 9 min read 1
Simple Talk Editor in SQL Server SQL Server 2025 is in Public Preview! On Monday, May 19, 2025, SQL Server 2025 was announced as finally going to be in public preview. Instead of... 21 May 2025 3 min read
Laerte Junior in Sysadmin SQL Server 2022 on Ubuntu 24.04 step by step Microsoft does not yet support this edition of Ubuntu, but there are some workarounds to make it work. This should... 20 May 2025 5 min read 211
Ben Johnston in SQL Server A complete guide to Azure SQL Managed Instance server and database configuration options A tested reference of sp_configure, ALTER DATABASE, and tempdb options that aren't supported in Azure SQL Managed Instance -plus the... 13 May 2025 10 min read
Rodrigo Ribeiro Gomes in Database Administration Recover SQL Server Data Without Full Backup Recover deleted or updated SQL Server data without a full backup. Step-by-step guide using transaction log analysis, DBCC PAGE, and... 13 May 2025 33 min read 321
Dennes Torres in T-SQL Programming Azure SQL Native JSON Data Type: Query Techniques Explore Azure SQL's native JSON data type with CHECK constraints, JSON_ARRAYAGG, JSON_OBJECTAGG, and JSON_OBJECT functions. These features are coming to... 07 May 2025 16 min read 2
Matt Gantz in T-SQL Programming Purging Data from a Large Table in SQL Server Purging data from a table is a common database maintenance task to prevent it from growing too large or to... 01 May 2025 8 min read 421
Louis Davidson in T-SQL Programming SQL Server CHOOSE Function: Syntax, Examples & Limits Learn how to use the SQL Server CHOOSE function to select values by position. Covers syntax, practical ETL examples, random... 21 April 2025 40 min read 11
Ben Johnston in Databases 5 key problems from a SQL Server to Azure SQL Managed Instance migration (and how to avoid them) Planning an Azure SQL Managed Instance migration? Here are five surprises a real transactional SQL Server move uncovered - and... 31 March 2025 10 min read 2
Dennes Torres in Microsoft Fabric Fabric: Query a SQL Endpoint from a Notebook Let’s analyse why we would like to query an SQL Endpoint. Once we understand why, we can dig into how... 26 March 2025 5 min read 1
Louis Davidson in T-SQL Programming Crazy number of Parameters… and a challenge The other day, my lovable coworker and frequent Simple Talk writer: Grant Fritchey, sent this post on X: So I... 24 February 2025 35 min read 1
Rodrigo Ribeiro Gomes in T-SQL Programming SQL Server 2025 Embeddings: AI Vector Search Explained Understand embeddings and vector search in SQL Server 2025. Learn how to convert text to numerical vectors, calculate similarity with... 18 February 2025 48 min read 1252
Ben Johnston in SQL Server SQL Server 2022 CU Updates and Error Code 0x851A0043 I’ve been working in the Azure space for the last few years and less with full server installations. Azure leaves... 18 February 2025 5 min read
