Multiroom Support for Chromecast and Audio Extraction for Subwoofer

Chromecast Audio, now defunct, enabled users to pair any audio amplifier or receiver in the house, with casted audio from sources like Spotify and YouTube Music. Enabling multiroom on these devices helped with the option to bring music anywhere in the house, without spending hundreds on receivers that offered Zone 2 and Zone 3 outputs.

Continue reading

Migrating your Data Warehouse from SQL Server to Azure Synapse Analytics – Pass Data Community Summit 2021

We had a great live presentation on November Friday 12th, 2021, at the Data Community Summit 2021. My colleague Gail Zhou, and I, presented a set of feature parities, capabilities and recommendations when migrating a Data Warehouse from SQL Server to Azure Synapse Analytics Provisioned Pool. We also went ahead and provided a hands-on demo on how to a assess the environment, as well as how to migrate objects and data from SQL Server.

If you attended the summit, you are able to download the contents after logging in. If you were not able to attend, you can leverage the contents from links below, instead.

Continue reading

Upcoming Data Community Summit 2021 Session – Migrate from SQL Server to Azure Synapse Analytics

With my colleague Gail, I will be presenting at the Data Community Summit 2021, in November.

Join us to learn how can you take your on-premises SQL Server Data Warehouse, and migrate to Azure Synapse Analytics Provisioned Pool.

Continue reading

Migrating SQL Server to Azure at Scale (Pass Summit 2020)

In November 2020, for the (until then) paid conference SQL Pass 2020, my colleague Avnish Rastogi and myself, presented the topic of how to migrate hundreds of SQL Server databases to Azure at scale.

We executed as Architects within of the Data Migration group at Microsoft, and worked in several engagements assessing multiple source databases and landing them into Azure. From the use cases, we compiled the steps, methodologies and services required to asses and migrate on-premises SQL Server instances to Azure Managed Instance. Leveraging PowerShell, we were able to automate and scale the migration of multiple databases.

Continue reading