Azure SQL Connectivity Performance Tips & Tricks | Data Exposed




Channel 9 show

Summary: 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.[01:06] Tips & Tricks intro[03:02] Connection point types[04:35] Filtering [05:22] Batching[07:03] Connection pooling[07:51] New hardware options Resources:Simplify Authentication with Managed Identities for Azure ResourcesHow to use batching to improve Azure SQL Database and Azure SQL Managed Instance application performance