Select the search type
  • Site
  • Web

Microsoft SQL Server 2012 Top 5 Enhancements

Microsoft SQL Server 2012 is a cloud-friendly information platform that will help organizations and businesses transition to the inevitable future of cloud computing more affordable and sooner than we might have ever thought. The improvements to the database platform are long but here are the top five.   

5. Contained databases -- Contained databases make it easy to deploy new databases and to move databases between different SQL Server instances. Users of a contained database don't need logins for the SQL Server instance. Instead, all authentications are stored in the contained database. Contained databases have no configuration dependencies on the instance of SQL Server that they're hosted on.

4. Columnar index -- SQL Server 2012 adds columnar storage and efficient batch-at-a-time processing to the system. Columnar storage is exposed as a new index type: a column store index. In other words, in SQL Server 2012 an index can be stored either row-wise in a B-tree or column-wise in a column store index. SQL Server column store indexes are “pure” column stores, not a hybrid, because different columns are stored on entirely separate pages. This improves I/O performance and makes more efficient use of memory. Depending on the data, Microsoft states this technology can provide up to 10-100 times improvement in query performance with reduced I/O.

3. SQL Server Data Tools -- SQL Server Data Tools (SSDT) is a developer’s dreams come true. Using the Visual Studio 2010 shell developers can use model driven database development and debugging straight from Visual Studio.  Developers can use the SQL Server Object Explorer in Visual Studio to create or edit database objects and data,, or execute queries. SSDT can connect to SQL Server 2005 and later as well as to SQL Azure.

2. Power View – Power View is a completely Silverlight-based data visualization tool which allows users to interact with data. Since it’s deployed from SharePoint 2010 SP1 it does not require a client side installation. The extra compatibility allows users of the Apple family of devices to interact with the data like a normal windows user would. Extremely portable.

1. AlwaysOn Availability Groups -- The most important feature in the SQL Server 2012 release is the AlwaysOn Availability Groups functionality. It is essentially the next evolution in database mirroring. This is a huge step forward for businesses looking to use a cloud based DR solution. AlwaysOn Availability Groups make it possible to implement a highly available deployment strategy that can be used to survive sever outages. It supports up to four replicas and lets you mix and match synchronous and asynchronous connection. This means that the data in the replicas can be actively queried. 


iwc replica
Friday, May 31, 2013 1:49 AM
This post really opened my eyes. it is not only eye opening rather very beneficial for the people those who want to do something good in his life.
replica breitling
Friday, May 31, 2013 1:51 AM
This site is excellent and so is how the subject matter was explained. I also like some of the comments too.Waiting for next post.
Sunday, June 09, 2013 7:46 PM
We work together seroquel price without insurance processes of disposal processes of disposal disposal and processes of disposal disposal and
Womens Sandals
Tuesday, June 11, 2013 12:03 AM

When it comes to Womens Sandals there are many different styles and designs that give a completely different look. Under the heading of sandals there are many different types of shoe such as sport sandals, beach flip flops, heeled sandals and so on.Womens Sandals ,Here is a look at the top 7 Womens Sandals that are set to be hot this summer.

Post Comment

Only registered users may post comments.
Vigilant Hosting
Vigilant Technologies is a certified 8(a), Veteran
Owned company headquartered in Chandler, Arizona.
We provide products, services and enterprise-wide
integration of innovative IT solutions to commercial,
Federal, Stateand Local government clients. Our
Leading edge services include Private/Hybrid Cloud,
Server Consolidation, Virtualization implementation,
and Infrastructure Management.
Resources & Support
Help Center
Help Center
     Contact us
     Open a Ticket
News Room
Engage with us
(480) 722 - 1227
(888) 722 - 1227