SQL Saturday #1041 (Jacksonville 2023)

Welcome

The following presentations were given for SQL Saturday #1041 (Jacksonville), on May 5th, 2023 at University of North Florida (UNF).

Make sure you subscribe to the mailing list, and if you watch the video, subscribe to the YouTube Channel.  You can follow me on Twitter and LinkedIn.  If you or your workplace is in need of my services, check out NetCorp.

Session #1: Optimize Your SQL Database

Welcome to the landing page for this presentation, containing resources for optimizing your SQL database.

Session Video

Note: I hope to post a copy of this presentation soon.  See slide deck below.

Resources

Azure SQL Database

SQL Server on Azure Virtual Machines

Microsoft SQL Server on AWS

Configure read-only access to secondary availability group replica – SQL Server Always On | Microsoft Learn

Default auto statistics update threshold change for SQL Server 2016 – Microsoft Community Hub

Sharding pattern – Azure Architecture Center | Microsoft Learn

Scaling out – Azure SQL Database | Microsoft Learn

Entity Framework Core (.NET Core) – Azure SQL Database Transient Faults | Microsoft Docs

Connection Resiliency – EF Core | Microsoft docs.microsoft.com/…/transient-fault-handlingDocs

Transient Fault Handling (Building Real-World Cloud Apps with Azure) | Microsoft Docs

Session #2: SQL in the Cloud – Azure vs AWS vs GCP

Welcome to the landing page for this presentation, containing resources on the different Microsoft SQL Server (and other ANSI SQL) offerings within Microsoft Azure, Amazon Web Services (AWS) and Google Cloud Platform (GCP).