Azure SQL Connectivity Performance Tips & Tricks Data Exposed (Audio)

Content provided by Data Exposed (Audio) - Channel 9. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Data Exposed (Audio) - Channel 9 or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://player.fm/legal.

Data Exposed (Audio) - Channel 9 »
Azure SQL Connectivity Performance Tips & Tricks

3+ y ago 10:42

MP3•Episode home

Archived series ("Inactive feed" status)

When? This feed was archived on February 22, 2021 14:09 (3y ago). Last successful fetch was on January 21, 2021 23:38 (3+ y ago)

Why? Inactive feed status. Our servers were unable to retrieve a valid podcast feed for a sustained period.

What now? You might be able to find a more up-to-date version using the search function. This series will no longer be checked for updates. If you believe this to be in error, please check if the publisher's feed link below is valid and contact support to request the feed be restored or if you have any other concerns about this.

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 Resources
How to use batching to improve Azure SQL Database and Azure SQL Managed Instance application performance

27 episodes

#Tech #SQL Server #montserrat