Definition

AdventureWorks Database

Mark Fontecchio

By

Mark Fontecchio

AdventureWorks Database is a Microsoft product sample for an online transaction processing (OLTP) database. The AdventureWorks Database supports a fictitious, multinational manufacturing company called Adventure Works Cycles.

Microsoft highlight SQL Server features with the AdventureWorks Database, various versions of which can be downloaded at the SQL Server community projects and samples page on CodePlex, a Microsoft open source project site. Downloads include AdventureWorks Database 2008 and AdventureWorks Database 2012.

AdventureWorks Database is also used in code examples found in SQL Server documentation and books. There are also versions for SQL Azure and SQL Server 2005.

This was last updated in October 2013

Continue Reading About AdventureWorks Database

Management Studio Exercise

Find size of SQL Server tables and other objects with stored procedure

Configure aliases for SQL Server databases and servers

SQL Server community projects and samples page

Dig Deeper on Database management

SearchBusinessAnalytics

Data storytelling, cloud in focus at Tableau Conference '22
Following its 2021 acquisition of Narrative Science, data storytelling -- along with cloud capabilities -- will be prominent when...
ThoughtSpot roadmap aims to make analytics simple, efficient
The vendor's product development philosophy is designed to give users more output from the platform while requiring less effort ...
ThoughtSpot demonstrates its evolution at Beyond 2022
The vendor's first in-person user conference since 2019 has showcased its transformation. In an interview, ThoughtSpot CEO ...

SearchAWS

In search of AWS Solutions Architect preparation?
Think you're ready for the AWS Certified Solutions Architect certification exam? Test your knowledge with these 12 questions, and...
Experts raise privacy concerns over Amazon fleet surveillance
Amazon said its van monitoring system is designed solely for driver safety. But many industry experts have concerns regarding the...
Here's why Amazon's global expansion won't come easy
Amazon would like to strengthen its global footprint, but the e-commerce giant faces roadblocks and challenges today that did not...

SearchContentManagement

Compare SharePoint 2019 vs. SharePoint Online
SharePoint 2019 and SharePoint Online have different customization capabilities, payment models and more. Organizations must ...
6 information governance best practices
An information governance plan ensures that an organization's content lifecycle meets compliance and business needs. Best ...
5 examples of document version control
Document version control can help organizations improve their content management strategies if they choose the right approach, ...

SearchOracle

With Cerner, Oracle Cloud Infrastructure gets a boost
Oracle plans to acquire Cerner in a deal valued at about $30B. The second-largest EHR vendor in the U.S. could inject new life ...
Supreme Court sides with Google in Oracle API copyright suit
The Supreme Court ruled 6-2 that Java APIs used in Android phones are not subject to American copyright law, ending a ...
Oracle Autonomous Database shifts IT focus to strategic planning
This handbook looks at what Oracle Autonomous Database offers to Oracle users and issues that organizations should consider ...

SearchSAP

SAP Sapphire focuses on speed, disruption, sustainability
At SAP Sapphire 2022, the ERP vendor highlighted accelerating business transformation, disruptions to supply chains and ...
SAP Sapphire Now 2022 news, trends and analysis
The user conference puts sustainability and the supply chain front and center, along with SAP's continued quest to attract users ...
SAP Sapphire returns as a scaled-down live event
SAP Sapphire 2022 is back with an in-person and virtual program. Rise with SAP will be a hot topic, but SAP also needs to focus ...

SearchSQLServer

Five third-party SQL Server schema comparison tools
Over the years, many third-party schema comparison tools have popped up to support SQL Server.
Leveraging Microsoft Azure security features for PaaS security
In the case of Azure, Microsoft’s numerous development-focused security resources are fantastic but what if the application is ...
Microsoft aims high and low with SQL Server 2012
Microsoft’s recent efforts with SQL Server have been focused as much on re-engineering it for the Azure cloud as on enhancing the...

Close