Earlier this week Microsoft has announced SQL Server 2014. The release date of Trial of SQL Server to be believed later this year.
Here are few of the improvements which I was looking forward are there in this release. Please note this is not the exhaustive list of the features of SQL Server 2014. This is the a quick note on the features which I was looking forward and now will be available in this release.
- Always On supports now 8 secondaries instead of 4
- Online Indexing at partition level – this is a good thing as now index rebuilding can be done at a partition level
- Statistics at the partition level – this will be a huge improvement in performance
- In-Memory OLTP works by providing in-application memory storage for the most often used tables in SQL Server. (Read More Here)
- Columnstore Index can be updated – I just can’t wait for this feature (Columnstore Index)
- Resource Governor can control IO along with CPU and Memory
- Increase performance by extending SQL Server in-memory buffer pool to SSDs
- Backup to Azure Storage
You can additionally download SQL Server 2014 Datasheet from here. Which is your favorite new feature of SQL Server 2014?
Reference:Â Pinal Dave (https://blog.sqlauthority.com)
16 Comments. Leave new
Thanks for the post Pinal.. Nice once with brief explanation..
Thanks Pinal for the updates
thankx for update………
Wow!!!, New version for SQL Server from Microsoft, I wonder why? I thought they just released SQL Server 2012, Did anyone started using 2012? Did anyone fully migrated their database to 2008 R2 yet ? I doubt.
SQL Server (Microsoft) is famous for its easy to use tools and products but with these frequent and mostly USELESS updates/version, they will soon loose man power who can support their USELESS products. Not every one can get hands on with their new products they release every 2-3 years.
I know, I am lazy to learn new versions but the pace with which Microsoft releases USELESS new version is uncalled for. I don’t think its really required.
SQL Server 2000 to 2005 was a major release, it would be worth to wait like 4-5 years and then have a big release instead of releasing some useless features which are only used by 0.00001% of the people in the market.
Pressure is built on the people who support these products in companies. Without any proper training on new versions, employers expect their support team to know all the features in new versions.
I will pass….
Agreed With Imran Mohammad… !!! They should wait for adoption of SQL Server 2012. We are still planning to move from SQL 2008 R2 to SQL 2012 and they are releasing 2014 !!!!
Completely agree with your point Imran. How will they compete with big players in the market if they dont introduce such new and hot features? It all depends on us how we take us to our clients and ofcourse newer versions of Sql server is not all new totally to use. I mainly look for more and more BI features from Sql server as they lag a lot with market competition.
I don’t agree.
they follow the trend imposed by other vendors on the market: releasing every 2 years.
if you don’t do this, your customers will go to the competitors because they release the feature they want, not you.
the IT guys has to change their mind by thinking its a “real major release” which required bunch of test etc… its not the right way to go.
in fact its more a feature release to enhance the capability of the engine.
by the way… today waiting 6month to use a new technology and you are too late to adopt it.
from business perspective, they don’t want to wait too, if today the trend is to use a tablet, they want to use it now, if the trend is the in memory system, they want it now.
personally I don’t want to wait 4 or 6 years to have a new feature which may help me, I want the feature as soon as possible to not loose my time on trying to create it.
If there is no good reason to NOT upgrade, then upgrade, you cant loose.
Completely agree with your point jerome! No one wants to wait 4 or 6 years to have a new feature which may help, I believe everyone want the feature as soon as possible to not loose time on trying to create it.
If there is no good reason to NOT upgrade, then upgrade, you cant loose.
I believe that Microsoft’s aim in releasing more versions of SQL Server faster is a way to get people to move their databases onto Azure, by frustrating the customers with constant change.
If the customer moves to Azure Microsoft will gladly manage the instances and keep them patched……for a price.
Microsoft isn’t going to provide you with the updates that you want in new versions of SQL for free. You the customer aren’t as important as the shareholders profits.
Hi Imran,
You are in luck! It appears that there is a database named Oracle. You can use it with data encoded with only 7 bits. It comes with a line editor. Users likes it because they can leave the caps lock key on permanently. The tools and language remain static and change very little in time.
I suspect this may become as SQL 2012 R2 …
… ?
Many Enterprises has a deadline of Windows XP migration, which in turn needs fixes to many aged applications.
Windows xp migration
Vs.net / Bids upgrade 2012
SQL 2012
TFS 2012
… so many need to be upgraded in an enterprise.
New version of SQL … Hmmm …
SQL Server are quite right to share the CTP for SQL Ser 2014. They issue a new version every three years. If you go back to the move from 2000 to 2005 this was a massive update and narrowed the gap between where SQL Server was in 2000 to the capabilities of Oracle. By pushing through updates in a controlled manner it has now passed Oracle and has become the product it should be. Each time I guess the amount of change should be less. Each new version along the way has been for a purpose and I hope each new version has been less painfull to implement.
Just my thoughts
I loaded SQLServer2014CTP1-x64-ENU file and want to install on my laptop which is clean and 64 bit. But this file does not give me option to install. If I double click gives me option only to open with Power2Go. How do I install SQL 2014 CTP1?
Thanks for the post Pinal.. Nice once with brief explanation..
Hey – do you know the 2014 support multi column partitioning ?
Thanks Pinal for introducing SQL 2014