Phone - Australia: 1300 553 313
Hotline - New Zealand: 0800 450 168

Microsoft SQL Server 2014

The foundation of Microsoft's comprehensive data platform, SQL Server delivers breakthrough performance for mission-critical applications, using in-memory technologies, faster insights from any data to any user in familiar tools like Excel, and a resilient platform for building, deploying, and managing solutions that span on-premises and cloud.

SQL Server 2014 makes it easier and more cost effective to build high-performance, mission-critical applications, enterprise ready Big Data assets, and BI solutions that help employees make better decisions, faster. These solutions have the flexibility of being deployed on premises, in the cloud or in a hybrid environment, and can be managed through a common and familiar tool set.

  • Mission-critical performance
    SQL Server 2014 accelerates reliable, mission critical applications with a new in-memory OLTP engine that can deliver on average 10x, and up to 30x transactional performance gains. For Data Warehousing, the new updatable in-memory columnstore can query 100x faster than legacy solutions. SQL Server also delivers peace of mind as the most secure database five years in a row. (National Institute of Standards and Technology Comprehensive Vulnerability Database 4/17/2013, Market share from IDC 2013)
  • Faster insights on any data
    Get to insights faster with a complete BI platform that speeds up how you access, analyze, clean and shape both internal and external data. With SQL Server 2014 and Power BI for Office 365, it is easy to connect every user in an organization to the right data they need to make better decisions, faster.
  • Platform for hybrid cloud
    SQL Server 2014 was designed to work in a hybrid environment that spans on-premises and the cloud and has new tools that make it even easier to build back-up and disaster recovery solutions with Microsoft Azure. These tools provide an easy on-ramp to the cloud for on-premises SQL Server databases, enabling customers to use their existing skills to take advantage of Microsoft’s global datacenters.


email Microsoft Volume Licensing

New Features of SQL Server 2014

In-memory processing built into SQL Server 2014 delivers breakthrough performance to accelerate your business and enable new, transformational scenarios that make you more competitive. Microsoft offers comprehensive in-memory technologies for OLTP, data warehousing, and analytics built directly into SQL Server, so there is no need to buy specialized hardware, expensive add-ons or learn new skills to speed your transactions, your queries and your insights.

In addition, SQL Server 2014 also provides new hybrid solutions for cloud backup and disaster recovery as well as takes advantage of new capabilities in Windows Server 2012 R2 to provide enterprise-class availability and scalability with predictable performance and reduced infrastructure costs. SQL Server 2014 also continues to offer industry leading business intelligence capabilities and integration with familiar tools like Excel for faster insights on your data.

In-Memory OLTP:
Provides in-memory OLTP capabilities built into core SQL Server database to significantly improve the transactional speed and throughput of your database application. In-Memory OLTP is installed with the SQL Server 2014 Engine without requiring any additional actions and allows in-memory performance benefits without rewriting your database application or refreshing your hardware. In-Memory OLTP allows you to access the other rich features in SQL Server, while taking advantage of in-memory performance.
In-Memory Updateable ColumnStore:
Provides higher compression, richer query support and updateability of the existing ColumnStore for data warehousing workloads giving you even faster load speed, query performance, concurrency, and even lower price per terabyte.

Encrypted Backup:
Provides encryption support for backups, on-premises and in Microsoft Azure.
Extending Memory to SSDs:
Seamlessly and transparently integrates solid-state storage into SQL Server by using SSDs as an extension to the database buffer pool, allowing more in-memory processing and reducing disk IO.

Improved Online Database Operations:
Includes single partition online index rebuild and managing lock priority for table partition switch, reducing maintenance downtime impact.
New AlwaysOn features:
Availability Groups now support up to 8 secondary replicas that remain available for reads at all times, even in the presence of network failures. Failover Cluster Instances now support Windows Cluster Shared Volumes, improving the utilisation of shared storage and increasing failover resiliency.

IO Resource Governance:
Resource pools now support configuration of minimum and maximum IOPS per volume, enabling more comprehensive resource isolation controls.
SQL Server Backup to Azure:
Provides management and automation of SQL Server backups (from on-premises and Microsoft Azure) to Microsoft Azure storage.
AlwaysOn with Azure Secondaries:
Easily add replicas in Microsoft Azure to on-premises Availability Groups.
SQL XI (XStore Integration):
Supports SQL Server Database files (from on-premises and Microsoft Azure) on Microsoft Azure Storage blobs.
Deployment Wizard:
Easily deploy on-premises SQL Server databases to Microsoft Azure.

For further information on Microsoft SQL Server 2014 please call MicroWay on 1300 553 313 or email.



For more information please contact the MicroWay sales team: buynow
Head Office
MicroWay Pty Ltd
PO Box 84,
Braeside, Victoria, 3195, Australia
Ph: 1300 553 313
Fax: 1300 132 709
email: sales@microway.com.au
ABN: 56 129 024 825
Sydney Sales Office
MicroWay Pty Ltd
PO Box 1733,
Crows Nest, NSW 1585, Australia
Tel: 1300 553 313
Fax: 1300 132 709
email: sales@microway.com.au
ABN: 56 129 024 825
New Zealand Sales Office
MicroWay Pty Ltd (NZ)
PO Box 912026
Victoria Street West
Auckland 1142, New Zealand
Tel: 0800 450 168
email: sales@microway.co.nz

International: call +61 3 9580 1333, fax +61 3 9580 8995

© 1995-2016 MicroWay Pty Ltd. All Rights Reserved. Terms and Privacy Policy.