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).
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
Introduction to SQL Server 14 Hybrid Cloud - The Microsoft Hybrid Cloud Strategy provides support for traditional, private cloud, public cloud, and hybrid cloud environments. Use this topic to learn about SQL Server 2014 features that support Hybrid Cloud scenarios.
SQL Server Integration with Windows Azure Storage enables native support for SQL Server database files stored as Windows Azure Blobs.
Utilize Windows Azure for backup and restore of on-premise databases. For more information, see the following topics:
Utilize hybrid architectures to fulfill high availability and disaster recovery requirements for mission-critical databases. For more information, see High Availability and Disaster Recovery for SQL Server in Windows Azure Virtual Machines.
Utilize a certificate or an asymmetric key to encrypt backup files with encryption algorithms including AES 128, AES 192, AES 256, and Triple DES. For more information, see Backup Encryption.
Flexibility to run SQL Server workloads on-premise or in the cloud
Utilize virtual machines to host SQL Server.
Migrate on-premise database to Windows Azure SQL Database.
Consistency between local and cloud environments
Consistency between local and cloud environments provided through federated authentication in Windows Server Active Directory.
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
Power Pivot brings power and speed to analysis on the desktop, with great new features in Excel 2013. Import data from multiple sources, and then add relationships and calculations to create a Data Model that supports analysis and visualizations. For more information, see Power Pivot: Powerful Data Analysis and Data Modeling in Excel.
Pivot Tables are fundamental to performing data analysis in Excel, and having a Data Model behind them makes them even better. For more information, see Tutorial: Pivot Table Data Analysis Using a Data Model in Excel 2013.
Power View is an interactive data exploration, visualization, and presentation experience that encourages intuitive, ad-hoc reporting. It started out life in SharePoint, but now is also available in Excel; check out the new features. For more information, see Power View: Explore, Visualize, and Present Your Data.
Power View had been available only for Power Pivot and tabular models, but now provides the same exploration, visualization, and presentation experience for multidimensional models. For more information, see Understanding Power View for Multidimensional Models.
Power Pivot and Power View are made for each other, and we have lots of information on how to use them together. For more information, see Power View and Power Pivot Videos and Tutorial: Optimize Your Data Model for Power View Reporting.
Corporate BI provides centralized data models and reports on IT-managed servers
Big data, small data, any data – it all has a place in SQL Server 2014. For more information, see SQL Server Analysis Services to Hive.
Tabular or multidimensional models put data, logic and calculations in one place, ensuring consistent reporting across your organizations and insights you can trust. Hosted, secured, and managed on Analysis Services instances. See how the model formats compare and choose the best one for you.
Data Mining helps you find patterns and trends in your data. Use Excel or standalone data mining models hosted on Analysis Services in multidimensional mode.
RDL reports hosted on-premise, on Windows Azure Virtual Machines, and viewed on almost any device. For more information, see the following resources:
Seamless integration across the Microsoft platform when you know how to set up authentication and identity delegation for your solutions. For more information, see Microsoft BI Authentication and Identity Delegation.
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.
SBI Liquidity Market
Carnegie Mellon University and OSIsoft
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|
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.|
|Professional Association for SQL Server|
|Support options for Microsoft SQL Server|