Reader small image

You're reading from  Hands-On Azure for Developers

Product typeBook
Published inNov 2018
PublisherPackt
ISBN-139781789340624
Edition1st Edition
Tools
Right arrow
Author (1)
Kamil Mrzygłód
Kamil Mrzygłód
author image
Kamil Mrzygłód

Kamil Mrzygłód is a technical lead and technology advisor, working with multiple companies on designing and implementing Azure-based systems and platforms. He's a former Microsoft Azure Microsoft Most Valuable Professional (MVP) and certified trainer, who shares his knowledge via various channels, including conference speeches and open source projects and contributions. Kamil lives in Poland with his two cats and one dog, dedicating some of his time to video games, cooking, and traveling.
Read more about Kamil Mrzygłód

Right arrow

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 firewallyou 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.
lock icon
The rest of the page is locked
Previous PageNext Page
You have been reading a chapter from
Hands-On Azure for Developers
Published in: Nov 2018Publisher: PacktISBN-13: 9781789340624

Author (1)

author image
Kamil Mrzygłód

Kamil Mrzygłód is a technical lead and technology advisor, working with multiple companies on designing and implementing Azure-based systems and platforms. He's a former Microsoft Azure Microsoft Most Valuable Professional (MVP) and certified trainer, who shares his knowledge via various channels, including conference speeches and open source projects and contributions. Kamil lives in Poland with his two cats and one dog, dedicating some of his time to video games, cooking, and traveling.
Read more about Kamil Mrzygłód