Product has been added to your cart.

Month: September 2012

The Trouble with Keys

Jeremiah Peschka
Architecture
22 Comments
Scaling up is hard: big hardware gets expensive fast. Scaling out is equally difficult; interesting design problems creep in to scale out solutions. One of the more troublesome issues architects face when scaling out is the issue of distributing identity. It’s often advantageous for object identity to be unique and portable across all database instances…
Read More

Microsoft SQL Server 2012 Always On AGs at StackOverflow

Brent Ozar
Always On Availability Groups, SQL Server, Stack Overflow
25 Comments
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

SQL Gangnam Style

Brent Ozar
Licensing, SQL Server
3 Comments
South Korean musician Psy’s hilarious music video for Oppa Gangnam Style has been tearing up the charts: Sure, it’s catchy, but it turns out there’s a message behind it.  Gangnam is an absurdly wealthy area of South Korea, like America’s Beverly Hills meets The Hamptons meets Tokyo.  Just like anywhere else in the world, the…
Read More

The Case for Core

Jeremiah Peschka
SQL Server
19 Comments
SQL Server 2012 was the first version of SQL Server to support being installed on Windows Server Core Edition (Windows without a GUI to the rest of the world). With the impending release of Windows Server 2012 there are a lot of people who are excited about running SQL Server 2012 on Windows Server 2012…
Read More

Amazon Web Services Architect Training Recap

Brent Ozar
Amazon Web Services (AWS), Cloud Computing, SQL Server
6 Comments
Going into Amazon Web Services (AWS) architecture training last week, I expected to get whiteboard-level training for project planners, and it met expectations.  We spent time talking about how Amazon’s most popular services fit together and how they can be used to solve our business needs.  Nothing in the training itself was groundbreaking for me – I keep…
Read More

Email Templates for Recruiters and Questions

Brent Ozar
SQL Server
13 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

Where’s Your Company’s #SQLHelp Resource?

Brent Ozar
SQL Server
7 Comments
If you’re a SQL Server data professional on Twitter, you’ve probably seen the #SQLHelp hash tag.  Here’s how to use it: To get help with a short, to-the-point question, post it on Twitter with #SQLHelp in your tweet. Keep Twitter open for the next 15-30 minutes and respond quickly. To give help, set up a…
Read More