Chapter 6. Scaling Out Azure SQL Database

You can easily scale up or scale down an Azure SQL Database either automatically or manually. There are two types of scaling: vertical and horizontal.

Vertical scaling refers to switching to a higher or lower service tier, or vertically partitioning the data, which is to store different schema on different databases.

Horizontal scaling refers to dividing data from a single table into different individual databases.

This chapter teaches you how to auto scale Azure SQL Databases and shard a database. The chapter further talks about how to run cross-database queries.

By the end of this chapter, you will be able to:

  • Perform vertical and horizontal scaling
  • Run cross-database elastic queries
  • Create and maintain Azure ...

Get Professional Azure SQL Database Administration now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.