Stack Overflow Archives - Brent Ozar Unlimited®

A Presenter’s Guide to the Stack Overflow Database

August 17, 2018

The place that saves your job You present on SQL Server topics at user groups and conferences, and you’ve been wondering how to get started with the Stack Overflow public database. Here’s a quick list of things to know. For stable demos, use StackOverflow2010. This smaller 10GB database has data from the first years of…

New Stack Overflow Public Database Available (2018-06)

June 12, 2018

Brent Ozar

Stack Overflow

@Taryn and the kind folks at Stack Overflow publish their data export periodically with your questions, answers, comments, user info, and more. It’s available as an XML data dump, which I then take and import into SQL Server for teaching performance tuning. You can download the 38GB torrent (magnet), which gives you a series of 7Zip files…

Creating Basic Indexes on the Stack Overflow Public Database

September 7, 2017

Brent Ozar

Indexing, Stack Overflow

No Comments

My public SQL Server database copy of the Stack Overflow data dump only includes clustered indexes by default. I want to keep your database size as small as possible for quick downloading. But like any database – when you create it, should you add your own indexes to make queries go faster? The answer lies…

New Stack Overflow Public Database Available (2017-06)

July 6, 2017

Brent Ozar

Stack Overflow

Nick Craver and the kind folks at Stack Overflow publish their data export periodically with your questions, answers, comments, user info, and more. It’s available as an XML data dump, which I then take and import into SQL Server for teaching performance tuning. You can download the 16GB torrent (magnet), which gives you a series of 7Zip…

When Always On Isn’t: Handling Outages in Your Application

January 24, 2017

Brent Ozar

Always On Availability Groups, Stack Overflow

always on, availability groups, often on, stack overflow

Today’s brief Stack Overflow outage reminded me of something I’ve always wanted to blog about: Stack Overflow is in limp-home mode There’s a gray bar across the top that says, “This site is currently in read-only mode; we’ll return with full functionality soon.” That’s not a hidden feature of Always On Availability Groups. Rather, it’s a…

How to Download the Stack Overflow Database via BitTorrent

October 3, 2015

Brent Ozar

Stack Overflow

Time to make SQL Server demos a little more fun. Now you can download a torrent of the SQL Server database version of the Stack Overflow data dump. Large: current 312GB database as of 2018/12: 41GB torrent (magnet.) Expands to a ~323GB SQL Server 2008 database. Because it’s so large, we distribute it with BitTorrent – if…

Update on Stack Overflow’s Recovery Strategy with SQL Server 2014

November 18, 2013

Brent Ozar

Always On Availability Groups, Stack Overflow

always on, availability groups, stackoverflow

Back in 2009 (wow, seems like only yesterday!), I wrote about designing a recovery strategy for Stack Overflow. Back then, I wrote: With these answers in mind, Stack Overflow’s decisions not to do transaction log backups, offsite log shipping, database mirroring, and so on make good business sense. Us geeks in the crowd may not like it,…

Microsoft SQL Server 2012 Always On AGs at StackOverflow

September 24, 2012

Brent Ozar

Always On Availability Groups, SQL Server, Stack Overflow

always on, availability groups, stackoverflow

I recently finished helping the StackExchange team migrate their SQL Server 2008 infrastructure to SQL Server 2012. These servers power StackOverflow, DBA.StackExchange.com, the new AskPatents partnership with the US Patent and Trademark Office, and hundreds of other Q&A sites that together form one of the biggest web site networks. It’s one of the most visible…

StackOverflow VC, SQL Server, and Whuffie

May 5, 2010

Brent Ozar

Stack Overflow

Yesterday StackOverflow announced that they’d accepted $6 million in venture capital funding. Joel Spolsky held a quick public chat to discuss it, and there were some interesting questions from the audience. I’m going to paraphrase some of the questions and give my own answers. Q: Now that StackOverflow is going to be big, will they…

How to REALLY Compress Your SQL Server Backups

February 15, 2010

Brent Ozar

Backup and Recovery, Stack Overflow

StackOverflow’s database servers are hosted in a colo facility. They pay by the byte for transfer in and out of their servers, so it’s really crucial to compress the database backups as much as possible. The smaller the backups, the less they pay. They’re already using backup compression, but they wanted to explore more ways…

Designing a Recovery Strategy for StackOverflow

December 16, 2009

Brent Ozar

Backup and Recovery, Stack Overflow

When I design a backup & recovery strategy for a database, I don’t talk to the developers, database administrators, or systems administrators first. The first people I go to are the business managers, and I ask three questions: How much money would you lose if you lost the data altogether? How much money would you…

New StackOverflow database server coming

January 25, 2009

Brent Ozar

Stack Overflow

No Comments

SQL Server for StackOverflow Today, Jeff Atwood blogged about StackOverflow’s new SQL Server hardware: a Lenovo RD120, the artist formerly known as an IBM x346. Notice the big heart on the box. Servers run faster with love. Next, I’m aiming to do log shipping from the box pictured here over to Amazon S3. The StackOverflow…

StackOverflow’s SQL 2008 FTS issue solved

November 12, 2008

Brent Ozar

Stack Overflow

Whew – the Microsoft folks really came through on this one and tracked down the problem pretty quickly. I want to personally thank Denis Churin, Nikita Shamgunov and Sundaram Narayanan for their detailed investigation into the issue and helping us get it fixed. I’m going to explain the issue to help anybody else get through…

SQL 2008 upgrade & tuning for StackOverflow.com

October 27, 2008

Brent Ozar

Stack Overflow

stack overflow

I’ve mentioned Jeff Atwood of CodingHorror.com a few times over the years here, and it bears repeating: he writes a great blog for developers, and DBAs need to read it too. I also follow him on Twitter, and a couple of weeks ago he mentioned he was having problems deciphering execution plans: Holy cow –…

A little ninja work before breakfast

October 14, 2008

Brent Ozar

Stack Overflow

Mornings like this, I can’t believe I get paid to do this stuff: That’s Jeff Atwood of Coding Horror and Stack Overflow, whose blog I’ve been reading for years. I actually bought a t-shirt with his site’s logo way back in 2006. Jeff effing Atwood. If I saw him, I’d ask for his autograph on…