Data Loading Best Practices on Azure SQL Database | Data Exposed

From the creator

Learn about best practices of loading data to Azure SQL Database, how to efficiently utilize log generation rate, and various techniques to efficiently load data into Azure SQL Database in this episode of Data Exposed with Denzil Ribeiro. 0:00 Show begins 0:43 Data loading overview 3:05 Demo 16:32 Mistakes to be aware of ✔️ Resources: Columnstore data loading guide: https://docs.microsoft.com/en-us/sql/relational-databases/indexes/columnstore-indexes-data-loading-guidance?view=sql-server-ver15 Notebooks which show how to use Spark to do efficient partitioned data loads: https://github.com/Azure-Samples/azure-sql-db-databricks Columnstore data loading blogs: o https://techcommunity.microsoft.com/t5/azure-sql-blog/improved-columnstore-data-loading-using-query-store-hints/ba-p/2704677 o https://techcommunity.microsoft.com/t5/datacat/data-loading-performance-considerations-with-clustered/ba-p/305223 Rowstore data loading guide: https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008/dd425070(v=sql.100)?redirectedfrom=MSDN 📌 Let's connect: Twitter: Anna Hoffman, https://twitter.com/AnalyticAnna Twitter: Denzil Ribeiro, https://twitter.com/DenzilRibeiro Twitter: AzureSQL, https://aka.ms/azuresqltw 🔔 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 #AzureSQLDatabase #AzureSQLDB

Published 2021-11-11 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.