SQL Server 2016 Resources
Microsoft SQL Server 2014 builds on the mission-critical capabilities delivered in our prior release by providing breakthrough performance, availability and manageability for your mission critical applications. SQL Server 2014 delivers new in-memory capabilities built into the core database for online transaction processing (OLTP) and data warehousing, which complement our existing in-memory data warehousing and BI capabilities for the most comprehensive in-memory database solution on the market.
SQL Server 2014 also provides new disaster recovery, backup, and hybrid architecture solutions with Windows Azure, enabling customers to use their existing skills with on-premise features that leverage Microsoft’s global datacenters. In addition, SQL Server 2014 takes advantage of new Windows Server 2012 and Windows Server 2012 R2 capabilities to give you unparalleled scalability for your database application in a physical or virtual environment.
See the following sections in this topic for additional information and links to SQL Server 2014 resources.
Here’s What Makes SQL Server 2014 a Game-Changer
See What Customers are Doing with SQL Server 2014
Get Your Hands On It
SQL Server 2014 Documentation
More Information and Support
New In-Memory OLTP capabilities built into the SQL Server 2014 database engine can result in significantly improved database application performance. In-Memory OLTP enables performance benefits without having to refresh your hardware. Use of main memory can result in significant performance gains – up to 30x faster, with an average 10x improvement; application performance depends on many factors.
New In-Memory OLTP
Developed in partnership with Microsoft Research, the In-Memory OLTP feature in SQL Server 2014:
To get started with In-Memory OLTP, see In-Memory OLTP (In-Memory Optimization).
Learn key factors to consider when evaluating performance or planning a migration to SQL Server in Windows Azure Virtual Machines. For more information, see Performance Guidance for SQL Server in Windows Azure Virtual Machines.
SQL Server 2014 provides an important component of the Microsoft hybrid IT value proposition: Connect today’s on-premise IT environment to the cloud. Hybrid solutions can be tailored to meet your needs: Run code both on-premise and in the cloud, run in the cloud using on-premise data, or run entirely in the cloud leveraging more than one datacenter. These scenarios enable you to move to the cloud at your own pace while preserving the value of legacy IT investments. SQL Server 2014 enables you to consume cloud services on your terms.
Leverage hybrid architectures to create efficiencies
Flexibility to run SQL Server workloads on-premise or in the cloud
Consistency between local and cloud environments
SQL Server provides the foundation for the Microsoft BI platform through a comprehensive collection of services and content types that bring you faster insights across a wide range of analytical and data visualization applications, including Excel, Power View, Data Explorer, and business reports. Analysis Services, Data Mining, Reporting Services, Power View, and Power Pivot provide end-to-end services that power BI solutions across the enterprise.
With each release and on every platform, you see deeper integration between Windows Azure, Office 365, SQL Server, SharePoint, and Office. SQL Server 2014 is no exception. In this release, familiar applications and data visualizations are available on more devices and formats.
Self-Service BI provides end users the tools they need to make quick and impactful decisions
Corporate BI provides centralized data models and reports on IT-managed servers
View a summary of new features in this SQL Server release.
Use the following community resources to see what the SQL Server community is up to.
The following table lists SQL Server tools and add-ins, and provides links to additional documentation in the MSDN Library.
Report Builder is a report authoring environment for business users.
Upgrade Advisor analyzes the configuration of installed SQL Server components, and then generates a report of issues that you must address to assure a successful upgrade.
Configuration Manager is a tool to manage the services associated with SQL Server, to configure the network protocols used by SQL Server, and to manage the network connectivity configuration from SQL Server client computers.
SQL Server 2014 Installation documentation to assist with Setup.
Documentation to assist with applying updates to SQL Server components.
Data Mining Add-ins for Office is a lightweight set of tools for predictive analytics that lets you use data in Excel to build analytical models for prediction, recommendation, or exploration.
Change Data Capture Designer for Oracle is used to develop and maintain Oracle CDC Instances.
Change Data Capture Service for Oracle is a Windows service that scans Oracle transaction logs and captures changes to Oracle tables of interest into SQL Server change tables.
The Microsoft Connector 1.1 for SAP BW consists of a set of three components that let you extract data from, or load data into, an SAP Netweaver BW version 7 system.
The Capture Playback workflow in Upgrade Assistant automates the workload trace capture process to be used for replay at a later time.
The Microsoft ODBC Driver 11 for Windows is a stand-alone driver that provides an application programming interface (API) that implements the standard ODBC interfaces to Microsoft Windows.
Power Pivot for SharePoint is an Analysis Services server running in SharePoint mode.