Scaling Your SQL Server Application

1h 5mIntermediate2018-11-12

Authors

Joey D'Antoni

Consultant and Thought Leader

Course details

Can your applications handle the load? In this one-hour class, you can learn about techniques to scale your SQL Server application as both your data volume and userbase grow. Instructor Joey D'Antoni introduces techniques you can use when designing a new application as well as techniques to fix an existing application—balancing security and performance concerns. Learn how to leverage built-in SQL Server features such as columnstore indexing, read-only routing, and portioning, and design a tenancy model that meets the demands of your application. Plus, find out how to use a caching tier and integrate Microsoft Azure for cloud-based storage that automatically scales as your needs grow.

Learning objectives
Designing for high-write and high-read workloads
Designing an archiving model
Leveraging SQL features such as portioning and compression
Building a tenancy model
Using Azure design patterns for scaling

Skills covered

SQL ServerDatabase AdministrationDatabase DevelopmentDatabase ManagementMicrosoftSoftware DevelopmentDeep Dive (X:Y)

Concepts

0. Introduction

01 - Scaling your data tier
02 - Tools and techniques
03 - Introduction to SQL Server 2017

1. Designing for Scale

04 - Understanding your workload pattern
05 - Designing for a high-write workload
06 - Designing for a high-read workload
07 - Building an archiving model

2. SQL Server Features That Help Your Application Scale

08 - In-memory OLTP overview
09 - Columnstore overview
10 - Always On availability groups - Read-only routing
11 - Partitioning and compression
12 - Indexing strategies

3. Building a Tenancy Model

13 - Tenancy models
14 - Multitenant app with database per tenant
15 - Multitenant app with sharded multitenant databases
16 - Database per tenant

4. Azure Design Patterns for Scale

17 - Caching layer
18 - Scale-out options in Azure
19 - Design anti-patterns

Conclusion

20 - Next steps