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 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
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
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
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 22
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 111
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
Ben Johnston in Databases How to choose the right data types and column options in databases How to pick the right SQL Server data type for every column - covering size, performance, NULLs, and the code... 31 August 2024 28 min read 11
Edward Pollack in T-SQL Programming Store & Parse JSON in SQL Server: Strategy Guide Learn how to store, validate, index, and compress JSON in SQL Server. Covers ISJSON, OPENJSON, JSON_VALUE, computed columns, the Azure... 23 August 2024 27 min read 311
Ben Johnston in SQL Server How to master a database configuration audit in SQL Server: a complete guide A SQL Server database configuration audit is where most issues are found — from compatibility levels and file locations, to... 20 August 2024 16 min read
3
1
1
