Episode

Database portability and other tricks with SqlPackage | Data Exposed

with Anna Hoffman, Drew Skwiers-Koballa

Data Exposed

Building on data virtualization capabilities in SQL Server 2022 and now Azure SQL Managed Instance, we’re introducing the Parquet data storage capability to SqlPackage in preview. Reading and writing copies of your database is easier and faster for larger databases thanks to the data being stored in Azure Blob Storage as Parquet flat files.

Chapters

  • 00:21 - Introductions
  • 00:48 - What is SQL Package?
  • 02:41 - What are some of the challenges with packages
  • 04:30 - Using Parquet files with packages
  • 07:10 - Showing the difference in speed showing how fast a bacpac can be to Parquet
  • 08:31 - What differences are there for Parquet?
  • 10:39 - Tips and Tricks
  • 11:34 - Closing

Connect

Developer
Azure
SQL Server