stackoverflow

Updating the Stack Overflow Demo Database

SQL Server
1 Comment
StackOverflow.com shares your questions, answers, comments, votes, users, badges, etc by doing a public data dump that you can download via BitTorrent. I take that data, and I turn it into a SQL Server database that you can query. It’s so much better than the Microsoft sample databases because: It’s just a handful of easily-understood tables It has…
Read More

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

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,…
Read More

Microsoft SQL Server 2012 Always On AGs at 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…
Read More

Email Templates for Recruiters and Questions

SQL Server
12 Comments
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…
Read More
Menu