Introduction
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 schemas on different databases.
Horizontal scaling refers to dividing data from a single table into different individual databases.
This lesson will teach you how to autoscale Azure SQL databases and shard a database. The lesson also talks about how to run cross-database queries.