Transcript SQL Server 2014 Standard Edition Datasheet

SQL Server 2014
Standard Edition
SQL Server 2014 Standard Edition delivers business-class data management for a wide variety of
database applications, with reliable uptime, security and ease of management. Hybrid cloud
capabilities help you to scale on demand, increase availability and reduce costs. And when it
comes to business intelligence, it delivers faster insights into any data through familiar tools.
BUSINESS-CLASS
DATA MANAGEMENT
CLOUD ON
YOUR TERMS
FASTER INSIGHTS
ACROSS DATA
Proven Data Platform
Most widely utilized database on
the planet.1
Easy Onramp to the Cloud
Wizard for easy deployment from
server to cloud, plus common
architecture for code once, run
anywhere.
Operational Reporting
Get detailed, flexible, and up-tothe-minute analytical reports for
your operations.
Reliable Performance and
Availability
Get greater uptime and better
performance from your hardware,
at a low total cost of ownership.
Robust Administration
Easily manage, maintain, and
protect your data.
Security
and Compliance
Helps protect data across the
organization with robust,
configurable tools. Fewest
vulnerabilities 5 years running.
On-Demand Cloud Solutions
Scale out your datacenter
seamlessly and on-demand with
hybrid cloud solutions.
Rich Developer Tools
Get the tools and connectors
business class applications demand.
Analytical Insight
Gain new insights with analytical
services that drive OLAP cubes and
data marts.
Integrated, Consistent Data
Deliver consistent data to the
business from across the
organization.
Least vulnerable database
5 years in a row
(Vulnerabilities 2009-20132)
60
50
A Leader
40
Gartner Magic Quadrant
for Operational Database
Management Systems3
20
October 21, 2013
1Market
30
10
0
2009
SQL Server
2010
Oracle
2011
2012
MySQL
2013
DB2
share from IDC 2013 2National Institute of Standards and Technology Comprehensive Vulnerability Database 4/17/2013
does not endorse any vendor, product or service depicted in its research publications, and does not advise technology users to select
only those vendors with the highest ratings. Gartner research publications consist of the opinions of Gartner's research organization and
should not be construed as statements of fact. Gartner disclaims all warranties, expressed or implied, with respect to this research, including
any warranties of merchantability or fitness for a particular purpose.
3Gartner
SQL Server 2014 Standard
Data management that grows with your business across on-premises and cloud
BUSINESS-CLASS
DATA MANAGEMENT
CLOUD ON YOUR TERMS
FASTER INSIGHTS
ACROSS YOUR DATA
Proven Data Platform
Easy On-ramp to the Cloud
Operational Reporting
• Easily port existing databases ‘as is’ to a
Windows Azure VM
• Deploy quickly with the Windows Azure
Deployment Wizard
• Freely move DB apps across instances
and servers with License Mobility
• Common architecture across Microsoft
cloud offerings, public or private
• Support a wide variety of reporting needs
with SQL Server Reporting Services
• Define data sources, create queries and
report layouts, and add interactive
features with Report Designer
• Report Builder BI client enables business
users to work through the Microsoft
Office environment
Reliable Performance and Availability
On-demand Cloud Solutions
Analytical Insight
• Higher database max memory limits
• Enables Buffer Pool Extension to SSD
• New Delayed Durability increases
performance for non-critical workloads
• Scale up to 16 cores physical or virtual
computing power
• High Availability with Database Mirroring,
Log Shipping, and Failover Clustering
• Windows Server Core means less
patching by 50-60%
• Easy cloud-based backup and restore of
SQL Server to Windows Azure
• Store large DBs in the cloud to support
on-premises apps
• Span data across on-premises and the
cloud with Windows Azure Data Sync
• Self-service provisioning and usage
metering for simple cloud management
• View and manage on-premises and cloud
databases with a single console
• Easily stand up and manage OLAP and
reporting cubes using SQL Server Analysis
Services
• Provide a consistent view across
heterogeneous data sources with the BI
Semantic Model
• Access aggregates, custom rollups and
drill-through capabilities
• Perform data mining using familiar Office
tools with add-ins for Excel and Visio
Robust Administration
Rich Developer Tools
Integrated, Consistent Data
• Deploy and manage from one central
console with Management Studio
• Automate deployment and administration
with PowerShell scripting support
• Maintenance Plan Wizards
• Streamline virtualization support with
Management pack for Systems Center
• Manage services and connectivity using
Configuration Manager
• Build next-generation database and BI
apps across on-premises and public cloud
• Automate with PowerShell scripting
• Part of Visual Studio 2012 and 2013, or
free standalone
• SQL query edit and design tools to help
ensure consistent query performance
• Rich content management for new XML,
FILESTREAM and spatial datatypes
• Simplify data integration with SQL Server
Integration Services
• Extract, transform and load data while
minimizing code
• Gain near real-time insights with
StreamInsight™
• Connect using any industry standard APIs
• Varied platforms including .NET, C/C++,
Java, and PHP
Security and Compliance
Back-up to Windows Azure
•
•
•
•
•
•
Most widely utilized database
Robust partner ecosystem
Large community of .NET developers
Free management and migration tools
Prioritized 24x7 problem resolution
Access to advanced technical training
• Least vulnerable enterprise database 5
years in a row
• Designed for security from the ground up
• Active Directory Authentication
• Enhanced Separation of Duties
• Basic Auditing
• New Backup Encryption
Hardware and Software
Requirements for Installing
SQL Server 2014
Complete hardware and software
requirements for installing SQL Server 2014
can be found at:
http://msdn.microsoft.com/en-us/library/
ms143506.aspx
Client Tools
Analysis, Reports, Scorecards,
Dashboards, Custom Apps
Windows
Azure
Storage
in the
cloud
On-Premises Network
Data and
compute
on-premises
SQL Server
Learn more about SQL Server 2014 http://www.microsoft.com/en-us/sqlserver/sql-server-2014.aspx
BI Semantic Model
Data model
Business logic & queries
Data access
Data Sources
Databases, LOB Applications, Big Data,
Odata Feeds, Spreadsheets, Text Files
January 2014