Lukas Vileikis in Databases Why COALESCE might be the most useful SQL function you’re not using right Learn how the SQL COALESCE function works, with practical examples for handling NULL values, setting defaults, and writing cleaner, more... 07 May 2026 7 min read 21
Greg Low in SQL Server Can SQL Server 2025’s REGEXP_SPLIT_TO_TABLE fix STRING_SPLIT in T-SQL? Learn how to split strings efficiently in T-SQL using STRING_SPLIT and the REGEXP_SPLIT_TO_TABLE function in SQL Server 2025. Discover limitations,... 15 April 2026 5 min read 1
Lee Asher in Databases 5 Strategies to Refactor SQL Code Struggling with messy SQL queries? Discover 5 smart refactoring strategies to clean up your code, boost performance, and simplify maintenance.… 12 November 2025 16 min read 73
Rodrigo Ribeiro Gomes in SQL Server How to Build an AI-Powered T-SQL Assistant with Python & SQL Server Discover how to build an AI-powered T-SQL assistant using Python, embeddings, vector search and SQL Server’s new AI features. Step-by-step... 22 October 2025 58 min read 31
Lukas Vileikis in MySQL MySQL Index Overviews: PRIMARY KEY Indexes Learn how to use PRIMARY KEY indexes in MySQL - a type of B-tree index designed to help a database... 15 August 2025 16 min read
Joe Celko in SQL Server Mastering SQL VIEWs: Syntax, Use Cases, and Best Practices Learn how to use SQL VIEWs effectively with practical examples, syntax breakdowns, and expert tips for recursive, union, and updatable... 05 August 2025 10 min read 11
Edward Pollack in Featured How to Increase SQL Server Column Width Without IO (Input/Output) Overhead One of the most hassle-prone changes that can be made in a SQL Server database is to widen an existing... 28 July 2025 14 min read 211
Matt Gantz in SQL Server Measure Replication Latency in SQL Server AlwaysOn AGs Learn how to measure synchronous replication latency in SQL Server AlwaysOn Availability Groups using performance counters. Track HADR_SYNC_COMMIT waits and... 25 July 2025 9 min read 211
Edward Pollack in Featured SQL Server 2025 PRODUCT() Function: Multiply Values in T-SQL Learn the new PRODUCT() aggregate function in SQL Server 2025 - multiply values across rows like SUM() adds them. Covers... 21 July 2025 9 min read 2
Edward Pollack in Featured Regex in SQL Server 2025: All Seven REGEXP Functions Explained SQL Server 2025 adds native regex support with seven new REGEXP functions: REGEXP_LIKE, REGEXP_COUNT, REGEXP_INSTR, REGEXP_REPLACE, REGEXP_SUBSTR, REGEXP_MATCHES, and REGEXP_SPLIT_TO_TABLE.... 14 July 2025 18 min read
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 51
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
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
Ben Johnston in Blogs Writing an Efficient Query SQL is easy to start writing. The basic syntax to start returning data is very simple. This low threshold for... 19 October 2024 20 min read 3
SQL Server Ben Johnston in SQL Server Unmasking SQL Server Dynamic Data Masking, Part 5: Mitigations and Summary This is the fifth and final part of this series on SQL Server Dynamic Data Masking. In this article, I’ll... 30 July 2023 12 min read
SQL Server Ben Johnston in SQL Server Unmasking SQL Server Dynamic Data Masking, Part 4, Unmasking Formatted and Unformatted Text Continuing from the previous entry in this series on security concerns with using Dynamic Data Masking, in this article I... 27 June 2023 30 min read
T-SQL Programming Greg Larsen in T-SQL Programming SQL Subquery in SELECT: Examples & Syntax Guide Learn how to use subqueries in SQL SELECT statements with practical examples. Covers basic subqueries, correlated subqueries, EXISTS, IN, and... 26 June 2023 15 min read
T-SQL Programming Greg Larsen in T-SQL Programming Paging Data in T-SQL Sometimes when working with very large sets of data, you may not want to return all of the data at... 20 March 2023 10 min read
T-SQL Programming Greg Larsen in T-SQL Programming Summarizing data in SQL Server using GROUP BY and HAVING clauses You can summarize data to get counts, averages, sums, and more using GROUP BY in T-SQL queries. Greg Larsen shows... 27 May 2022 11 min read
T-SQL Programming Phil Factor in T-SQL Programming SQL Server Temp Tables: Types, Syntax & Best Practices Complete guide to SQL Server temporary tables - local (#), global (##), table variables, and table-valued parameters. Includes syntax, performance... 01 August 2020 23 min read
