Tuesday, July 19, 2011

Adventure Works for SQL Server Denali CTP3

I came across this link on Codeplex this morning which will be helpful for learing Denali

Here is an excerpt from the site

This release is dedicated to the Adventure Works sample databases and related samples that ship for Microsoft SQL Server code-named "Denali", Community Technical Preview 3 (CTP3). This release uses the AdventureWorks2008R2 and AdventureWorksDWDenali sample databases. They have been upgraded to the "Denali" CTP3 version.

The only change to AdventureWorks2008R2 is the removal of the FILESTREAM dependency. The FILESTREAM properties have been removed from the Production.Document table. No additional schema or data changes have been made.

The only changes to AdventureWorksDWDenali are the additions of the FactProductInventory table, which contains inventory data, and more date data in the DimDate table to fill the years, 2001 to 2006.

These databases cannot be installed on any version of SQL Server other than SQL Server code-named "Denali" CTP3.

No comments:

Step By Step Guide to resolve SQL server connection issues when connecting from R Studio

Yesterday I tried using a couple of  RevolveScaleR functions -- RxSqlServerData and RxImport.in Rstudio.  These are my learnings as part of ...