Episode 140 - Migration Challenges

Guy and Eitan discuss interesting challenges and news about migrations in SQL Server.

Also, we talk about performance considerations of partitioning in SQL Server, a blog post series about how to tune performance, and new scripts in our Madeira Toolbox on GitHub.

Relevant links:

• Data-tier Applications (DACPAC and BACPAC)
• About: Snapshot Replication
• Generally available: Azure Virtual Machines increase storage throughput by up to 300%
• Generally available: Announcing Azure SQL Migration extension for Azure Data Studio
• Public preview: Reverse Migration of Azure SQL Database Hyperscale tier to General Purpose tier
  • Limitations for Reverse Migration
• SQL SERVER – Table Partitioning for Slow Performance | Pinal Dave
• How To Tune Performance - Chapter 4: Common Problems | Sagi Amichai
• Find Redundant Indexes with Recommendations for all Databases | Madeira Toolbox