Sql Server Radio

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