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

Amcrest GO 4K Action Camera – Quick Review

Being an Amcrest security video user, I decided to give the Amcrest GO 4K Action Camera a go. The camera is small, all plastic, that comes with many accessories, including an underwater/waterproof case. For under $50, this is what you get:

  • 1 x 4K Action Camera (AC4K-600).
  • 1 x Waterproof Case.
  • 1 x Bicycle Mount.
  • 1 x Back Clip.
  • 2 x Adhesives.
  • 1 x Mount Connector.
  • 2 x Helmet Mounts.
  • 1 x USB Charging Cable.
  • 1 x Li-Ion Battery.
  • 1 x User Manual.
Continue reading

Peruvian Voting Data with PowerBI

It continues to be a controversial voting scenario for Peruvians, on the second round of voting between Pedro Castillo (far left) and Keiko Fujimori (far right). There have been allegations of fraud, though no tangible evidence has been provided yet.

ONPE, the National Office of Electoral Processes of Peru, has made the voting dataset public, for both 1st and 2nd rounds. That shows the level of transparency the entity is providing, to try mitigate disinformation.

Continue reading