My first encounter with SQL Server was on the pubs database, and it still sticks to me as “fun and easy”.īut if you try to find them, you need to download an MSI file that extracts the files to your local system. Those were small databases, that were still understandable for starters. In “Ye Olde Days” I worked with Pubs and Northwind. But for some examples I just want a smaller database. Nowadays Microsoft offers you the AdventureWorks database as extra download for all new versions of SQL Server. Normally I would create my own tables with sample data, but I want to give them the opportunity to repeat the demos again on their own.
At the end of my presentation, I wanted to show some demo queries. Last week I was working on a SQL Server presentation, to explain the basic of databases and how SQL Server works to a few colleagues.
