Guy and Eitan play a game of word associations to spout a bunch of stuff about SQL Server features - mostly reviewing new system objects that replaced old DBCC commands, useful scripts in our toolbox, and talking about Application Reliability Errors.
Relevant links:
- Buffer Pool Extension
- SQL Server editions comparison dashboard by domains, features, and scale capacities – by Romain Ferraton
- SQL Server Standard vs Enteprise Edition features history – by Romain Ferraton
- SQL Server Scale Limits by Version and Edition - by Eitan Blumin
- sys.dm_os_buffer_descriptors
- Madeira Toolbox: Buffer Pool Distribution by Tables.sql
- Get the last known actual execution plan using sys.dm_exec_query_plan_stats
- sys.dm_db_page_info
- sys.dm_db_log_info
- sys.dm_db_stats_properties
- sys.dm_db_stats_histogram
- Madeira Toolbox: Shrink All Shrinkable Transaction Logs.sql
- Madeira Toolbox: Shrink_Transaction_Log_File.sql
- Madeira Toolbox: Application_Reliability_Monitor_SQLServer.sql
- Madeira Toolbox: Application_Reliability_Monitor_AzureSQLDB.sql
- PASS Data Community Summit 2022 - Register now!
