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
Joe Celko in Theory and design State Transition Constraints About two decades ago, I introduced the concept of transition constraints to show Data Validation in a database is a... 24 June 2025 14 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
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... 11 June 2025 15 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
Ben Johnston in Blogs Managed Instance Gotchas – Configuration Items In my last post I described issues that might stop your migration to a SQL Server Managed Instance (SQL MI).... 13 May 2025 10 min read
Rodrigo Ribeiro Gomes in Database Administration Recovering data in SQL Server without full backup In more than 10 years of experience, I have dealt with cases where someone has performed incorrect operations on a... 13 May 2025 32 min read
Dennes Torres in T-SQL Programming Techniques to query Azure SQL’s new JSON Datatype The new JSON field type and new functions in Azure SQL brings a new world of possibilities for JSON manipulation... 07 May 2025 15 min read
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
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
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
Louis Davidson in SQL Server Dark Mode in SSMS 21 and overall first impressions Let me cut to the chase. If you are like me, you may have been searching for: How to turn... 02 February 2025 4 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
