Monthly Archives: May 2013

SQL Server 2012 AlwaysOn High Availability and Disaster Recovery Design Patterns


The following design patterns emerge as end-to-end HA+DR solution: Using Multi-site Failover Cluster Instance (FCI) for local high availability and disaster recovery solution Using Availability Groups (AG) for local high availability and disaster recovery solution Using Failover Cluster Instance (FCI) … Continue reading

Posted in SQL SERVER 2012 | Leave a comment

Not upgrading your hardware for SQL Server 2012


SQL Server 2012 does not support AWE. That means if you still have a 32-bit operating system and are currently using AWE in order to see beyond 4GB of RAM, if you upgrade to SQL 2012 you will be limited … Continue reading

Posted in SQL SERVER 2012 | Leave a comment

Key Learnings from Early Customer Deployments for SQL Server 2012


Windows Cluster Is the foundation for HA and DR in SQL Server 2012 AlwaysOn AlwaysOn inherits all “characteristics” of Windows Cluster Windows Cluster every single AlwaysOn deployment is a Windows Cluster deployment Windows Cluster understand Windows Cluster for succesfully deploy, … Continue reading

Posted in SQL SERVER 2012 | Tagged | Leave a comment

Quorum Considerations for SQL Server 2012


Quorum is managed by the WSFC, irrespective of the number of SQL Server instances (FCI or standalone), number of nodes, number of availability groups Important goal: Design to ensure Unavailability of the DR site, or loss of network connectivity between … Continue reading

Posted in SQL SERVER 2012 | Tagged | Leave a comment

SQL Server 2012 AlwaysOn HA+DR Design Patterns


Posted in SQL SERVER 2012 | Tagged | Leave a comment

Resources to Get started on Learning SQL SERVER 2012


I have been asked my so many people how to get started learning on SQL SERVER 2012. Last year when the product got released in April 2012, I have started by below links first, It needs so many hours of preparation … Continue reading

Posted in SQL SERVER 2012 | Tagged | Leave a comment

SQL SERVER 2012 Supported Upgrade Paths


You can’t simply upgrade from any edition of SQL Server to any other edition. Microsoft provides a set of supported upgrade paths. This is particularly important in SQL Server 2012 because the editions have been changed from the previous releases. For example, … Continue reading

Posted in SQL SERVER 2012 | Tagged | Leave a comment