Customers that are looking after migrating their Data Warehouse from and Oracle and/or Exadata platforms into Azure Synapse Analytics dedicated pool, can assess their environments with tools that can run on Windows or Linux OS machines.
Continue readingTag Archives: Azure
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 readingAzure Synapse Analytics – Introduction and Getting Started
This is a relay to my colleague’s YouTube channel (Arshad Ali – Aas Trailblazers), that has started a series of educational videos about Azure Synapse Analytics.
Continue readingMigrating 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 readingCreate External Tables on Azure Synapse Analytics
As we continue working with Azure Synapse Analytics on Peruvian voting data, as I have posted before, we are extending to creating an external table from the ground up, that points to existing data in the Data Lake Store.
This post will show how to create an external table that will point to a folder hierarchy that contains data in plain text (CSV format). All files inside the folder will be considered for this example.
Continue reading