The Evolution of the Microsoft Data Platform

Take a look at how far Microsoft’s SQL Server has come since 2000 in honor of today’s release of SQL Server 2014.

The Evolution of Microsoft's SQL Server from 2000-2014

The Evolution of Microsoft’s SQL Server from 2000-2014

Click to view larger image

microsoft.com


Unitek Education Logo Update Your SQL Server Skills to Microsoft SQL Server 2014 

Unitek Education’s Updating Your SQL Server Skills to Microsoft SQL Server 2014 is a five-day instructor-led course that teaches students how to use the enhancements and new features  added to SQL Server and the Microsoft data platform since the release of SQL Server 2008. The course focuses on teaching individuals how to use SQL Server 2014 product features and other Microsoft data platform components.

Microsoft SQL Server 2014 Set to Release April 1st

Microsoft's SQL Server 2014 is the least vulnerable database five years in a row.

Microsoft’s SQL Server 2014 is ranked the least vulnerable database for the 5th year in a row.

Microsoft’ popular relational database management system SQL Server 2014 is set to be released on April 1, 2014 with substantial new features. For the fifth year in a row, SQL Server is the least vulnerable database, according to the National Institute of Standards and Technology. Microsoft claims SQL Server 2014 marks a breakthrough in data platform performance, citing mission critical performance, faster data insight, and its hybrid cloud integration.

 

Top 5 New Features in

SQL Server 2014

 

In-Memory OLTP Engine

The new In-Memory OLTP engine is the most important addition to SQL Server 2014. Microsoft claims in-memory allows for SQL Server performance that is up to thirty times faster than before. The new In-Memory OLTP engine improves performance by moving selected tables and stored procedures into memory, enabling faster query speeds. Most importantly, customers don’t need additional software or set-up to take advantage of the In-Memory OLTP.

Business Intelligence

Microsoft’s Power BI for Office 365 allows users to compare data from almost any source using familiar tools like Excel. Create a data model tailored to your needs with Excel Add-Ins PowerPivot, PowerView, and PowerMap. PowerPivot allows for the creation of BI data models, capable of handling more data storage than Excel worksheets. PowerView displays data visually from PowerPivot data models via graphs, charts, and maps. PowerMap creates three-dimensional maps of geographic and temporal data. Additionally, users can share data insights, collaborate with others, and access data anywhere in Office 365 via the cloud.

Backup Encryption

SQL Server 2014 includes backup encryption improvements. Previously, additional products were required to encrypt database backups. SQL Server 2014 enables users to encrypt database backups using a certificate or an asymmetric key. It is now possible to backup to Windows Azure storage using SQL Server 2014.

Windows Azure Integration

SQL Server 2014 allows users to reduce spending and protect their data by backing up information directly to Windows Azure. Windows Azure is ideal for backing up data because it is fundamentally offsite and georedundant while incurring minimal costs. Microsoft’s hybrid cloud enables users to move applications to the cloud at their discretion, as companies transition to more cloud storage.

AlwaysOn Enhancements

The AlwaysOn features are significantly enhanced with support for new usage types and large deployment scenarios. In SQL Server 2014, AlwaysOn integration supports up to eight secondary replicas, up from the previous four in SQL Server 2012. AlwaysOn features have also been integrated with Windows Azure. This new integration feature enables you to create availability group replicas in Windows Azure for disaster recovery. In the event of a local outage, you can run your SQL Server databases from the cloud. The new Windows Azure AlwaysOn availability options are fully integrated into SQL Server 2014.

microsoft.com


Unitek Education Logo  Update Your SQL Server Skills to Microsoft SQL Server 2014 

Unitek Education’s Updating Your SQL Server Skills to Microsoft SQL Server 2014 is a five-day instructor-led course that teaches students how to use the enhancements and new features  added to SQL Server and the Microsoft data platform since the release of SQL Server 2008. The course focuses on teaching individuals how to use SQL Server 2014 product features and other Microsoft data platform components.