SQL Server 2014 documentation

Microsoft SQL Server 2014 on-premises is a relational database.

Special articles

What's new

• What's new in SQL Server 2014
• Previous versions 2012-2005
• SQL Server latest version
• Unified data in SQL latest

Backend Development

Get started

• Engine overview

Reference

• T-SQL in SQL 2014 Offline Books
• CREATE DATABASE and other T-SQL
• CREATE TABLE and other T-SQL
• SELECT - JOIN - GROUP BY

Advanced Backend Dev

Reference

• FOR XML

Architecture

• .NET CLR integration
• Partitioned tables and indexes
• In-Memory OLTP
• Natively compilation stored procedures
• Columnstore indexes

Administration

Download

• Install SQL Server

Overview

• Recovery and continuity
• Security
• Configuration manager
• sp_configure server-wide settings
• Database startup options

Architecture

• Replication
• Monitor and tune Performance
• Database Tuning Advisor (DTA)
• SQL Server Profiler

Data administration

Overview

• Bulk data import and export
• Bulk Copy Program (BCP.exe)
• Data compression

Architecture

• Data Quality Service (DQS)
• Master Data Services (MDS)

Frontend Development

Reference

• Connect to SQL Server

Overview

• SQL Server Management Objects (SMO)

Client services

Overview

• Analysis Services (SSAS)
• Integration Services (SSIS)
• Reporting Services (SSRS)