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 SQL Database shards