Home > SQL Server > SQL Server 2014 Features and Favorites – Your opinion

SQL Server 2014 Features and Favorites – Your opinion

Microsoft has released the new version of SQL Server on 1 April 2014. It is called SQL Server 2014 with two main highlights. The In-Memory OLTP and Azure (the cloud technology) integration.

We have been seeing a lot of features and technologies being added to SQL Server since the version 2005 and all these steps are towards the advancing database technologies and infrastructure. These are the collective features that has been added to SQL Server so far such as

Change Data Capture, Data compression, Backup Compression, Encrypted Backup, Resource Governor, Columnstore Indexes, , Master Data Management,  AlwaysOn high availability, etc for Database and Data warehouse  and SSIS and Data Quality Services for ETL,  SSRS for Reporting, Power Pivot, Power View, Power Query, Power Map and Mobile BI for Self Service BI and  Azure for cloud storage and other services.

In SQL Server 2014, we can see a notable enhancements and changes to the Database, Security and Business Intelligence (BI) platform and cloud integration. These are the main enhancements that we can excite about. They are:

  • In-Memory OLTP (New feature) – Highly scalable concurrency and lock free data structure.
  • AlwaysOn Availability Groups (enhancements) – Maximum number of secondary replicas is increased to 8 and Hybrid solution with Azure Replica.
  • Backup with Encryption – Supports AES 128, AES 192, AES 256, and Triple DES algorithm during backup.
  • SQL Server Managed Backup – with Windows Azure Blob storage service (since 2012 release)
  • Columnstore Indexes (enhancement) – Updatable, Viewable in Plan and compressible.
  • SSDT-BI for VS 2012 or 2013 (Updates)
  • Power View – it can be able access OLAP database.
  • Self-Service BI – Excel to data discovery, analysis, and visualization and Power BI for Office 365 for cloud based BI to share, collaborate, and access data and reports from anywhere with Microsoft Power BI App
  • SSRS and SSIS does not have changes in this release.

I feel excited about all the new features and enhancements in SQL Server 2014

How about you? Please share your comments about the features that you like the most.

Categories: SQL Server Tags:
  1. Gayan Kaushalya
    July 1, 2014 at 3:11 am

    This is a good read. I have compared BI capabilities of new SQL server with some other products. But I find WSO2 Business Rules Server as a light weight and more complete BI solution for SOA. WSO2 BRS is pluggable to any business process and you can integrate business rules written in Drools. Following article has an important use case: http://wso2.com/library/articles/2011/04/integrate-rules-soa/

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: