How to handle NULL values in SQL Server: ISNULL and COALESCE
Learn to handle and replace NULL values in SQL Server with ISNULL and COALESCE. Practical examples, the differences bet…
4 min
14 Jul 2026
How to concatenate rows with STRING_AGG in SQL Server
Learn how to merge values from multiple rows into one string in SQL Server using STRING_AGG and GROUP BY. Practical exa…
4 min
10 Jul 2026
How to Use PIVOT in SQL Server: Turn Rows into Columns
Learn how to use PIVOT in SQL Server to turn rows into columns and build summary tables. A hands-on, step-by-step examp…
4 min
08 Jul 2026
How to create a stored procedure with parameters in SQL Server
Learn how to create a stored procedure with parameters in SQL Server step by step: input parameters, default values and…
5 min
06 Jul 2026
How to Paginate Results in SQL Server with OFFSET FETCH
Learn to paginate results in SQL Server with OFFSET FETCH: a step-by-step example, the mandatory ORDER BY, and the most…
4 min
05 Jul 2026
Always Encrypted in SQL Server: protect sensitive data end-to-end
Always Encrypted ensures sensitive data such as tax IDs and card numbers is never visible in plaintext on the server — …
2 min
25 Mar 2026
Advanced T-SQL: CTEs, window functions and APPLY for complex analysis
Recursive CTEs, window functions and the APPLY operator are the most powerful T-SQL tools for complex analysis. Master …
2 min
30 Oct 2025
Temporal Tables in SQL Server: automatic history without triggers
Temporal Tables add automatic history to any table with zero extra code. Query the state of data at any point in the pa…
2 min
06 Jun 2025
Query Store: diagnose and fix performance regressions in SQL Server
Query Store keeps the history of execution plans and metrics for every query. Learn to use it to detect regressions and…
2 min
10 Jan 2025
Indexes in SQL Server: columnstore vs rowstore for analytics and OLTP
Choosing the right index type is the most impactful decision in SQL Server. Learn when to use clustered columnstore, ro…
2 min
16 Aug 2024
How to create a nonclustered index in SQL Server
Learn how to create a nonclustered index in SQL Server to speed up queries, with a T-SQL example and how to check it is…
2 min
12 Mar 2024