22-25 April 2026 
Moving away from One Model to rule them all
2022TL; DR
A data warehouse is a method for providing a single source of truth, but there may be issues on relying on just one model as it does not meet the needs of all users or all types of data. In this session we will explore how to build a data environment which provides flexibility to different groups of users and examples of how to implement different types of technology to provide a broader set of solutions using Azure Synapse, Data lakes and Power BI.
Session Details
Often times a single data warehouse is meant to be the one solution to provide data to an organization, a method some may describe as the Lord of the Rings Model as there is one model to rule them all. There are a number of different reasons why this approach is not suited to most organizations. Some of the reasons are technical, others include an inability for one model to meet the needs of different groups of users or data types. In this session we will explore how to build a data environment which provides flexibility to different groups of users and examples of how to implement different types of technology to provide a broader set of solutions using Azure Synapse, Data lakes and Power BI.
Feedback Link - https://sqlb.it/?7013
Feedback Link - https://sqlb.it/?7013
3 things you'll get out of this session
Speakers
Ginger Grant's previous sessions
How changes to Azure Synapse Analytics impact data architecture designs
Explore the changes that have been made to Azure Synapse Analytics and how this has changed it’s use over time. We will review how these feature additions have impacted the methods used for transforming, storing, and querying data so that you can evaluate whether it would be a good fit for your data environment.
How to pick the best Data transformation strategy
Combining data from multiple sources can be performed using a number of different tools including Azure Synapse Integration/Azure Data Factory, Spark and Power BI Data Flows. We will explore which tool or combination of tools to select to best match your data environment.
SQL Server Internals and Configuration for R
Learn how to configure SQL Server 2016 for running R. The individual components and executables installed with R on SQL Server will be explored to understand the internal interactions and processes involved.