SQL Server training

This one-stop SQL page is a complete tutorial for both beginners and advanced SQL users to help them learn and enhance their SQL Server skills.

SQL Server Basics

This is an index of links that organize and catalog basic topics in SQL Server like a particular operation or data type. The topic categories include DDL and DML operations, datatypes and expressions. Learn more

Series articles

The following are a list of series topics. Each series has multiple articles that cover a specific SQL Server related topic, all written by the same author. Several of these series have 10 or more articles.

Accelerated Database Recovery (ADR) (2)
Azure Cosmos DB (4)
Azure costs (8)
Azure SQL Database (5)
CTE (Common Table Expressions) (4)
Database checkpoints (2)
dbatools (11)
DevSecOps (2)
Linux commands for SQL DBAs (2)
Working with PowerShell’s Invoke-SqlCmd (2)
PowerBI Desktop (13)
PowerShell for Azure Cosmos DB (5)
Python and SQL Server (8)
Columnstore Indexes (3)
Linux (6)
PolyBase (5)
SQL Server Audit (11)
Backup and restore (23)
SQL command line (sqlcmd) (2)
Constraints (2)
Execution Plans (11)
Indexes (12)
In-Memory monitoring (2)
SQL Server monitoring tools (3)
SQL Server PowerShell tools (3)
SQL Server Replication (14)
SQL Server Merge Replication (7)
SET statements (2)
SQL Server DevOps tools (6)
Transaction log (11)
SQL unit testing (8)
SSRS subscriptions (2)
SSIS features face-to-face (10)

Latest posts by SQLShack (see all)