Chapter 16: SQL in Azure – Azure SQL

1. Azure SQL is constantly updated and gets the updates faster than Microsoft SQL Server.
2. Sharding is dividing your data and database into smaller chunks, which can be distributed evenly, and handle only their part of the load.
3. By default, the connection is blocked by the firewall—you have to add your IP address to the whitelist.
4. DTU-based and vCore-based.
5. The elastic pool is a model of scaling where instead of having a single database with provisioned throughput, you have a pool, which you can dynamically assign to a set of databases.
6. eDTU is the elastic-DTU that is used with elastic pools.
7. You can use the feature called Dynamic Data Masking.
8. You have three option available: Azure Storage, Azure Log Analytics, and Azure Event Hub.