SQL Server 2012 enables customers to build mission-critical applications and Big Data solutions using high-performance, in-memory technology across OLTP, data warehousing, business intelligence and analytics workloads without having to buy expensive add-ons or high-end appliances. SQL Server 2014 uses a common set of tools to deploy and manage databases both on-premises and in the cloud, which makes it easier for customers to take advantage of the cloud with existing skills.
- Greater availability
- Breakthrough insight
- Credible, consistent data
- Productive development experience
- Breakthrough, in-memory performance
With SQL Server 2014, new in-memory capabilities for transaction processing and enhancements for data warehousing complement our existing technologies for data warehousing and analytics.
- Proven, predictable performance
SQL Server consistently leads in TPC-E, TPC-H and real-world application performance benchmarks. SQL Server is SAP-certified to run some of the most demanding workloads.
- High availability and disaster recovery
Gain greater uptime, faster failover, improved manageability, and better use of hardware resources through AlwaysOn, a unified solution for high availability.
- Enterprise scalability
SQL Server 2014 uses this scale, storage spaces and network virtualization to maximize overall infrastructure utilization.
- Security and compliance
Help secure data with transparent data encryption, robust auditing, extensible key management and encrypted backups. It is even easier to manage permissions for data access.
- Consistent data platform
Leverage existing skills and familiar tools across Microsoft's data platform with SQL Server in a Windows Azure virtual machine when migrating existing on-premises apps into the cloud.
- Corporate business intelligence
Build comprehensive, enterprise-scale analytic solutions with Analysis Services and simplify BI model deployment with the BI Semantic Model.
- Faster insights for all users
Accelerate time-to-insight, on-premises and in the cloud with SQL 2014 and Power BI for Office 365. Get richer visualizations using Power Map and Power View.
- Scalable data warehousing
Support your smallest to your largest data storage needs while handling queries up to 100x faster than your legacy data platform through massive parallel processing and in-memory technologies with SQL Server Parallel Data Warehouse.
- Data quality and integration services
Improve data quality by using organizational knowledge and third-party data providers to cleanse data through Data Quality Services.
- Easy-to-use management tools
SQL Server Management Studio helps you centrally manage your database infrastructure both on-premises and in the cloud. Simplify application testing on a single database using Distributed Replay.
- Robust development tools
SQL Server Data Tools integrate into Visual Studio and are available for download to build next-generation web, enterprise, business intelligence and mobile applications across 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.
- 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.
- Platform for hybrid cloud
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.
- Comprehensive database server
Productive data management software and development tools, and equip people with powerful self-service business intelligence (BI).