Microsoft SQL Server 2014 boosts Big and Fast Data stakes

Microsoft SQL Server 2014 boosts Big and Fast Data stakes

Microsoft SQL Server 2014 boosts Big and Fast Data stakes

0 comments 📅24 July 2016, 02:45

Microsoft SQL Server 2014 boosts Big and Fast Data stakes

Although Microsoft’s announcement of SQL Server 2014 transported couple of surprises, the approaching release reaffirms their decision to help make the platform more scalable, extensible, and secure. Highlights incorporated incorporation of formerly introduced technologies like the Hekaton in-memory OLTP engine and also the columnar indexes from the Parallel Data Warehouse Appliance, that are available these days within the core platform. It’s also boosting “always-on” integration and harmonization of tooling using the Azure cloud, included in a “cloud-first” strategy that Microsoft has become baking into forthcoming releases of their server and tooling portfolio. By themselves, these moves are hardly unique among database platform providers, but together they’re evidence that Microsoft isn’t simply keeping SQL Server 2014 as good as enterprise data platforms, but doing this in a fashion that stays faithful to the roots being an accessible platform.

Building steadily from the ground up

Present with all Microsoft’s server and tooling platforms is really a technology base that came from with small-midsize businesses which has continuously added scale and sturdiness for enterprise deployments. As a result a core strength of Microsoft’s platforms is they are highly accessible, from management tooling that’s made with simple, intuitive connects, to convenience with the desktop tools which are ubiquitous among most businesses. For example, Microsoft Stand out is perhaps the world’s most widely used BI tool what it really lacks in extended query functionality, it greater than comprises for having a package that’s very familiar.

Microsoft has continuously developed the SQL Server platform through the years, presenting features for example compression, policy-based management, and PowerPivot data mashups within the 2008 generation, adopted by always-on, cloud connectivity, and columnar indexes within the 2012 releases.

With SQL Server 2014, the in-memory xVelocity OLAP tool, which has been around since the prior generation, is supplemented by Hekaton, the initial codename to have an in-memory choice for OLTP and new choices for buffer using Flash (solid condition drive, or “SSD”) storage. Towards the SQL Server base, such features are hardly surprises Microsoft has offered previews or public forums which have prepared the way in which for introduction of those technologies.

SQL Server evolving multiple personalities

An increasing trend among data platforms is they are presuming multiple personas. Faster, cheaper hardware whatsoever levels – multicore processors, faster interconnect busses (e.g., 1 and 10Gbit Ethernet), and ongoing declines in processes of plastic-based storage (e.g., DRAM and Flash) – are allowing for data platforms to include speed and scale with the addition of multiple engines that exist together alongside. For example, the majority of Microsoft’s rivals are or are while delivering platforms that permit row- and column-stores to exist in exactly the same instance. Consequently, the majority are also being designed to straddle on-premises and also the cloud without a general change in architecture. And many are earning peace with Hadoop through different schemes for connectivity and integration.

SQL Server 2014 makes an industry where such features are generally being introduced or are enroute to becoming commonplace. For Microsoft clients, it’s the assurance that, as the platform remains faithful to the roots like a simple platform, it will likely be feature-as good as DB2, Oracle, as well as in the analytics space, Teradata.

And thus, SQL Server 2014 still supports row-based tables, but additionally grows on using columnar indexes introduced with Parallel Data Warehouse (PDW), a specialized configuration which was launched being an appliance for SQL Server 2012. Particularly, it’s added support for that updatable column store. And integrating with HDInsight, Microsoft’s OEM from the Hortonworks Data Platform (HDP), Microsoft plays up a core strength in supplying use of Big Data – through the well-known Stand out spreadsheet.

In-memory keeps up with the Joneses

Similarly, the brand new edition also adds in-memory choices for OLTP that sit alongside disk-based tables. The concept isn’t unique to Microsoft all of its data platform rivals has such methods, may it be SAP’s all in-memory HANA platform or choices from IBM, Oracle, and Teradata, which strongly promote a memory tier alongside disk (also is Microsoft’s approach). Microsoft’s technology, which came from with Hekaton, promotes OLTP. It requires a strategy that’s becoming more popular with lots of Advanced SQL OLTP gamers for example NuoDB: employing “optimistic locking” processes that eliminate database locks (a significant reason for bottlenecks) by depending on logging to identify the newest form of data. Microsoft’s in-memory OLTP engine will are perfect for stored methods because this kind of architecture enables both logic and also the data to benefit from memory, also it can be utilized directly while using PowerPivot Stand out interface.

A positive change in Microsoft’s approach may be the built-in synergies using the underlying Home windows Server platform. While SQL Server 2014 strongly utilizes memory having a no-lock approach, Home windows Server 2012 R2 is presenting more complex data tiering that instantly senses data temperature (e.g., “hot” commonly used data versus “warm” or “cold” data that’s progressively less utilized) in apportioning data to various areas of disk and/or memory. Clearly, the interplay of SQL Server with Home windows is really a unique differentiator for Microsoft however, the interplay from the OS and knowledge tiers implies that clients must try not to enter guidelines or rules in Home windows Server that may otherwise deprecate data meant for in-memory OLTP processing to reduce-tier storage.

Availability and cloud support

The enhancements here were incremental. SQL Server 2014 develops around the always-on abilities from the 2012 version by growing the amount of secondaries. It enables more flexible storage virtualization by pools that actually work in collaboration with the brand new tiering abilities of Home windows Server. And, to facilitate compliance, SQL Server 2014 enables a larger separation of responsibilities, which enables DBAs to handle teams of data without really seeing the contents. For cloud and reliability, the brand new version develops in support for backup towards the Home windows Azure cloud.

 

Share this article:

No Comments

No Comments Yet!

You can be first one to write a comment

Leave a comment