Can you 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.
Topics include:
• 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
For More Udemy Free Courses >>> http://www.freetutorials.eu
For more Lynda and other Courses >>> https://www.freecoursesonline.me/
Our Forum for discussion >>> https://discuss.freetutorials.eu/
VISITOR COMMENTS (0 )
FILE LIST
Filename
Size
0.Introduction/01.Scaling your data tier.en.srt
1.4 KB
0.Introduction/01.Scaling your data tier.mp4
3.2 MB
0.Introduction/02.Tools and techniques.en.srt
1.4 KB
0.Introduction/02.Tools and techniques.mp4
1 MB
0.Introduction/03.Introduction to SQL Server 2017.en.srt
3 KB
0.Introduction/03.Introduction to SQL Server 2017.mp4
2.7 MB
1.1. Designing for Scale/04.Understanding your workload pattern.en.srt
7.3 KB
1.1. Designing for Scale/04.Understanding your workload pattern.mp4
5.7 MB
1.1. Designing for Scale/05.Designing for a high-write workload.en.srt
7.6 KB
1.1. Designing for Scale/05.Designing for a high-write workload.mp4
6.5 MB
1.1. Designing for Scale/06.Designing for a high-read workload.en.srt
8.4 KB
1.1. Designing for Scale/06.Designing for a high-read workload.mp4
6.5 MB
1.1. Designing for Scale/07.Building an archiving model.en.srt
6.9 KB
1.1. Designing for Scale/07.Building an archiving model.mp4
6.2 MB
2.2. SQL Server Features That Help Your Application Scale/08.In-memory OLTP overview.en.srt
7.6 KB
2.2. SQL Server Features That Help Your Application Scale/08.In-memory OLTP overview.mp4
14 MB
2.2. SQL Server Features That Help Your Application Scale/09.Columnstore overview.en.srt
10.4 KB
2.2. SQL Server Features That Help Your Application Scale/09.Columnstore overview.mp4
15.4 MB
2.2. SQL Server Features That Help Your Application Scale/10.Always On availability groups - Read-only routing.en.srt
9.7 KB
2.2. SQL Server Features That Help Your Application Scale/10.Always On availability groups - Read-only routing.mp4
10.5 MB
2.2. SQL Server Features That Help Your Application Scale/11.Partitioning and compression.en.srt
6.9 KB
2.2. SQL Server Features That Help Your Application Scale/11.Partitioning and compression.mp4
5.9 MB
2.2. SQL Server Features That Help Your Application Scale/12.Indexing strategies.en.srt
10.1 KB
2.2. SQL Server Features That Help Your Application Scale/12.Indexing strategies.mp4
13 MB
3.3. Building a Tenancy Model/13.Tenancy models.en.srt
4.3 KB
3.3. Building a Tenancy Model/13.Tenancy models.mp4
3.7 MB
3.3. Building a Tenancy Model/14.Multitenant app with database per tenant.en.srt
3.4 KB
3.3. Building a Tenancy Model/14.Multitenant app with database per tenant.mp4
2.7 MB
3.3. Building a Tenancy Model/15.Multitenant app with sharded multitenant databases.en.srt
5.5 KB
3.3. Building a Tenancy Model/15.Multitenant app with sharded multitenant databases.mp4
4.3 MB
3.3. Building a Tenancy Model/16.Database per tenant.en.srt
6.3 KB
3.3. Building a Tenancy Model/16.Database per tenant.mp4
5.2 MB
4.4. Azure Design Patterns for Scale/17.Caching layer.en.srt
5.4 KB
4.4. Azure Design Patterns for Scale/17.Caching layer.mp4
4.4 MB
4.4. Azure Design Patterns for Scale/18.Scale-out options in Azure.en.srt
6.3 KB
4.4. Azure Design Patterns for Scale/18.Scale-out options in Azure.mp4
4.9 MB
4.4. Azure Design Patterns for Scale/19.Design anti-patterns.en.srt
7.2 KB
4.4. Azure Design Patterns for Scale/19.Design anti-patterns.mp4