Data Platform Engineer or Data Platform Consumer looking to understand the basic concepts of Azure Data Warehouse ahead of implementing a solution on the technology.
Azure SQL Data Warehouse is maturing rapidly and becoming a serious option for both Microsoft Azure, and hybrid data platform solutions looking for analytics capability. Many businesses have selected Azure SQL Data Warehouse and are making the transition from on-premises Data Warehouse solutions to the Azure cloud for analytics. Making sure that you are ready for this journey is important as there are some very large differences between running a SQL Server with a Data Warehouse, as opposed to running Azure SQL Data Warehouse.
This objective of this session is to help you prepare for making that journey, ensuring that you are going to be able to make informed choices about the direction you will travel. Allowing you to avoid the potholes, confidently select a fork in the road, and be sure that you can make it to your destination.
The key areas that we will plan for are:
- Understanding the key differences between the MPP architecture and SQL Server world many of us are familiar with
- Exploring concurrency mechanisms and how this will inform decisions around user access methods
- Different schema and technology options that are available for accessing data sources, internal and external
- How data will drive design elements of the Data Warehouse schema with a view on what, and what not to do
- What loading patterns exist for getting data into Azure SQL Data Warehouse
- The demarcation between Microsoft and us when it comes to maintenance operations
Getting to grips with these facets of how Azure SQL Data Warehouse works will help make sure that when you deliver the solution backed by Azure SQL Data Warehouse, that it is going to do what you need.
Why I Want to Present This Session:
There are a number of misconceptions around the use of Azure SQL Data Warehouse and how it can be used. This session looks to cover the basics to help people break through these and gain an appreciation for the fundamentals, and help them start evaluating it.
Latest posts by John Martin (see all)
- Working with Dynamic Data Masking & Row Level Security - April 16, 2017
- Azure SQL Data Warehouse : 101 - April 16, 2017