Access "Pros and cons of SQL Server 2012"
This article is part of the May 2012, Vol. 10 issue of Should you upgrade to SQL Server 2012?
More on SQL Server 2012 Check out our SQL Server 2012 guide What you need to know about SQL Server 2012 Looking at column-store indexes in SQL Server 2012 Another even-numbered year brings another new version of SQL Server to consider. Microsoft has already doing a good job of communicating why it thinks you should upgrade, but their reasons are largely based on features. The other side to the upgrade story has less to do with features and more to do with your business. So let’s consider some of the non-feature-related pros and cons behind a SQL Server 2012 upgrade: Pro: Performance. Whether they advertise it a lot or not, Microsoft invests heavily in SQL Server’s core database engine in every new version. Back in the old days, a nine-table join was a recipe for disaster; now it’s no big deal. The same holds true for SQL Server 2012: You can expect better overall performance when compared side-by-side to older versions, and “better performance” is always a reason to consider an upgrade. Con: Changes. This new version of SQL Server brings some significant ... Access >>>
Premium Content for Free.
Pros and cons of SQL Server 2012
by Don Jones, Contributor
Performance and support top the lists of pros for going to SQL Server 2012. But application compatibility and “the unknown” might keep you away for now.
- Pros and cons of SQL Server 2012 by Don Jones, Contributor
Big data a big deal for SQL Server 2012, users say
by Alan Earls
SQL Server 2012 is here, and the Apache Hadoop integration is making the biggest wave, according to some users.
Microsoft’s SQL Server 2012 has muscle, but database battle is fierce
by Mark Fontecchio
One of the strongest versions Microsoft has put out in years, SQL Server 2012 first needs to accomplish a monumental task -- overcome database inertia, industry watchers say.
- Big data a big deal for SQL Server 2012, users say by Alan Earls
More Premium Content Accessible For Free
Today, business analytics is largely focused on self-service software and pushing business intelligence capabilities down to the end user. In this ...
These days, virtual servers are often seen as time- and money-saving efforts for businesses. When deciding if going virtual is the right thing to do,...
Microsoft has made a great effort to turn SQL Server into a viable enterprise database platform, and part of that has been boosting its business ...