Azure SQL provides several connectivity options to cover different application scenarios. It is important to understand that they may have implications related to security and performance. In this episode with Silvano Corini, we will go through some tips & tricks that may help you to find the best for your needs.

Resources:

Capacity planning plays a critical role in migrating an existing application or designing a new one. In the final part of this three-part series with Silvano Coriani, we’ll review various Azure SQL capacity planning scenarios, as well as review best practices and recommendations on what to use when. 

Time index:

  • 0:00 Introduction
  • 1:26 Greenfield development scenario
  • 5:42 Existing applications on-prem or other clouds scenario
  • 7:42 On-prem demo
  • 12:01 Changes in existing Azure SQL DB apps scenario

Whether migrating an existing application or designing a brand new one, capacity planning process plays a critical role.

Learn how to navigate across Azure SQL Database options like hardware generation, service and compute tiers, and instance sizing principles, trying to find the sweet spot between performance, functionalities, and costs, in the first episode of this three-part series with Silvano Coriani.

Content:

  • 0:00 Introduction
  • 0:58 What is capacity planning
  • 2:04 Azure SQL Database dimensions to consider
  • 3:30 Deployment options
  • 4:50 Purchasing models
  • 6:25 Service tiers
  • 7:55 Compute sizes and resource limits