SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, Windows Phone 8 app development, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software SQL Server and T-SQL Development Tutorials
Development resources, articles, tutorials, code samples and tools and downloads for ASP.Net, SQL Server, R Script, Windows, Windows Phone, AWS, SAP HANA and ABAP, like SAP UI5, Screen Personas, etc.

Software Development

SQL Server 2014 and Big Data approach from Microsoft

Microsoft has announced SQL Server 2014 during TechEd at the beginning of this month. And before the end of month comes, Microsoft has released the first public preview of SQL Server 2014, Community Preview 1 aka CTP1.

And what will be the most attractive enhancements for data professionals is in-memory OLTP enhancements in SQL Server 2014 database engine. This performance boost is delivered as an output of the project Hekaton which is developed with Microsoft Research

Why in-memory OLTP can be considered as most important feature of SQL Server 2014? Because in-memory OLTP objects will provide 10 to 60 times performance improvements without any code or application change.

Besides in-memory OLTP feature, SQL Server 2014 introduces Clustered ColumnStore which is one step ahead of ColumnStore index which was first introduced to SQL Server developers and Data Warehouse developers with SQL Server 2012.

SQL Server 2014 will enable database administrators to integrate solid-state storage (SSD) into SQL Server easily without interrupting database execution to increase performance and minimizing Disk IO

All these performance increase with Hadoop Connectivity will make SQL Server 2014 database engine a data platform for enterprises to deal with Big Data.

Go and download your free evaluation copy of SQL Server 2014 to see what is new in SQL Server 2014 for you.


No Comments
Anonymous comments are disabled

About eralper

SQL Server administrator and T-SQL developer including BI components Web programming with HTML, HTML5 and ASP, ASP.NET and .NET Framework developer SAP ABAP and SAPUI5 development, Web Dynpro and Smart Form Siemens HiPath Center CTI development
Copyright © 2004 - 2020 Eralper YILMAZ. All rights reserved.
Community Server by Telligent Systems