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 https://msdn.microsoft.com/library/mt734203(v=sql.1).aspx
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.
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 https://blogs.technet.microsoft.com/dataplatforminsider/2016/06/09/wideworldimporters-the-new-sql-server-sample-database/
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 https://msdn.microsoft.com/en-us/library/mt238290.aspx) for this to work. The azure import data-tier will not work with older versions of management studio.