What's New in SQL Server 2012

- select the contributor at the end of the page -
In April 2012, Microsoft announced the release of SQL Server 2012.  A few months back, in the last quarter of 2011, Microsoft released SQL Server 2012 RC version, the release candidate Microsoft deems to be ready for production.

So what's new with SQL Server 2012?  Well, there are a lot of enhanced and new features in the SQL Server 2012 editions. But generally speaking, the following features make the 2012 edition a whole lot better than the previous versions.

  • Web Development and Business Intelligence Enhancements. While business intelligence features were upgraded in SQL Server 2008 R2, Microsoft really improved Excel PowerPivot by adding more drill and KPI through.
  • The Analysis Services will also sport a new feature: Business Intelligence Semantic Model, a three-layer standard that brings together data access, business logic and data model.  The new feature will entail a lot of improvement in the Reporting Services, SharePoint Insights and Excel.  The BISM centralizes all BI applications: reporting, analysis, scorecards and dashboards.
  • Master Data Services and SQL Server Data Quality Services are new or improved tools for data integration and management that deliver consistent, credible data at the right time.
  • SQL Server AlwaysOn. A high availability solution that increases application availability while also lowering total cost of ownership and making it easier to use.
  • A new web-based data presentation and visualization feature called Power View.  Power View, formerly known as Project Crescent, can help business owners and decision makers get better insights fast and easy.
  • The new SQL Server Data Tools bring together SQL Azure development and SQL server.
  • Better full text searching.

Don Jones' Top 3 SQL Server 2012 Features

The Benefits of Using or Upgrading to SQL Server 2012

New features, no matter how attractive they are, are no guarantee that an upgrade is necessary.  But SQL Server 2012 is an exception.

Using SQL Server makes sense financially, with the benefits outweighing the costs.  Not only that, it leads to higher productivity, cost savings and a better working environment for IT professionals in the enterprise.

A Forrester Research study commissioned by Microsoft reveals that SQL Server 2012 has a payback period of only about a year, with a risk adjusted return on investment of 149%.  What's more, cash flow from the use of SQL Server 2012 would be positive at Year 1 and all through the succeeding years.

ROI

The same study also highlighted the following benefits of using SQL Server 2012:

  1. Increased productivity for systems engineers and database administrators due to time savings, better security and higher data quality.
  2. Increased productivity for application developers due to higher availability, improved workflow, and also due to the improvements incorporated with the new SQL Server.
  3. Savings from service level agreement penalties brought about by data loss or outages.  This is also a good way to protect the business' reputation.
  4. Self-service business intelligence and very powerful business intelligence reports.

Available Editions

There are currently three main flavors of SQL Server 2012:

  • Enterprise
  • Business Intelligence
  • Standard

The Enterprise Edition is perfect if you use SQL Server 2012 for mission critical apps and data warehousing.  This edition allows you to run demanding application workloads fast, easily and securely.

This means that Big Data does not have to be a headache.

The AlwaysOn feature allows your server to be available and accessible when needed.  What's more, you get a lot of free tools and service offerings.

The Business Intelligence Edition gives you the ability to have self-service business intelligence, because it allows you to:

  • Visualize and explore data at lightning speed.
  • Transform business intelligence applications created by end users into IT-managed solutions.
  • Deploy or create scalable analytics and reporting.
  • Get consistent and credible data.

The Standard Edition is for those companies that do not need to run, store or manage big data in their servers.  With the Standard Edition, you get basic features for reporting, analytics and database capabilities.

A quick comparison on the features of these three editions:

SQL Edition Comparison

FeaturesEnterpriseBIStandard
Maximum Number of CoresOS Max16 Cores for DB OS Max-AS&RS

16 Cores
Basic OLTPxxx
Programmabilityxxx
Manageabilityxxx
Basic High Availabilityxxx
Basic Corporate BIxxx
Basic Data Integrationxxx
Self-Service Business Intelligencexx
Advanced Corporate BIxx
Enterprise Data Managementxx
Advanced Data Integrationx
Advanced Securityx
Data Warehousingx
Advanced High Availabilityx

Recommended Hardware and Software Specifications

Microsoft has come out with a list of specifications needed to install and run SQL Server 2012.

You would need:

  1. More than 3.6 gigabytes of free space on your hard drive.
  2. 64-bit:

    Intel Xeon (supported by Intel EM64T), AMD Athlon 64, AMD Opteron, or Intel Pentium IV (supported by EM64T with at least 2.0 GHz)

  3. 32-bit

    Compatible with Pentium III (at least 2.0 GHz)

  4. Recommended RAM: At least 2 gigabytes or whatever is the highest supported.

Software you need to install before installing SQL Server 2012

Other tips:

  1. Use NTFS file system.

    While SQL Server 2012 works on FAT32 systems, for this application it is not recommended.  You should also avoid compressed or mapped drives.

  2. Install the no-reboot package from Microsoft.

    This is typically bundled in with Windows 7 SP1, but you can download the package here: http://go.microsoft.com/fwlink/?LinkId=198092.

Interested in trying out SQL Server 2012?  Then be sure to check out the release notes for some installation instructions and tips from Microsoft itself.

Get the Free SQL Server 2012 e-Book

Microsoft has created a document that aims to walk you through the several features of SQL Server 2012 along with a comprehensive discussion on new features and enhancements for this version, as well as discussion on tools that are no longer available.

Download the e-book.

Get our content first. In your inbox.

Loading form...

If this message remains, it may be due to cookies being disabled or to an ad blocker.

Contributor

Michael Gabriel Sumastre

Michael Gabriel Sumastre is a skilled technical blogger and writer with more than seven years of professional experience in Web content creation, SEO and research paper writing. He has written more than a thousand articles related to tech and gadgets, cloud computing, IT management, SEO, SEM and software solutions. He ghostwrites books / e-books and has a Bachelor of Science degree in computer science. Michael is also an expert in webmastering and loves to ride his sportsbike. He maintains his portfolio and personal blog at TheFinestWriter.com