July 2, 2015 at 8:03 am
On Microsoft's website https://msdn.microsoft.com/en-us/library/hh231699.aspx they point to AW of SQL 2014 to be used, wondering if there is any 2016 AW database
July 2, 2015 at 8:09 am
Unlikely there will be an official demo DB until after launch. Features are still changing, we're still in preview. It's no impossible that queries written now won't work come release.
Use the 2014 one and try out the new features by yourself.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 2, 2015 at 8:17 am
I agree with Gail.
When using AdventureWorks 2014 with SQL 2016, I would check the Compatibility Level and set it to SQL 2016, if not already set that way.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
July 2, 2015 at 11:31 am
The AdventureWorks databases are almost never released before the product. I know this because every time I'm working on a book prior to the release I have to use the older database. It means either telling people to use that older database with the book, or, going through a period of retest right before the book comes out. Both are less than enjoyable.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 11, 2015 at 9:46 am
Ohh Yes .. even on MS virtual LAB they Show DAtabase Adventure works 2016 but the compatibility level is of 120
July 11, 2015 at 1:01 pm
Echoing what has been said. Just use the 2014 version of AW. The database likely won't change much for 2016. It hasn't really changed in that last few releases.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 2, 2016 at 8:49 am
Here you go, guys - The NEW database for use with SQL Server 2016. AdventureWorks is dead. Long live Wide World Importers !!! https://github.com/Microsoft/sql-server-samples/blob/master/samples/databases/wide-world-importers/documentation/root.md"> https://github.com/Microsoft/sql-server-samples/blob/master/samples/databases/wide-world-importers/documentation/root.md It even comes with an SSIS package which should be good to use for demos.
June 2, 2016 at 10:11 am
Gareth Swan (6/2/2016)
Here you go, guys - The NEW database for use with SQL Server 2016. AdventureWorks is dead. Long live Wide World Importers !!! https://github.com/Microsoft/sql-server-samples/blob/master/samples/databases/wide-world-importers/documentation/root.md"> https://github.com/Microsoft/sql-server-samples/blob/master/samples/databases/wide-world-importers/documentation/root.md It even comes with an SSIS package which should be good to use for demos.
That is odd.
I could have sworn I installed AdventureWorks2016CTP3 and AdventureWorksDW2016CTP3 which I downloaded from here
<https://www.microsoft.com/en-us/download/details.aspx?id=49502> AdventureWorks Sample Databases and Scripts for SQL Server 2016 CTP3, which had new features available.
Or is this spam for Github?
June 2, 2016 at 10:25 am
Yes, I have seen and used the AdventureWorks2016CTP databases, as well.
I don't know if there will be an updated version for the RTM or not.
We happened to find the new WWI databases and thought we could use those.
🙂
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply