SQL Server 2012 AlwaysOn High Availability and Disaster Recovery Design Patterns

This is one of the popular blog posts on sqlcat.com. Reposting (with updated links) here after sqlcat.com is de-commissioned.   Author: Sanjay MishraContributors: Justin Erickson, Mike WeinerReviewers: Prem Mehra, Juergen Thomas, Steve Howard, Chuck Heinzelman, Jimmy May   SQL Server 2012 AlwaysOn provides flexible design choices for selecting an appropriate high availability and disaster recovery… Read more

SQL Server 2014 In-Memory OLTP discussions at PASS Summit 2013

Wow, what a great PASS Summit!  Great to see so many old friends and meet so many new ones! At PASS I had the opportunity to talk to a number of people about an exciting new feature we have in SQL Server 2014, In-Memory OLTP (codenamed “Hekaton”). We had some great discussions and got to… Read more

Forcing NUMA Node affinity for Analysis Services Tabular databases

In the whitepaper, Hardware Sizing a Tabular Solution, we made a reference to Analysis Services Tabular and Non Uniform Memory Access or NUMA. Specifically, Analysis Services Tabular mode is not NUMA Aware. SSAS Tabular mode runs in memory and will load any tabular models into memory on startup. Having the model loaded into memory is… Read more