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 1
Edward Pollack in Database Administration TempDB Resource Governor Space Controls in SQL Server 2025 This article was updated in September 2025 following the SQL Server 2025 (17.x) Preview release. TempDB is a system database... 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 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 321
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 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 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 11
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 AI in SQL Server 2025: Embeddings Discover how SQL Server 2025 introduces embeddings and vector support in T‑SQL. Learn to store, compare, and query AI-generated vectors... 18 February 2025 48 min read 1252
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 11
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 3
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 72
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 21
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 21
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 63
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 1
