Goodbye AdventureWorks!

Well it’s time to say Goodbye AdventureWorks!

With the recent release of SQL Server 2016 the team have also upgraded the sample database.

Our long standing and familiar AdventureWorks, which has been around since SQL Server 2005, has finally been replaced with a new shiny WideWorldImporters sample database.

The new sample database, WideWorldImporters, uses a lot of the new features available, for example:

  • Temporal tables
  • JSON
  • In-Memory OLTP
  • GZip compression
  • Query Store

This is not a complete list of all the features, which can be found at

Clustered Columnstore Index

It looks like an excellent, and long coming, upgrade which should enable us to experiment with the newer technologies faster and therefore drive faster adoption.

Temporal Tables

It’s worth poiting out from the comments that they aren’t removing AdventureWorks and any existing studies can be done with the AdventureWorks database on SQL Server 2016. But the comments imply you say Goodbye AdventureWorks!

As you develop new work, please transition to creating samples based on WideWorldImporters.”

The full post is here

Thanks for reading!


Update: I’ve had a few questions and it’s worth pointing out that you need the new SQL Server management studio (available here for this to work. The azure import data-tier will not work with older versions of management studio.

Goodbye AdventureWorks!

Leave a Reply

Your email address will not be published. Required fields are marked *

Pin It on Pinterest