You’re going to screw up the database over time, and you’re going to want to start again – keep the original copy so you don’t have to download it again. Don’t extract the files directly into your SQL Server’s database directories – instead, extract them somewhere else first, and then move or copy them into the SQL Server’s database directories. (I use that for max compression to keep the downloads a little smaller.) The extract will have the database MDF, NDFs (additional data files), LDF, and a Readme.txt file. Because it’s so large, I only distribute it with BitTorrent, not direct download links.Īfter you download it, extract the. For my training classes: specialized copy as of 2018/06: 47GB torrent ( magnet.) Expands to a ~180GB SQL Server 2016 database with queries and indexes specific to my training classes.Because it’s so large, I only distribute it with BitTorrent, not direct download links. Large: current 430GB database as of 2022-06: 54GB torrent ( magnet.) Expands to a ~430GB SQL Server 2016 database.

I use this in my Fundamentals classes because it’s big enough that slow queries will actually be kinda slow. Expands to a ~50GB database called StackOverflow2013 with data from 2008 to 2013 data. Medium: 50GB database as of 2013: 10GB direct download, or torrent or magnet.If all you need is a quick, easy, friendly database for demos, and to follow along with code samples here on the blog, this is all you probably need. Expands to a ~10GB database called StackOverflow2010 with data from the years 2008 to 2010. Small: 10GB database as of 2010: 1GB direct download, or torrent or magnet.Plus, it’s open source and no charge for you – just choose your size: It’s easy to learn, has just a few easy-to-understand tables, and has real-world data distributions for numbers, dates, and strings. I use a Microsoft SQL Server version of the public Stack Overflow data export for my blog posts and training classes because it’s way more interesting than a lot of sample data sets out there.

Sql backup master crack