Fabiano Amorim in SQL Server

How to close SQL Server operational blind spots (linked servers, DMVs, and KILL command security risks & fixes)

Learn how attackers exploit SQL Server linked servers, traces, DMVs, and the KILL command - plus the monitoring queries and...

25 September 2026 14 min read

Edward Pollack in SQL Server

SQL Server login failures: how to monitor, report, and alert on them (complete guide)

Learn how to detect and report SQL Server login failures using T-SQL and xp_readerrorlog. Includes ready-to-use scripts for filtering, aggregating,...

02 September 2026 17 min read

Louis Davidson in SQL Server

9 things I wish SQL Server had (and why they’d matter)

A T-SQL veteran's wish list: 9 missing SQL Server features that would simplify auditing, data validation, graph queries, and error...

24 August 2026 21 min read

Greg Low in SQL Server

JSON indexing in SQL Server 2025: how it works and current limitations

SQL Server 2025 introduces native JSON indexing via CREATE JSON INDEX. Learn how it works, when to use it, and...

19 August 2026 8 min read

Greg Low in SQL Server

How to avoid nested REPLACE functions with TRANSLATE in SQL Server

Learn how SQL Server's TRANSLATE function replaces messy nested REPLACE statements. Simplify multi-character string replacements in T-SQL with one clean...

14 August 2026 4 min read

Greg Low in SQL Server

What’s missing in T-SQL? My wish list of features that developers actually need in SQL Server

A veteran SQL Server expert's wish list for T-SQL: true constants, enumerations, extensibility, better naming consistency, and more. See what's...

08 July 2026 12 min read

Edward Pollack in SQL Server

5 T-SQL features that should already exist (2026 SQL Server wish list)

2026 T-SQL wish list covering native Parquet imports, arrays, OVERLAPS, simpler licensing, and cloud storage — features SQL Server still...

26 June 2026 14 min read

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

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

Ben Johnston in SQL Server

SQL Server Regular Expression Performance and Guidelines

SQL Server 2025 introduces regular expression (regex) functions to the TSQL language. You could do this in previous versions with...

02 January 2026 15 min read

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

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

Lukas Vileikis in MySQL

MySQL PRIMARY KEY Indexes: The Clustered Index

How PRIMARY KEY indexes work in MySQL and InnoDB: the rules, why the primary key is the clustered index, strings...

15 August 2025 15 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

An image showing columns increasing in size from 10% to 100%.

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

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

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

An image showing the words 'regular expression' against a pictorial background.

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

A stock image showing someone working on a laptop

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

Louis Davidson in T-SQL Programming

DISTINCT and UNION: What happens when you use them together?

UNION already removes duplicates, so what does adding DISTINCT do? Three tests at growing row counts, the execution plans, and...

26 May 2025 12 min read