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.
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. Scale and transform your
business with, on average, a 10x performance gain for transaction processing
while still using existing hardware, and a greater-than 100x performance
gain for data warehousing.
Learn more
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. Get more predictable performance of virtualized SQL
Server instances with IO governance in Resource Governor.
Learn more
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. In SQL Server 2014, there are additional active secondaries,
new online operations and the ability to quickly setup a secondary in
Microsoft Azure.
Learn more
Enterprise scalability across compute, networking, and storage
With Windows Server, physical processing now scales up to 640 logical
processors, and virtual machines scale up to 64 logical processors. SQL
Server 2014 uses this scale, storage spaces and network virtualization to
maximize overall infrastructure utilization. It can also run on Windows
Server Core to lower the surface area of attack.
Learn more
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 to support separation of duties across various
users.
Learn more
Consistent data platform on-premises to cloud
Leverage existing skills and familiar tools across Microsoft’s data
platform with SQL Server in a Microsoft Azure virtual machine when migrating
existing on-premises apps into the cloud, and Microsoft Azure SQL Database
for new modern applications that fully utilize the scale of the cloud.
Learn more
Corporate business intelligence
Scale your BI models, enrich and help secure your data, and ensure
quality and accuracy with a complete BI solution. Build comprehensive,
enterprise-scale analytic solutions with Analysis Services and simplify BI
model deployment with the BI Semantic Model.
Learn more
Faster insights for all users in familiar tools
like Excel and data access via mobile devices
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. Search, access, and shape internal, external, structured, and
unstructured data with Power Query. Access insights from anywhere using
Power BI for Office 365.
Learn more
Scalable data warehousing
Scale to petabytes for relational data warehousing and integrate with
non-relational sources like Hadoop. 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.
Learn more
Data quality and integration services
Integration services includes rich support for extract, transact and load
(ETL) tasks, and the ability to run and manage as a separate SQL Server
instance. Improve data quality by using organizational knowledge and
third-party data providers to cleanse data through Data Quality Services.
Learn more
Easy-to-use management tools
SQL Server Management Studio helps you centrally manage your database
infrastructure both on-premises and in the cloud. Added support for Windows
PowerShell 2.0 automates management tasks and enhancements to Sys Prep let
you more efficiently create virtual machines. Simplify application testing
on a single database using Distributed Replay.
Learn more
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. Customers can use industry
standard APIs (ADO.NET, ODBC, JDBC, PDO, and ADO) across varied platforms
including .NET, C/C++, Java, Linux, and PHP.
Learn more
Next Steps
Back To Microsoft Product Support
Tool Main Page
Support services and website data presented herein and on all subordinate sites are based upon technical information
provided by the manufacturers of the relevant products sold by Tech Data.
Tech Data believes this information to be accurate; however, Tech Data makes no representations or warranties with respect to the performance of the
support services and information, and any and all warranties, whether oral or written, expressed or implied, are hereby expressly disclaimed by Tech Data,
including, but not limited to, warranties of merchantability and fitness for a particular purpose.