Huge HA and indexing improvements top the list of great new features in Microsoft's latest database release
As we've come to expect from new SQL Server releases, SQL Server 2012 has so many new features that it's impossible even to mention them all. Nearly everyone is well served, from the BI-hungry users of Reporting Services to the IT folks who oversee query performance and uptime. SQL Server 2012 brings improvements across the board, with only a few disappointing exceptions.
Reporting Services adds a Web front end for data exploration and visualization called Power View. Analysis Services introduces a new semantic model, giving BI specialists more flexibility in building solutions. New column store indexing shifts query performance into high gear, while new Data Quality Services and improvements to Master Data Services round out the tools for taking care of company data.
[ Windows 8 is coming, and InfoWorld can help you get ready with the Windows 8 Deep Dive PDF special report, which explains Microsoft's bold new direction for Windows, the new Metro interface for tablet and desktop apps, the transition from Windows 7, and more. | Stay abreast of key Microsoft technologies in our Technology: Microsoft newsletter. ]
Of course, SQL Server 2012 also has a slew of new features that hit DBAs right where they live. I'll focus on these in this review, starting with some new capabilities that take high availability to a new level.
Higher high availability
Let's start with one of the largest efforts for this release, AlwaysOn. AlwaysOn is the new HA technology that will put database mirroring on the deprecation list. Being limited to a single target server for a mirror has been a nuisance since mirroring was implemented. Also, mirroring targets are completely useless until your primary database goes down, because they can't even be read from. AlwaysOn fills in both of these holes. You can easily configure many read-only copies of your primary database and use them for reporting while you're waiting for a disaster. And of course just like mirroring, you can set an AlwaysOn target to be completely synchronous with the primary or allow it to lag a little behind.
|Test Center Scorecard|
|Microsoft SQL Server 2012||10||9||10||9||9|
Windows 7 is suddenly telling users it isn't genuine -- and it has nothing to do with Windows being...
Windows users are reporting significant problems with four more October Black Tuesday patches
The larger design is very welcome, but there's much more to the iPhone 6 than a bigger screen
Sponsored by Rackspace
Sponsored by Nuage Networks
Sponsored by Fibre Channel Industry Association
The end of typing as we know it may be a gesture, a blink, or a thought away
Surface Pro 3 is relatively glitch-free after its 10th firmware update, released last week, resolved...
As these examples of well-known applications show, the source code behind proprietary software doesn’t...
Pretenders to the messaging throne have been many, but email still reigns. Here’s how that might change...