Book Image

Hands-On Azure for Developers

By : Kamil Mrzygłód
Book Image

Hands-On Azure for Developers

By: Kamil Mrzygłód

Overview of this book

Microsoft Azure is one of the fastest growing public cloud service providers in the market currently, and also holds the second highest market share after AWS. Azure has a sophisticated set of services that will help you build fault-tolerant and scalable cloud-based applications. Hands-On Azure for Developers will take you on a journey through multiple PaaS services available in Azure, including App Services, Functions, and Service Fabric, and explain in detail how to build a complete and reliable system with ease. You will learn about how to maximize your skills when building cloud-based solutions leveraging different SQL/NoSQL databases, serverless and messaging components, and even search engines such as Azure Search. In the concluding chapters, this book covers more advanced scenarios such as scalability best practices, serving static content with Azure CDN, and distributing loads with Azure Traffic Manager. By the end of the book, you will be able to build modern applications on the Azure cloud using the most popular and promising technologies, which will help make your solutions reliable, stable, and efficient.
Table of Contents (24 chapters)

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.