Using Failover Cluster Instance (FCI) for local high availability within a data center and augmenting it with Database Mirroring (DBM) for disaster recovery has been a very popular HA+DR solution. With SQL Server 2012, this FCI+DBM solution can be replaced with a FCI+AG (Availability Groups) solution. This whitepaper describes how to migrate an existing FCI+DBM solution to a FCI+AG solution.
SQL Server Failover Clustering, which includes support for both local and multisite failover configurations, is part of the SQL Server 2012 AlwaysOn implementation suite, designed to provide high availability and disaster recovery for SQL Server. The multisite failover clustering technology has been enhanced significantly in SQL Server 2012. The multisite failover cluster architecture, enhancements in SQL Server 2012 to the technology, and some best practices to help with deployment of the technology are the primary focus of this paper.
This white paper describes how business intelligence developers can apply query and processing performance-tuning techniques to their Microsoft SQL Server 2008 R2 Analysis Services OLAP solutions.
The new spatial features in SQL Server Code-Named “Denali” represent a significant milestone in the evolution of SQL Server spatial data support. New features include support for full globe spatial objects and circular arcs on the ellipsoid, industry firsts for relational database systems.
This white paper describes how operations engineers can test, monitor, capacity plan, and troubleshoot Microsoft SQL Server Analysis Services OLAP solutions in SQL Server 2005, SQL Server 2008, and SQL Server 2008 R2.