SQL Server - Administration
Technical articles and practical guides on Microsoft SQL Server administration
SQL Server articles
SQL Server articles: memory, installing SQL Server 2025, Intelligent Query Processing, regular expressions and SARGability.
Intelligent Query Processing (IQP)
How to use Intelligent Query Processing (IQP) in Microsoft SQL Server.
Regular expressions in SQL Server 2025
How to use the native regex functions of SQL Server 2025, from REGEXP_LIKE to REGEXP_SPLIT_TO_TABLE, with examples, SARGability and CPU cost.
Performance articles
Articles on SQL Server performance, starting with how to write WHERE clauses that let the optimizer use your indexes.
SQL Server memory consumption
Understanding SQL Server’s memory management behavior for system administrators accustomed to other platforms