SQL Server Customer Advisory Team - SQL Server Best Practices

Features

Migration Guide: Migrating to SQL Server 2012 Failover Clustering and Availability Groups from Prior Clustering and Mirroring Deployments

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....

Technical Reference Guides for Designing Mission-Critical Solutions using SQL Server are available

By sqlcat

The Technical Reference Guides for Designing Mission-Critical Solutions provide planning and architecture guidance for various mission-critical workloads deployed by users. These guides reflect the knowledge gained by the CAT team while working with customers on mission-critical deployments, many of these deployments being the result of deep customer engagements by the CAT organization....

SQL Server 2012 AlwaysOn: Multisite Failover Cluster Instance

By Mike Weiner

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...

SQL Server 2012 AlwaysOn High Availability and Disaster Recovery Design Patterns

By SanjayMishra

SQL Server 2012 AlwaysOn provides flexible design choices for selecting an appropriate high availability and disaster recovery solution for your application. This blog highlights the salient features of each of the design patterns....

Analysis Services 2008 R2 Performance Guide

By denny.lee

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....

Content

View all

405
views

0
comments
Fast Track: improving performance through correct LUN Mapping and Storage Enclosure configuration
- Posted by AlexeiK on 3 May 2012
Author: Alexei Khalyako Reviewers: Thomas Kejser, Marcel Franke (PM One); Kevin Cox; Erik Kraemer; Kun Cheng; Murshed Zaman; Chuck Heinzelman ...
282
views

0
comments
Always On Availability Group: Connection to readable secondary fails when login SIDs are different or missing
- Posted by sqlcat on 23 Apr 2012
When using ApplicationIntent=ReadOnly to access a readable secondary via the Availability Group Listener, the login SIDs have to be the same between primary...
372
views

0
comments
Tuning Spatial Point Data Queries in SQL Server 2012
- Posted by sqlcat on 17 Apr 2012
Written by : Ed Katibah, Milan Stojic, Michael Rys, Nicholas Dritsas Technical reviewers : Chuck Heinzelman Introduction : Spatial Point Data queries...
741
views

0
comments
Who is using AlwaysOn?
- Posted by SanjayMishra on 17 Apr 2012
Several customers are already running SQL Server 2012 AlwaysOn in production. You can find the case studies with some of these reference customers here...
2,540
views

1
comments
Migration Guide: Migrating to SQL Server 2012 Failover Clustering and Availability Groups from Prior Clustering and Mirroring Deployments
- Posted by SanjayMishra on 4 Apr 2012
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.
...