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

Use the following community resources to see what the SQL Server community is up to.

SQL Server Team Blog

 SQL Server questions on Stack Overflow

 SQL Server articles on the TechNet wiki

 SQL Server Community Center

 IT Professionals: SQL Server Forum on TechNet

 Developers: SQL Server Developer Center

 SQL Server Tools Forum

 PowerPivot Team Blog

 PowerPivotGeek Blog

 SQL Server Twitter Feed

 SQL Server Facebook Page


 SBI Liquidity Market



 Carnegie Mellon University and OSIsoft


 Conde Nast

 Carnegie Mellon University and OSIsoft
SQL Server videos on YouTube

 SQL Server videos on MSDN

 SQL Server videos on Channel 9
Download SQL Server 2014
How to buy SQL Server 2014

 Release Notes

 Hardware and Software Requirements

 Quick-Start Installation of SQL Server 2014

 What’s New in SQL Server 2014

 SQL Server Books Online

 Use Product Documentation for SQL Server

 Add or Remove Product Documentation for SQL Server

 Online Installation Help

 License Terms

 Privacy Statement

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 2014Report Builder is a report authoring environment for business users.
Upgrade AdvisorUpgrade 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 ManagerConfiguration 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 SetupSQL Server 2014 Installation documentation to assist with Setup.
SQL Server Servicing InstallationDocumentation to assist with applying updates to SQL Server components.
SQL Server Data Mining Add-ins for Office 2013Data 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 OracleChange Data Capture Designer for Oracle is used to develop and maintain Oracle CDC Instances.
Change Data Capture Service for OracleChange 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 BWThe 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 AssistantThe 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 WindowsThe 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 SharePointPower Pivot for SharePoint is an Analysis Services server running in SharePoint mode.
Professional Association for SQL Server
Support options for Microsoft SQL Server

What's New in SQL Server 2014

© 2016 Microsoft