Guy and Eitan talk about various topics related to SQL Server, including upcoming virtual events, interesting new scripts from our toolbox, and more!

Relevant links:

  • SQL Server 2016 SP3: Last Service Pack for SQL Server
    • SQL Server Release Dates and Product Lifecycle
  • PASS Data Community Summit - November 8-12, 2021
    • Development Lifecycle Basics for DBAs
  • Group By Conference 2021
    • SSDT Methodologies & Features for DB DevOps
  • Level up your skills with Bicep!
  • TRY/CATCH and Transactions in SQL Server:
    • TRY...CATCH (Transact-SQL)
    • @@TRANCOUNT (Transact-SQL)
    • XACT_STATE (Transact-SQL)
    • SET XACT_ABORT (Transact-SQL)
  • Today's Madeira Toolbox Round-Up:
    • Table and Index High Unused Space.sql
      • DBCC CLEANTABLE (Transact-SQL)
    • DatabaseIntegrityCheck - Minimal check on PRIMARY, Full check on SECONDARY.sql
      • DatabaseIntegrityCheck by Ola Hallengren
    • Shrink_Database_File_in_Specified_Increments.sql
  • SARGability Week by Erik Darling