A New Solution for Data Archiving Using Data Virtualization

Andy Yun, Emily Thornhill

Do you have a VLDB with lots of data that will never change again? Would you love to get that static data out of your main database, but users still need to query it like your hot data.

If you answered yes, join me to learn how SQL Server 2022’s Data Virtualization can help you solve this everyday use case! This (mostly non-)vendor session will explore using T-SQL’s CREATE EXTERNAL TABLE AS SELECT (CETAS) to extract your VLDB’s archive data to any S3 compatible Object Storage, both cloud and on-prem. And the best part of this solution is that your users will not know the difference, as they will still be able to query it as they always have.