It's that time again! The time to talk about SQL Server! We got a bunch of different topics to talk about on this show.
Relevant links:
- Cardinality Estimation: Combining Density Statistics | Paul White
- SQL Server CE: Multiple single-column statistics connected by AND
- SQL Server CE: Multiple single-column statistics connected by OR
- Detect Low PAGE Compression Success Rates in all Databases | Eitan Blumin
- The Curious Case of… tracking page compression success rates | Paul Randal
- The Ultimate Compression Savings Estimation Script for an Entire Database | Eitan Blumin
- SQLBits 2022 Conference
- Enterprise Data World 2022 Conference
- Buffer Pool Distribution by Tables | Guy Glantser
- Track Failed Logins in Azure SQL DB using RING_BUFFER_CONNECTIVITY
- Is SQL Server Profiler in Azure Data Studio? – SQLServerCentral
- Using the SSMS XEvent Profiler