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
Simple Talk Editor PASS Keynote – Day 1 – Microsoft In this blog we will be covering all the news and announcements from the 2024 PASS Data Summit Keynote as... 06 November 2024 10 min read
Edward Pollack in T-SQL Programming Effective Strategies for Storing and Parsing JSON in SQL Server Like XML, JSON is an open standard storage format for data, metadata, parameters, or other unstructured or semi-structured data. Because... 23 August 2024 26 min read
Aaron Bertrand in SQL Server Days of the Week, Bitwise Edition I recently had to help support synchronization and distribution of workloads between multiple servers. Some of this work involves Task... 02 August 2024 7 min read
