SQLBits 2024

Data tiering using data Virtualization in SQL

TBD
Do you have a need to either connect to or export data outside SQL Server or Azure SQL? In this session, you will learn how you can connect SQL Server 2022 and Azure SQL to external data, work with CSV, Parquet, Delta, leverage SQL metadata functions and procedures to help with schema discovery and search capabilities. Understand how Create External Tables (CET) and Create External Table as Select (CETAS) can be used to create your very own data tiering solution following best practices to offload your read-only data and reduce database maintenance time.