PASSMN Meeting 2023-02-21 (Virtual Meeting Only)

Important Note: This meeting is online only and will not be held at the Microsoft Technology Center

Agenda:
3:30-4:00 Kickoff / Announcements
4:00-6:00 UNIQUEIDENTIFIERs as Primary Keys in SQL Server (Klaus Aschenbrenner)
6:10-6:15 Closing

Presentation topics, abstracts, speaker bio for this meeting:

Speaker: Klaus Aschenbrenner
Topic: UNIQUEIDENTIFIERs as Primary Keys in SQL Server
Abstract:
UNIQUEIDENTIFIERs as Primary Keys in SQL Server - a good or bad best practice? They have a lot of pros for DEVs, but DBAs just cry when they see them enforced by default as unique Clustered Indexes. In this session we will cover the basics about UNIQUEIDENTIFIERs, why they are bad and sometimes even good, and how you can find out if they affect the performance of your performance critical database. If they are affecting your database negatively, you will also learn some best practices how you can resolve those performance limitations without changing your underlying application.