SQL Server 2014 Resources

SQL Server 2014 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:

  • Allows you to create memory-optimized database objects that enable more efficient data access.

  • Allows native compilation of Transact-SQL stored procedures, which will run business logic more efficiently.

  • Gives full ACID guarantees – all data in durable tables will be recovered after a server crash.

  • Does not use page-based data structures, eliminating latch waits.

  • Results in higher throughput, lower latency, and better performance, all at lower Total Cost of Ownership (TCO).

  • Does not rely on the buffer pool.

  • Indexes exist only in memory.

  • Unlike competitors, SQL Server's memory optimization is not a separate product – it integrates with existing tools. A database can have both disk-based and memory-optimized tables.

To get started with In-Memory OLTP, see In-Memory OLTP (In-Memory Optimization).

Performance Guidance

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.

What's New in SQL Server 2014

The following table lists SQL Server tools and add-ins, and provides links to additional documentation in the MSDN Library.



Report Builder Help for SQL Server 2014

Report Builder is a report authoring environment for business users.

Upgrade Advisor

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

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 Setup

SQL Server 2014 Installation documentation to assist with Setup.

SQL Server Servicing Installation

Documentation to assist with applying updates to SQL Server components.

SQL Server Data Mining Add-ins for Office 2013

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

Change Data Capture Designer for Oracle is used to develop and maintain Oracle CDC Instances.

Change Data Capture Service for Oracle

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.

Microsoft Connector 1.1 for SAP BW

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.

Playback Capture for Upgrade Assistant

The Capture Playback workflow in Upgrade Assistant automates the workload trace capture process to be used for replay at a later time.

Microsoft ODBC Driver 11 for SQL Server on Windows

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

Power Pivot for SharePoint is an Analysis Services server running in SharePoint mode.

© 2016 Microsoft