Author
Joey D'Antoni
Released
11/12/2018- 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
Skill Level Intermediate
Duration
Views
- [Joey] Have you had problems with your application's scaling as your user base and workloads increase? You can design a data structure for various business applications to maintain data security, and deliver optimal performance for your customers. Reducing workload on your database layer by using a caching tier, and avoid database-design patterns which dramatically limit the scalability of your applications through inefficient processing. You'll be able to identify the specific requirements of your application's workload so you can efficiently tune it.
Hi, I'm Joey, I'm a Microsoft Data Platform MVP. Please join me in my LinkedIn Learning course on how to build and design world-class database applications.
-
Introduction
-
1. Designing for Scale
-
Building an archiving model3m 56s
-
2. SQL Server Features That Help Your Application Scale
-
In-memory OLTP overview4m 39s
-
Partitioning and compression3m 45s
-
Indexing strategies5m 29s
-
-
3. Building a Tenancy Model
-
Tenancy models2m 14s
-
Database per tenant3m 20s
-
-
4. Azure Design Patterns for Scale
-
Caching layer2m 47s
-
Scale-out options in Azure3m 15s
-
Design anti-patterns3m 33s
-
-
Conclusion
-
Next steps39s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Scaling your data tier