SQL Server is Microsoft's flagship database management and analysis system and is tightly integrated with key Microsoft platforms such as SharePoint, Excel, Microsoft CRM, and Dynamics GP (Great Plains). Progent can provide the expertise of Microsoft-certified engineers as well as experienced application developers, database administrators, project managers, network architects, disaster recovery experts, and security specialists to help you derive the maximum business value from your deployment of SQL Server 2012.
SQL Server is Microsoft's top database management and analysis system and is tightly integrated with key Microsoft platforms such as SharePoint, Excel, CRM, and Dynamics GP (Great Plains). SQL Server 2012 has a broad range of features that offer major improvements in vital areas such as availability, security, performance, manageability, analytics, cloud readiness, scalability, collaboration, fast application development, and data discovery. SQL Server 2012 also consolidates the key editions of SQL Server from five to three, simplifying the selection of a version that fits your needs.
Progent can provide the expertise of Microsoft-certified engineers as well as experienced application developers, DBAs, DR/BC experts, network designers, and security specialists to help you evaluate the potential benefits of SQL Server 2012 for your business, set up pilot systems at your datacenter or at Progent's lab, plan and carry out a smooth migration to SQL Server 2012 either from prior releases of SQL Server or from other platforms, and design an efficient and secure environment that helps you maximize the business benefit of SQL Server 2012.
AlwaysOn High-Availability for SQL Server 2012
The headline innovation incorporated into SQL Server 2012 is Microsoft's AlwaysOn solution, which provides flexible and cost-effective system design options for insulating mission-critical application databases from downtime caused either by scheduled maintenance or network failures. Microsoft designed AlwaysOn to achieve or exceed the famous "five nines" availability, or 99.9999% uptime, which translates into just a few minutes of downtime per year.
AlwaysOn technology uses two enhancements in SQL Server 2012 to eliminate the inefficiencies of SQL Server 2008's Failover Clustering Instances (FCIs) for high availability (HA) and SQL Server 2008's database mirroring mechanism for disaster recovery (DR). For a more effective and affordable HADR solution, SQL 2012 includes AlwaysOn Failover Cluster Instances and the new AlwaysOn Availability Groups.
AlwaysOn Failover Clustering Instances support multi-subnet clustering across geographically dispersed sites, allowing you to deploy so-called Stretch Clusters. This architecture offers both a high level of availability as well as the basis for an advanced disaster recovery solution. SQL Server 2012's AlwaysOn FCI also improves failure detection and provides more flexibility for configuring an optimal failover policy. In addition, SQL Server 2012 has an option for indirect checkpoints as a viable alternative to automatic checkpoints. This new feature allows you to specify the maximum permissible downtime for a database so you can safely guarantee the recovery time of critical databases in case of a failover event.
AlwaysOn Availability Groups in SQL Server 2012 improve mirroring in SQL Server 2008 by allowing log-based data movement without shared disks and thereby enabling zero data loss in case of a fail over condition.
AlwaysOn Availability Groups improve database uptime as well as resource utilization by letting you define sets of user databases that fail over as a single logical unit and to create a set of primary and secondary availability replicas to host copies of each availability database. Availability Groups can have four secondary replicas and feature listeners for fast application failover over, automatic page repair to event page corruption, and the ability to force a Failover Clustering (WSFC) quorum. Secondary replicas can be used actively for read-intent applications and backup in order to improve hardware utilization.
For additional information about Progent's consulting support for Microsoft SQL Server 2012, see Progent's Support Services for SQL Server 2012.
Contact Progent about SQL Server 2012 Consulting Services
To find out more about Progent's consulting services for Microsoft SQL Server 2012, call Progent at 1-800-993-9400 or visit Contact Progent.
Click here to go to the table of contents of the IT Connection newsletter.