Breaking News! AdventureWorks abandoned for Katmai in favor of Northwind, pubs and…

In a striking change of direction, I’m happy to announce that AdventureWorks is being deprecated and abandoned for SQL Server 2008 samples in favor of long-time favorite databases of simple-minded data modelers: Northwind and pubs.

Also, I can gleefully announce, in the spirit of oversimplification, that work is underway on ports of the Oracle sample schemas named:

  • HR
  • OE
  • OC
  • PM
  • SH

The creatively-named Oracle sample schema IX "might" present a challenge for SQL Server; however, we’re going to give it a college try… for April Fools’ Day.


Seriously, though, one person out of billions of (conscious or unconscious) SQL Server users has formally asked us to [re]include Northwind and pubs in our Official Family of Sample Databases™:

Feedback: Include option for Northwind Database install with SQL Server 2005 and SQL Server 2008 (

Since nobody has voted for it (not even the original requestor), we can only assume that it was filed on Connect as an early April Fools’ joke.

[For the record, I hate April Fools’ Day, but I am trying to get into the spirit of the faux holiday.]