Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Scaling Your SQL Server Application

via LinkedIn Learning

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.

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.

Syllabus

Introduction
  • Scaling your data tier
  • Tools and techniques
  • Introduction to SQL Server 2017
1. Designing for Scale
  • Understanding your workload pattern
  • Designing for a high-write workload
  • Designing for a high-read workload
  • Building an archiving model
2. SQL Server Features That Help Your Application Scale
  • In-memory OLTP overview
  • Columnstore overview
  • Always On availability groups: Read-only routing
  • Partitioning and compression
  • Indexing strategies
3. Building a Tenancy Model
  • Tenancy models
  • Multitenant app with database per tenant
  • Multitenant app with sharded multitenant databases
  • Database per tenant
4. Azure Design Patterns for Scale
  • Caching layer
  • Scale-out options in Azure
  • Design anti-patterns
Conclusion
  • Next steps

Taught by

Joey D'Antoni

Related Courses

Reviews

Start your review of Scaling Your SQL Server Application

Never Stop Learning!

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free