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.
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.
Get to insights faster with a complete BI platform that speeds up how you access, analyse, 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 organisation to the right data they need to make better decisions, faster.
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 datacentres.