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

Om Podcasten

SQL Server Radio is a Podcast for SQL Server DBAs, database developers, architects, system administrators, and anyone else who is interested in the Microsoft SQL Server platform and the Microsoft data platform in general. As the data world changes, we also occasionally talk about other platforms and services like Azure and Amazon cloud services, Elastic Search, Hadoop, MongoDB, Machine Learning, and much more.