Adventureworks database for SQL Server 2016

  • 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

  • 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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • 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.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    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]

  • 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

  • Ohh Yes .. even on MS virtual LAB they Show DAtabase Adventure works 2016 but the compatibility level is of 120

  • 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

  • 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 It even comes with an SSIS package which should be good to use for demos.

  • 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 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?

    Catch-all queries done right [/url]
    Gail Shaw's Performance Blog[/url]

  • 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 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply