From the Blogosphere
Introduction to SQL Server 2012
The new and advanced features
By: Hovhannes Avoyan
May. 10, 2012 07:30 AM
In our previous article, SQL Server 2008 Overview, we looked over the different features that the Microsoft SQL Server provides. In this article we will focus on the new and advanced features of the latest SQL Server release – SQL Server 2012. They include, but are not limited to, the new High Availability solution AlwaysOn, improved security, and the capability of syncing with the cloud.
AlwaysOn consists of two main components – AlwaysOn Availability Groups and AlwaysOn Failover Cluster Instances. Let’s first focus on the Availability Groups. An availability group is a combination of databases that are hosted on a primary server and up to four secondary servers. Each availability group member is capable of replying to clients’ requests in the event that the primary group member is unavailable. All the databases in an availability group fail over to another group member together. This functionality is built on top of the Windows Server Failover Clustering feature and requires its installation.
The high availability of the SQL server can be further enhanced by using Failover Cluster Instances (FCI). However, this approach requires shared storage. Shared storage is not required for the AlwaysOn Availability Groups. The servers in an availability group are required to have shared storage only if they are also acting as FCI. Be aware that AlwaysOn Availability groups automatically failover to a different replica when a problem with primary one is detected. This automatic failover is not supported in FCI, so you will have to set the availability group members acting as FCI to manual failover.
Another service Microsoft offers for high availability of your SQL databases is SQL Azure Data Sync. It allows you to easily sync your on-premise SQL Server 2012 with your SQL Azure’s data. That’s why SQL Server 2012 is considered a cloud-ready application. Furthermore, it gives you the ability to specify exactly which columns you want to be synchronized. It is a full implementation of a service and there is no need for you to write extra code for this synchronization to occur. You can use it within your Disaster Recovery plan so that you will have a complete copy of your on-premise database on a different physical location.
Let’s now focus on the new features that SQL Server 2012 brings to the main SQL features:
1) Analysis Services
2) Reporting Services
3) Integration Services
You can use all of these new features with SQL Server 2012. The editions basically remain the same as with SQL Server 2008 with the addition of SQL Server 2012 Business Intelligence. This is a customized version of SQL Server that provides a platform for building and deploying business intelligence solutions in the most secure and scalable way. All the supported features that an SQL Server 2012 edition offers can be found and compared here: http://technet.microsoft.com/library/cc645993(SQL.110).aspx
Latest Cloud Developer Stories
Subscribe to the World's Most Powerful Newsletters
Subscribe to Our Rss Feeds & Get Your SYS-CON News Live!
SYS-CON Featured Whitepapers
Most Read This Week