{"id":1413,"date":"2008-08-22T07:54:00","date_gmt":"2008-08-22T07:54:00","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/cesardelatorre\/2008\/08\/22\/sql-server-2008-sample-databases\/"},"modified":"2008-08-22T07:54:00","modified_gmt":"2008-08-22T07:54:00","slug":"sql-server-2008-sample-databases","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/cesardelatorre\/sql-server-2008-sample-databases\/","title":{"rendered":"SQL SERVER 2008 Sample Databases"},"content":{"rendered":"

 <\/P>\n

This is a useful post because SQL Server 2008 has just been released a few days ago, and we will have tons of labs and samples, most of them based on Microsoft sample databases like the new version of Northwind sample database, so, we\u2019ve got this neat place in CODEPLEX<\/B> where we can download different sample database versions.<\/P>\n

http:\/\/www.codeplex.com\/MSFTDBProdSamples\/Release\/ProjectReleases.aspx?ReleaseId=16040<\/A><\/P>\n

Those sample databases (last version) have been published just a few days ago, in August, as well.<\/P>\n

For instance, there is a new sample database very useful for development demos (like demoing LINQ or Entity Framework) where you need just several tables and you do not need a very complex database. It is called \u2018AdventureWorks Lite<\/B>\u2019 and the database name is AdventureWorksLT<\/B>. It is a new sample database based on the Adventure Works Cycles scenario.<\/P>\n

Like I said, the purpose of the AdventureWorksLT<\/B> database is to provide a simple, small database sample focused on a product sales scenario. <\/P>\n

This is the schema diagram for AdventureWorksLT, quite easy to take a look:<\/P>\n

\"clip_image002[4]\"<\/A><\/P>\n

AdventureWorksLT<\/B> is simpler and smaller than AdventureWorksOLTP<\/B> in the following ways:<\/P>\n

\u00b7 The schema design is a bit denormalized compared with AdventureWorks. To obtain useful information either requires no joins, or fewer joins compared with AdventureWorks.<\/P>\n

\u00b7 The quantity of data is reduced from about 183mb down to 7mb which makes it more practical to download over slow or unreliable Internet connections. <\/P>\n

\u00b7 Instead of 5 schemas plus dbo in the database, AdventureWorksLT has one schema plus dbo in the database. <\/P>\n

\u00b7 Instead of 70 tables, AdventureWorksLT has 12 tables.<\/P>\n

Of course, if you’re going to implement a real\/production project database based on SQL Server 2008<\/STRONG>, you’d better take a look to the AdventureWorksOLTP<\/B> (transactions database) and also to AdventureWorks_DW_BI<\/STRONG> database (Datawarehouse and BI database) which are more complex, by far, but they are like a real production database could be. <\/P>\n

Here you have a further explanation about the several sample databases & installation options (we\u2019ve got now MSIs, etc.):<\/P>\n

http:\/\/blogs.msdn.com\/bonniefe\/archive\/2008\/08\/07\/sql-server-2008-samples-are-here.aspx<\/A><\/P><\/p>\n","protected":false},"excerpt":{"rendered":"

  This is a useful post because SQL Server 2008 has just been released a few days ago, and we will have tons of labs and samples, most of them based on Microsoft sample databases like the new version of Northwind sample database, so, we\u2019ve got this neat place in CODEPLEX where we can download […]<\/p>\n","protected":false},"author":362,"featured_media":12806,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[91],"class_list":["post-1413","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cesardelatorre","tag-sql-server-2008"],"acf":[],"blog_post_summary":"

  This is a useful post because SQL Server 2008 has just been released a few days ago, and we will have tons of labs and samples, most of them based on Microsoft sample databases like the new version of Northwind sample database, so, we\u2019ve got this neat place in CODEPLEX where we can download […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/cesardelatorre\/wp-json\/wp\/v2\/posts\/1413","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/cesardelatorre\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/cesardelatorre\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/cesardelatorre\/wp-json\/wp\/v2\/users\/362"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/cesardelatorre\/wp-json\/wp\/v2\/comments?post=1413"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/cesardelatorre\/wp-json\/wp\/v2\/posts\/1413\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/cesardelatorre\/wp-json\/wp\/v2\/media\/12806"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/cesardelatorre\/wp-json\/wp\/v2\/media?parent=1413"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/cesardelatorre\/wp-json\/wp\/v2\/categories?post=1413"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/cesardelatorre\/wp-json\/wp\/v2\/tags?post=1413"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}