Home > Link, Microsoft SQL Server, Query, SQL, SQL Mentalist, SQL Query, SQL Server 2014, SQL Tricks, Technology,, Vishal Pawar, ZeroToBasic > SQL Server 2014 : Expert Views, Comments : Mr Farlee, Redmond, Eron Kelly, Quentin Clark & Cherry message

SQL Server 2014 : Expert Views, Comments : Mr Farlee, Redmond, Eron Kelly, Quentin Clark & Cherry message

Hi Geeks ,image

I just had one blog on SQL Server 2014 , Day on which SQL Server 2014 reveled.

My last blog post link on SQL Server : Introducing SQL Server 2014 – Unlocking Real, Time Insights !!

In this article we are going to cover all experts saying , Comments and views from different experience people from Microsoft and Other big company.

I have covered following experts views in this article :

    • Redmond
    • Denny Cherry
    • Eron Kelly
    • Mr Farlee
    • Quentin Clark

Redmond had already said last fall that in-memory would be a feature of the next version and previewed it during the Professional Association for SQL Server (PASS) Summit in Seattle under the codename “Hekaton.” What’s new this week is Microsoft’s announcement of the release date.

For those companies who have applications that are having specific locking and blocking issues on the super high I/O systems, the in-memory OLTP features that that we know as Hekaton are going to be an amazing feature to look at,” said Denny Cherry, a senior database administrator and independent SQL Server consultant.

Cherry did say that some code changes will be necessary to get the most out of the in-memory feature of SQL Server 2014, but the greatest benefit is that it comes as part of the normal SQL Server database engine.

“Because we already know how to manage and program for SQL Server, we can handle working with Hekaton automatically,” he said.

Cherry added that in the past Microsoft has announced database features years before users could actually get their hands on them. That isn’t the case with SQL Server 2014, with a preview due out this month. He said that companies can immediately start targeting their development efforts “to where they need them the most.”

Eron Kelly, Microsoft SQL Server general manager, said that tests in labs have shown a 50x improvement in some cases when moving transaction processing into memory. Kelly said the feature will be an optional setting for database administrators, who can choose which database instances or tables to put into memory. He added that there will be a diagnostic tool that will suggest which databases and tables are the best candidates to run in-memory. That granularity is something that Kelly said differentiates it from other in-memory databases.

“You can move those five tables in memory,” he said. “Now they go in memory and others can run on disk. You don’t have to buy high-end boxes. That’s the biggest difference between this and something like SAP HANA. You can choose which tables go in-memory and run it all on the hardware you have today.”

Kelly added that the “Hekaton” codename will fade, and that it will be referred to as the SQL Server In-Memory OLTP Engine.

Kelly cited another feature in SQL Server 2014 that will allow quick database backup to SQL Azure, which is now called Windows Azure SQL Database. He said that with SQL Server 2014, DBAs will be able to right-click in SQL Server Management Studio and create secondary and tertiary database backups in Azure for disaster recovery.

Finally, Kelly said that SQL Server 2014 will have a storage management feature that will allow DBAs to put some databases on solid state disks (SSDs) for active data, and then put others on traditional disks if they contain “cold” data.

Commenting on transaction completion, Mr Farlee said: “When you amend a row in Hekaton, you create a new version in memory.

“When no transactions need to reference the old version, we reclaim the memory. Nothing can stop a Hekaton transaction.”

According to Microsoft, employing the Hekaton database engine can result in jaw-dropping performance gains, with Microsoft’s Janie Chang claiming that Microsoft Partner bwin managed to see transaction throughput increased by a factor of 10. During the Microsoft TechED 2013 keynote address, Clark said that the Hekaton in-memory OLTP would ship as standard with SQL Server 2014.

Improved Azure Integration

A major theme of Microsoft products being updated at TechEd 2013 has been improved cloud integration, and SQL Server 2014 is no exception. According to Clark, this new release will include simplified and enhanced tools to support the migration of workload to Windows Azure virtual machines, as well as streamlined and simplified backup and recovery of database to cloud services.

Other features of SQL Server 2014

    • While the in-memory capability is the biggest feature of SQL Server 2014, a couple of others are worth noting.
    • SQL Server 2014 doesn’t require expensive hardware like other in-memory databases, according to Microsoft.
    • First is that the column-store indexes feature of SQL Server, called xVelocity ColumnStore, will allow continuous loading of data.
    • Column-store indexes can speed up query times by storing columns in a different way than traditional indexes, which basically allows SQL Server to compress the data in the index.
    • With SQL Server 2014, DBAs will be able to load and delete data in existing column-store indexes.

Also additionally SQL Server 2014, due out late this year, has an in-memory capability for online transaction processing (OLTP) with table-level granularity

Hope you will like Expert Views, Comments : Mr Farlee, Redmond, Eron Kelly & Cherry message for SQL Server 2014

If you really like reading my blog and understood at least few thing then please don’t forget to subscribe my blog.

SQL Server Mentalist >> SQL Learning Blog

Business Intelligence Mentalist >> BI World

Infographic Mentalist >> Image worth explaining thousand Words

Microsoft Mentalist >> MVC,ASP.NET, WCF & LinQ

DBA Mentalist >>Advance SQL Server Blog

Microsoft BI Mentalist >> MS BI Development Update

Connect With me on

| FaceBook |Twitter | linkedIn| Google+ | WordPress | RSS |

Advertisements
  1. No comments yet.
  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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: