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 readingWe 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 readingWith 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 readingThis 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 readingAs 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