Guy and Eitan discuss change automation tricks for databases, do a round-up of the newest scripts in the Madeira Toolbox, and more.

Relevant links:

  • Database Change Automation:
    • DbaTools
    • sp_generate_merge by Daniel Nolan (readyroll)
    • Add support for "Prevent saving changes that require table re-creation" option in SqlPackage / SSDT (Azure Feedback)
      • (New feedback item at Microsoft Q&A)
  • Madeira Toolbox Round-Up:
    • Missing Indexes with High Impact
    • Increase Database File in Specified Increments
    • SSRS Deployment Powershell script
    • Update RegisterAllProvidersIP and HostRecordTTL in all AG Clusters (multi-subnet best practice)
  • AT TIME ZONE Performance Issues (Jonathan Kehayias)
  • More about AT TIME ZONE (Jonathan Kehayias)
  • Dativerse event by DataGrillen on August 13th

See All 182 Episodes of "SQL Server Radio"