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
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 Other 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
Ben Johnston in SQL Server When to enable memory-optimized tempdb metadata in SQL Server (and how to diagnose it) How to diagnose tempdb metadata latch contention in SQL Server - and decide whether enabling memory-optimized tempdb metadata is the... 08 January 2025 10 min read
Aaron Bertrand in T-SQL Programming Five SQL Server changes I’d love to see (DROP_EXISTING, ALTER TABLE, STRING_SPLIT fixes) Aaron Bertrand on five SQL Server behaviours he'd like Microsoft to fix: DROP_EXISTING needing an existing index, ALTER TABLE DROP... 01 January 2025 5 min read 65
Dennes Torres in Other 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
Edward Pollack in SQL Server Read and Write Parquet Files with SQL Server and Python Read and write Apache Parquet files from SQL Server using Python, pandas, and pyarrow - no native SQL Server Parquet... 19 November 2024 17 min read 21
Ben Johnston in SQL Server How to write an efficient SQL query: practical guidelines for faster, lighter queries Practical guidelines for writing efficient SQL queries: sargable predicates, set-based operations, index candidates, and how to read a query plan.… 19 October 2024 21 min read 3
