![Adventure Format Template Adventure Format Template](https://www.dmsguild.com/images/8957/171204.jpg)
Adventure is free Bootstrap parallax theme. Homepage image slider with thumbnails, content carousel, accordion, lightbox image gallery, pricing tables, and contact form are included. You can read more about Adventure Bootstrap Theme template usage rights. DMs Guild Creator Resource - Adventure Template - This file includes a Word template which you are licensed to use in content submitted to the Dungeon Masters Guild progr.
Where in the World is AdventureWorks?
Recently, SQL Community feedback from twitter prompted me to look in vain for SQL Server 2014 versions of the AdventureWorks sample databases we’ve all grown to know & love.
I searched Codeplex, then used the bing & even the google in an effort to locate them, yet all I could find were samples on different sites highlighting specific technologies, an incomplete collection inconsistent with the experience we users had learned to expect. I began pinging internally & learned that an update to AdventureWorks wasn’t even on the road map.
Fortunately, SQL Marketing manager Luis Daniel Soto Maldonado (t) lent a sympathetic ear & got the update ball rolling; his direct report Darmodi Komo recently announced the release of the shiny new sample databases for OLTP, DW, Tabular, and Multidimensional models to supplement the extant In-Memory OLTP sample DB.
What Success Looks Like
In my correspondence with the team, here’s how I defined success:
1. Sample AdventureWorks DBs hosted on Codeplex showcasing SQL Server 2014’s latest-&-greatest features, including:
- In-Memory OLTP (aka Hekaton)
- Clustered Columnstore
- Online Operations
- Resource Governor IO
2. Where it makes sense to do so, consolidate the DBs (e.g., showcasing Columnstore likely involves a separate DW DB)
3. Documentation to support experimenting with these features
As Microsoft Senior SDE Bonnie Feinberg (b) stated, “I think it would be great to see an AdventureWorks for SQL 2014. It would be super helpful for third-party book authors and trainers. It also provides a common way to share examples in blog posts and forum discussions, for example.”
Exactly. We’ve established a rich & robust tradition of sample databases on Codeplex. This is what our community & our customers expect. The prompt response achieves what we all aim to do, i.e., manifests the Service Design Engineering mantra of “delighting the customer”. Kudos to Luis’s team in SQL Server Marketing & Kevin Liu’s team in SQL Server Engineering for doing so.
Download AdventureWorks 2014
Download your copies of SQL Server 2014 AdventureWorks sample databases here.
-->AdventureWorks download links and installation instructions.
Prerequisites
- SQL Server or Azure SQL Database. For the Full version of the sample, use SQL Server Evaluation/Developer/Enterprise Edition.
- SQL Server Management Studio. For the best results use the June 2016 release or later.
Github links
OLTP downloads
Direct links to the OLTP versions of AdventureWorks can be found below:
Data Warehouse downloads
Direct links to the Data Warehouse versions of AdventureWorks can be found below:
Creation scripts
The below scripts can be used to create the entire AdventureWorks database, irrespective of version.
Install to SQL Server
Restore backup
Follow the below steps to restore a backup of your database using SQL Server Management Studio.
- Open SQL Server Management Studio and connect to the target SQL Server instance.
- Right-click on the Databases node, and select Restore Database.
- Select Device and click the ellipses (...)
- In the dialog Select backup devices, click Add, navigate to the database backup in the filesystem of the server, and select the backup. Click OK.
- If needed, change the target location for the data and log files, in the Files pane. Note that it is best practice to place data and log files on different drives.
- Click OK. This will initiate the database restore. After it completes, you will have the AdventureWorks database installed on your SQL Server instance.
For more information on restoring a SQL Server database, see Restore a database backup using SSMS.
Attach a datafile
Follow the below steps to attach the datafile for your database using SQL Server Management Studio.
- Open SQL Server Management Studio and connect to the target SQL Server instance.
- Right-click on the Databases node, and select Attach.
- Select Add and navigate to the .MDF file you want to attach.
- Select the file and click OK.
- The database you selected should be displayed in the bottom window. If the file is listed as 'not found', select the ellipses (...) next to the file name and update the path to the correct path.
- If you only have the data file (.mdf), and not the log file (.ldf), then highlight the .ldf in the bottom window and select Remove. This will create a new log file.
- Select OK to attach the file. After the file is attached, you will have the AdventureWorks database installed on your SQL Server instance.
For more information on attaching database files, see Attach a database.
Install to Azure SQL Database
If you do not yet have a SQL Server in Azure, navigate to the Azure portal and create a new SQL Database. In the process of create a database, you will create a server. Make note of the server. See this tutorial to create a database in minutes.
- Connect to your Azure portal.
- Select Create a resource in the top left of the navigation pane.
- Select Databases and then select SQL Database.
- Fill in the requested information.
- In the Select Source field, select Sample (AdventureWorksLT) to restore a backup of the latest AdventureWorksLT backup.
- Select Create to create your new SQL Database, which is the restored copy of the AdventureWorksLT database.
See also
Tutorials for SQL Server Management Studio
Tutorials for SQL Server database engine
Tutorials for SQL Server database engine