SQLBits 2023
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.
The introduction of Azure Synapse Analytics has changed the architecture of many data solutions. Since the product was introduced, new features have been included which impact the use cases for when Azure Synapse would be a good choice in your data environment. We will review recent application modifications and how they influence what strategies and languages to use for orchestrating, storing and querying your data. This session may change your mind for when and how you can use Azure Synapse analytics as part of your data architecture.
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.