SQL Server: T-SQL Features

SQL Server: Windowing & Pagination

Use window functions

Create columnstore indexes

Implement temporal tables

T-SQL vs SQL?

Columnstore benefits?

Always On architecture?

SQL Server Documentation

T-SQL Guide

Columnstore Guide