![]() This document describes a simple process to get the AdventureWorks sample database restored into your SQL Managed Instance - Azure Arc. It is provided and maintained by Microsoft as part of the SQL Server samples GitHub repository. The sample databases from Microsoft give you plenty of opportunities to work with different techniques for both OLTP and data warehouse and even familiarize yourself with Azure without having to come up with your own data.AdventureWorks is a sample database containing an OLTP database that is often used in tutorials, and examples. What Are You Waiting For?ĭatabase professionals, this is your chance to start exploring the features and functionality that SQL Server has to offer. The data set is large enough that it’s possible to make use of these features but it’s still small enough that you won’t need enterprise grade hardware to accomplish these things in a reasonable amount of time. While it’s not the biggest database (my copy is around 1.6GB), ContosoRetailDW provides a large enough data set where aspiring database professionals can really start to push the limits of a local SQL Server.ĬontosoRetailDW is also a good place to try out Enterprise Edition features like table partitioning and ColumnStore indexes. The Contoso Retail DW data set is several times the size of AdventureWorks and comes as a pre-built star schema. The AdventureWorks data sets are a great starting place, but the data set size doesn’t pose many challenges. Let’s say you want to do something a bit more adventurous and you want to branch out into the bigger BI world that Microsoft has to offer. If you’re just getting started, those are a good option (especially since there’s an SSAS tutorial available). There are some light weight data warehouse options available, but they are still relatively small. ![]() If you want to deal with international databases, pick the CS version.Ī full list of AdventureWorks OLTP options is available at. The CS lets you know it’s a case sensitive option. Protip: There’s usually a CS option for each of these. If you want something for Azure, use the script file to create the database and deploy data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |