Insights / Tutorials / SQL Server

SQL Server

Motor relacional Microsoft: índices, planos de execução e T-SQL avançado.

5 tutorials

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

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 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 keeps the history of execution plans and metrics for every query. Learn to use it to detect regressions and…

2 min 10 Jan 2025

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