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
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
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... 09 June 2025 14 min read
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
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
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
Louis Davidson in T-SQL Programming Exploring the SQL Server CHOOSE Function I preface a lot of what I write with whether or not it is for a “practical” use. One of... 21 April 2025 39 min read
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
Rodrigo Ribeiro Gomes in T-SQL Programming AI in SQL Server 2025: Embeddings One of the cornerstones of AI is a concept called embeddings. Virtually every AI model, whether for text, video, or... 18 February 2025 48 min read
Ben Johnston in Blogs 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
Edward Pollack in T-SQL Programming Exploring Scalar Solutions to Complex Data Math There are many functions and tools available to database professionals that can solve data math challenges, regardless of complexity. A... 12 February 2025 17 min read
Louis Davidson in T-SQL Programming SQL Server BIT_COUNT and an Alternative I was editing an article the other day that uses the BIT_COUNT function that was added to SQL Server 2022.... 08 February 2025 11 min read
Dennes Torres in Blogs Azure SQL Serverless: Discover What’s new and Increase Your Savings Before jumping into the news and code, let’s start from the beginning: Why does someone use Azure SQL Serverless? The... 22 January 2025 3 min read
Edward Pollack in SQL Server Customizing the Export and import of Parquet Files in SQL Server Previously, we introduced and discussed the Parquet file format and SQL Server and why it is an ideal format for... 10 January 2025 10 min read
Ben Johnston in Blogs A Use Case for Memory-Optimized Tempdb Metadata I recently had an interesting production SQL Server issue that turned out to be very easy to fix. The fix... 08 January 2025 10 min read
Aaron Bertrand in T-SQL Programming Five changes to SQL Server I’d love to see I’ve had lots of wish lists over the years, from Ladybug to Connect to UserVoice, and very few of my... 01 January 2025 5 min read
Dennes Torres in Blogs T-SQL Tuesday #181: Query Store and its evolution Query Store. This is my choice in relation to “What feature release made you say WOW!”, the subject of this... 09 December 2024 4 min read
Edward Pollack in SQL Server Reading and Writing Parquet Files in SQL Server When analytic data is stored directly in SQL Server, a clustered columnstore index is an ideal place for that data... 19 November 2024 16 min read