Scaling Your SQL Server Application

Focused View

Joey D'Antoni

1:04:58

104 View

01 - Introduction

01 - Scaling your data tier.mp4

00:39

02 - Tools and techniques.mp4

00:40

03 - Introduction to SQL Server 2017.mp4

01:39

02 - 1. Designing for Scale

01 - Understanding your workload pattern.mp4

03:51

02 - Designing for a high-write workload.mp4

04:06

03 - Designing for a high-read workload.mp4

04:17

04 - Building an archiving model.mp4

03:56

03 - 2. SQL Server Features That Help Your Application Scale

01 - In-memory OLTP overview.mp4

04:39

02 - Columnstore overview.mp4

06:00

03 - Always On availability groups Read-only routing.mp4

05:39

04 - Partitioning and compression.mp4

03:45

05 - Indexing strategies.mp4

05:29

04 - 3. Building a Tenancy Model

01 - Tenancy models.mp4

02:14

02 - Multitenant app with database per tenant.mp4

01:41

03 - Multitenant app with sharded multitenant databases.mp4

02:49

04 - Database per tenant.mp4

03:20

05 - 4. Azure Design Patterns for Scale

01 - Caching layer.mp4

02:47

02 - Scale-out options in Azure.mp4

03:15

03 - Design anti-patterns.mp4

03:33

06 - Conclusion

01 - Next steps.mp4

00:39

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

SQL Server

Microsoft SQL

Joey D'Antoni

Instructor's Courses

Thought leader with 20 years of IT experience, working with a wide variety of data platforms including Microsoft SQL Server, Oracle, Hadoop and other data platforms. Extensive experience in cloud design and architecture, specifically focused on hybrid cloud models. Strong experience in clustering and storage. Frequent speaker at major IT conferences such as Microsoft Ignite, PASS Summit, NoSQL Now. Microsoft Data Platform MVP, VMWare vExpert. Microsoft certified Azure Architect. Writer at 1105 Media, RedmondMag.com. Specialties: Database, Infrastructure, Storage, Hybrid Cloud, High Availability Disaster Recovery

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.