Episode 140 - Migration Challenges
- Author
- SQL Server Radio
- Published
- Mon 09 May 2022
- Episode Link
- http://sqlserverradio.com/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
- 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
