Episode 131 - The First Madeira Toolbox Round-Up

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