Recently we had the opportunity to help a valued customer in a SQL Server refresh project. Their aging SQL Server infrastructure was a mix of SQL Server 2000 and 2005 and was spread across their private cloud in a way that was difficult to manage and did not maximize the HA capabilities of their VMware vSphere environment.

After performing a deep analysis of their current SQL Server deployment and conducting meetings with their key project stakeholders we added 2 additional business requirements that were secondary to the need for a modernization of the environment:
<ul>
	<li>Deploy redundancy through Microsoft SQL Server Clustering or Microsoft SQL Server Database Mirroring</li>
	<li>Utilize the capabilities of their existing Citrix NetScaler physical appliances to improve the performance and manageability of their SQL Server infrastructure.</li>
</ul>
Given those requirements and available licensing we settled on a 3-way SQL Server setup using high-safety mode with automatic failover along with the latest and greatest feature available on the Citrix NetScaler platform, DataStream.
<div>Read on to learn about how we leveraged these proven technologies to position our customer for success!</div>
<div><!--more--></div>