Set up Azure Synapse Analytics workspace with ARM Resource deployment. Learn to pause Dedicated SQL Pool, grant permissions on Azure Data Lake Gen 2 Storage Account for optimal workspace usage in this walkthrough.
In this walkthrough of how to setup an Azure Synapse Analytics workspace, you will go through the steps of creating an Azure Synapse Analytics workspace by deploying an ARM (Azure Template Management) Resource. Through the step by step process you will also understand the importance of pausing your Dedicated SQL Pool after deployment and granting the correct permissions on your Azure Data Lake Gen 2 Storage Account to be able to properly use your Synapse workspace.
Course Outline ( Free Preview)
What you need to get started.
Module 01 - Environment Setup (Arm Template)21 min.
Module 02 - What to do if Deployment Fails (Redeployment)4 min.
Mitchell Pearson is a Solution Architect, Consultant, and Trainer with 14 years of experience at Pragmatic Works helping organizations modernize their data and analytics platforms using Microsoft Azure and Microsoft Fabric. He specializes in designing scalable, enterprise-ready data solutions that align technical architecture with real business outcomes.
Mitchell is known for helping organizations navigate some of the most complex aspects of modern data platforms. Whether guiding customers through Fabric implementations, data modernization initiatives, or enterprise analytics strategies, he has a unique ability to break down sophisticated concepts into practical, understandable frameworks. From Lakehouse architecture and data engineering to medallion architecture design and governance strategies, Mitchell helps teams understand not only what to build, but why it matters and how to implement it successfully.
As a Solution Architect, Mitchell works closely with customers to design both consulting engagements and training programs that accelerate adoption and ensure long-term success. He helps organizations create clear roadmaps for Azure and Fabric implementations, balancing technical best practices with business priorities. His experience spans data platform modernization, analytics strategy, cloud migration, AI readiness, governance, and enterprise reporting solutions.
A recognized author, speaker, and educator, Mitchell has written books on SQL Server, Power BI, and the Power Platform and regularly shares insights on modern data architecture and analytics. His technical expertise includes Microsoft Fabric, Azure data services, Power BI, and the broader Microsoft data ecosystem. Customers value his ability to make complex technologies approachable, helping technical and business teams align around a common vision and confidently move forward with modern data solutions.
