SQL Server Customer Advisory Team - SQL Server Best Practices

Features

SQL Server 2012 AlwaysOn: Multisite Failover Cluster Instance

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

Running SQL Server with Hyper-V Dynamic Memory - Best Practices and Considerations

By Mike Ruthruff

Memory is a critical resource to Microsoft SQL Server workloads, especially in a virtualized environment where resources are shared and contention for shared resources can lead to negative impact on the workload. Windows Server 2008 R2 SP1 introduced Hyper-V Dynamic Memory, which enables virtual machines to make more efficient use of physical memory resources....

New Spatial Features in SQL Server Code-Named “Denali” Community Technology Preview 3

By SpatialEd

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

Content

View all

1,361
views

1
comments
SQL Server 2012 AlwaysOn: Multisite Failover Cluster Instance
- Posted by Mike Weiner on 22 Dec 2011
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.
...
1,886
views

0
comments
SQL Server 2012 AlwaysOn High Availability and Disaster Recovery Design Patterns
- Posted by SanjayMishra on 22 Dec 2011
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.
...
273
views

0
comments
Considerations for Using Azure Data Sync
- Posted by sthoward on 21 Dec 2011
Author: Steve Howard Technical reviewers: Prem Mehra, Thomas Kejser, Shaun Tinline-Jones, Murshed Zaman, Praveen M, Sudhesh Suresh Azure Data Sync...
937
views

0
comments
Helping to make Hadoop easier by going Metro!
- Posted by sqlcat on 14 Dec 2011
We are proud to announce that the community technology preview (CTP) of Apache TM Hadoop TM -based Services for Windows Azure (or Hadoop on Azure) is now...
175
views

0
comments
Updated Spatial Features in the SQL Azure Q4 2011 Service Release
- Posted by SpatialEd on 13 Dec 2011
The Q2 2011 Service Release of SQL Azure introduced the updated spatial data platform from SQL Server 2012. SQL Server 2012 spatial features are being...