Bob Duffy
prodata.ie/author/bob
Bob Duffy is a SQL Server MVP, currently working as Database and Solution Architect in Dublin, Ireland. He has over 28 years experience in the database sector, with MCA, MCM and Maestro certification.
SQLBits 2022
EDW Automation in Synapse SQL Pools
DW Automation and Design Best Practices
Star schema can be very slow to develop an expensive to maintain. You need to add a column to a dimension or a new Fact table. Does that take hours, weeks, an entire development sprint, or is this just too expensive to even think about ?
In this session we will recap good design best practices and demo how to use meta data to build an EDW which scores highly on Agility, Extensibility, Performance, Design Complexity, Conformity and Supportability using SQL Dedicated Pools in Synapse. Concepts are applicable to many other platforms too.
Come along if you are a data Architect or Engineer looking to see how we build for and measure architectural principles such as agility and extensibility.
Feedback Link - https://sqlb.it/?7062
In this session we will recap good design best practices and demo how to use meta data to build an EDW which scores highly on Agility, Extensibility, Performance, Design Complexity, Conformity and Supportability using SQL Dedicated Pools in Synapse. Concepts are applicable to many other platforms too.
Come along if you are a data Architect or Engineer looking to see how we build for and measure architectural principles such as agility and extensibility.
Feedback Link - https://sqlb.it/?7062