|
|
SQL Server 2014
The foundation of Microsoft’s
comprehensive data platform, SQL Server 2014 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.
|
Breakthrough performance and faster
insights delivered by a hybrid data platform
SQL Server 2014 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.
|
Benefits
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.
|
|
Capabilities
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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. |
Editions
Enterprise
SQL Server Enterprise delivers
comprehensive high-end datacenter capabilities for demanding
database and business intelligence requirements.
Standard
SQL Server Standard provides
core data management and business intelligence capabilities
for non-critical workloads with minimal IT resources.
Business Intelligence
SQL Server Business Intelligence
empowers organizations to build and deploy secure, scalable
and manageable self-service corporate BI solutions.
Express
SQL Server Express is a free
edition of SQL Server ideal for developing and powering
desktop, web and small server applications.
|
Compare Editions
Features |
Enterprise
|
Business
Intelligence |
Standard |
Maximum number of
cores |
OS Max |
16 cores-DBOS
Max-AS&RS ¹ |
16 cores |
Programmability
(T-SQL, data types, FileTable) |
X |
X |
X |
Manageability (SQL
Server Management Studio, policy-based
management) |
X |
X |
X |
Basic high
availability ² |
X |
X |
X |
Basic security
(Separation of duties, basic auditing)
|
X |
X |
X |
Basic OLTP |
X |
X |
X |
Basic corporate BI
(Reporting, analytics, multidimensional semantic
model, data mining) |
X |
X |
X |
Basic data
integration (Built-in data connectors, designer
transforms) |
X |
X |
X |
Self-service
business intelligence (Alerting, Power View,
Power Pivot for SharePoint Server) |
X |
X |
|
Advanced corporate
BI (Tabular BI semantic model, advanced
analytics and reporting, in-memory analytics
engine, advanced data mining) |
X |
X |
|
Enterprise data
management (Data Quality Services, Master Data
Services) |
X |
X |
|
Advanced data
integration (Fuzzy grouping and lookup, change
data capture) |
X |
|
|
Advanced security
(SQL Server audit, transparent data encryption) |
X |
|
|
Data warehousing
(Updatable in-memory columnstore, compression,
partitioning) |
X |
|
|
Advanced high
availability (AlwaysOn, multiple, active
secondaries; multi-site, geo-clustering) |
X |
|
|
Advanced transaction
processing (In-memory OLTP) |
X |
|
|
¹ Analysis Services &
Reporting Services.
² Basic includes log
shipping, database mirroring, Windows Server Core
support and two-node Failover Clustering.
|
System requirements
Component |
Requirement |
Memory[1] |
Minimum:
Express Editions: 512 MB
All other editions: 1 GB
Recommended:
Express Editions: 1 GB
All other editions: At least 4 GB and should be increased as database
size increases to ensure optimal performance. |
Processor Speed |
Minimum:
- x86 Processor: 1.0 GHz
- x64 Processor: 1.4 GHz
Recommended: 2.0 GHz or faster |
Processor Type |
- x64 Processor: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel
EM64T support, Intel Pentium IV with EM64T support
- x86 Processor: Pentium III-compatible processor or faster
|
|
Download the Microsoft SQL Server
2014 Evaluation
See how 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.
Download
it now! |
|
|
|