Overview
-
Want high-performance applications? Scale your data tier. Learn how to architect SQL Server applications that tolerate heavy workloads and large numbers of users.
Syllabus
-
Introduction
- Scaling your data tier
- Tools and techniques
- Introduction to SQL Server 2017
- Understanding your workload pattern
- Designing for a high-write workload
- Designing for a high-read workload
- Building an archiving model
- In-memory OLTP overview
- Columnstore overview
- Always On availability groups: Read-only routing
- Partitioning and compression
- Indexing strategies
- Tenancy models
- Multitenant app with database per tenant
- Multitenant app with sharded multitenant databases
- Database per tenant
- Caching layer
- Scale-out options in Azure
- Design anti-patterns
- Next steps
