The StackOverflow XML Data Dump was recently updated with 2016-03 data, so I've updated our torrent of the SQL Server database version of the Stack Overflow data dump.
Fun facts about the database and its real-world-ness:
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,…
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…
I get a lot of email, and I'm zealous about staying at Inbox Zero using the Getting Things Done productivity techniques. One of my favorite ways to handle email fast is by using templates, or as GMail calls them, Canned Responses. Email programs like Outlook let you set up multiple signatures, and I use those…
