Recently there was lengthy discussion on the #sqlhelp hash tag on Twitter about clustering SQL Server on VMs and whether or not that was a good idea or not. Two years ago I first blogged about this same topic on my blog post, Some Thoughts on Clustering SQL Server Virtual Machines. If you haven’t read [...]
Jonathan Kehayias
The Rambling DBA
Clustering SQL Server on Virtual Machines (Round 2)
Posted on: November 29, 2012 1:38 pm
New features of ALTER SERVER CONFIGURATION in SQL Server 2012
Posted on: June 27, 2012 9:15 am
While working on a chapter I am writing, I was going through the ALTER SERVER CONFIGURATION topic in the Books Online and noticed some really useful changes in the syntax that I hadn’t seen before. Starting in SQL Server 2008 R2, ALTER SERVER CONFIGURATION was introduced to allow for process affinity configuration and to replace [...]
SQL Failover Cluster without Shared Storage – SQL Server 2012 and SMB
Posted on: March 20, 2012 1:32 am
While teaching last week at our Tampa Immersion Event, I mentioned the support for SMB as a storage in SQL Server 2012, which is allows you to create a Failover Cluster without shared storage on a SAN, and is documented in the following Books Online topics. Install SQL Server with SMB fileshare as a storage [...]
