Sign in to confirm you’re not a bot
This helps protect our community. Learn more

Database portability and other tricks with SqlPackage | Data Exposed

Microsoft Developer
585K subscribers
<__slot-el>
<__slot-el>
1.5K views 1 year ago #LearnSQL #SQL #AzureSQL
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 ✔️ Additional Resources: https://learn.microsoft.com/sql/tools... https://learn.microsoft.com/shows/dat... https://techcommunity.microsoft.com/t... https://github.com/microsoft/dacfx in a new tab 📌 Let's connect: Twitter - Anna Hoffman,   / analyticanna   Twitter - AzureSQL, https …...more
...more
Database portability and other tricks with SqlPackage | Data Exposed
34Likes
1,519Views
2023Nov 9
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 ✔️ Additional Resources: https://learn.microsoft.com/sql/tools... https://learn.microsoft.com/shows/dat... https://techcommunity.microsoft.com/t... https://github.com/microsoft/dacfx in a new tab 📌 Let's connect: Twitter - Anna Hoffman,   / analyticanna   Twitter - AzureSQL, https://aka.ms/azuresqltw 🔴 Watch even more Data Exposed episodes: https://aka.ms/dataexposedyt 🔔 Subscribe to our channels for even more SQL tips: Microsoft Azure SQL: https://aka.ms/msazuresqlyt Microsoft SQL Server: https://aka.ms/mssqlserveryt Microsoft Developer: https://aka.ms/microsoftdeveloperyt #AzureSQL #SQL #LearnSQL

Follow along using the transcript.

Microsoft Developer

585K subscribers