SQL Authority News – Download and Install AdventureWorks 2014 Sample Databases

SQL Authority News - Download and Install AdventureWorks 2014 Sample Databases 10-800x450 If you are using SQL Server there are good chances that you are familiar with AdventureWorks. AdventureWorks is a Sample Database shipped with SQL Server and it can be downloaded from GitHub site. AdventureWorks have replaced Northwind and Pubs from the sample database in SQL Server 2005. The Microsoft team keeps updating the sample database as they release new versions. I use the AdventureWorks database for most of my example, as it is easy to use sample database which is accessible for most of the people out there. Let us learn to install AdventureWorks.

Every new version of SQL Server should have its own AdventureWorks database. The reason is that SQL Server comes up with new features with every version and most of the new features need a new dataset sample to demonstrate the capabilities of the features. This is the why every version of SQL Server has its own AdventureWorks database.

SQL Server 2014 has many new features and to support that Microsoft has released new AdventureWorks 2014 Sample Database.

You can download Adventure Works 2014 Sample Databases from here.

Here is a quick tutorial how one can install the AdventureWorks database on your server.

In the year 2016 Microsoft has replaced AdventureWorks with WideWorldImports database. You can read about that over here: Download and Install Sample Database WideWorldImporters

Reference: Pinal Dave (https://blog.sqlauthority.com)

SQL Download, SQL Sample Database, SQL Scripts, SQL Server
Previous Post
SQL SERVER – Microsoft SQL Server Migration Assistant V6.0 Released
Next Post
Database – Beginning with Cloud Database As A Service

Related Posts

6 Comments. Leave new

  • this worked; pointing to the right versions. Thanks Pinal Dave

    October 19, 2017 6:17 am


  • Fahad Taher
    June 6, 2018 2:24 am

    it goes to a Dangerous warning site link.

  • Divyang Panchal
    April 22, 2019 9:03 pm

    SELECT ProductCostHistory.StandardCost, Product.ProductID
    FROM Production.ProductCostHistory
    INNER JOIN Production.Product ON ProductCostHistory.ProductID = Product.ProductID
    WHERE ProductCostHistory.StandardCost > (SELECT AVG(ProductCostHistory.StandardCost)
    FROM Production.ProductCostHistory
    WHERE ProductCostHistory.ProductID = Product.ProductID
    GROUP BY ProductCostHistory.ProductID)


Leave a ReplyCancel reply

Exit mobile version