SQL Server 2012 New Features (Business Intelligence and T-SQL)


Microsoft have lifted the lid on SQL Server 2012 - you can grab Release Candidate Zero here.

On top of the under-the-bonnet performance enhancements that you'd expect, Microsoft have bundled a wealth of new features, not least in the ever-expanding Business Intelligence arena.

Microsoft's SQL Server 2012 RC0 logo

Some of the key Business Intelligence new features to look out for:

  • PowerPivot enhancements in SQL Server 2012
    • PowerPivot for Excel (SQL Server 2012)
    • New DAX Functions
    • Catchily titled "
      PowerShell for PowerPivot for SharePoint"
  • Major improvements to Tabular Modelling
    • AMO and XMLA Extensions
    • Designer Diagram View
    • Security Roles
    • Key Performance Indicators
    • DirectQuery Mode
    • Memory Paging
  • SQL Server 2012 Business Intelligence Semantic Model (BISM)
  • PowerView (previously codenamed "Project Crescent) - Mobile Reporting / BI Dashboard solutions
  • SQL Server Data Tools (SSDT) integration with Visual Studio 2010

Other improvements to SQL Server include some new additions to T-SQL, and "AlwaysOn" High Availability & Disaster Recovery.

We'll be covering some of the key new features of SQL Server 2012 in our respective SQL Server Programming Training Course and our Intro to Microsoft Business Intelligence and Expert Microsoft Business Intelligence training courses.

Because SQL Server 2012 is still in pre-release, please note that features of the final product, and consequently our training courses, are liable to change.

Please feel free to get in touch if you have any questions about how we can help with your upgrade / transition to SQL Server 2012.


We would love to hear from you

Get in touch

or call us on 020 3137 3920