Catalog: SQL Server 2014 Management and Maintenance guide

SQL Server 2014 installation and Configuration guide

Chapter Catalogue

"SQL Server 2014 management and Maintenance"

1th. Achieving data integrity and consistency

1.1 Data integrity

1.2 Data consistency

1.3 Blocking and deadlocks

The 2nd chapter contains the database

2.1 Included Concepts

2.2 Implementing the Include database

2.3 Collation of the containing database

2.4 Migrating to a containing database

3rd Chapter Management Database

3.1 Modifying Database options

3.2 File types for databases

3.3 Triggers for the database

4th. Organizational structure of the database

4.1 File Groups

4.2 Partitioning

4.3 How pages and districts are allocated

4.4 Pages for tables and indexes

4.5 Structure of the index

5th Operation Database

5.1 Moving database files

5.2 Renaming a database

5.3 Offline and online

5.4 Attach and Detach

5.5 Expansion and contraction

5.6 Modifying the schema of a database

5.7 Rebuilding the master database

Chapter 6th Importing and exporting data

6.1 Copying a database

6.2 Import and Export Wizard

6.3 bcp and bulk INSERT

6.4 Using Integration Services

Chapter 7th Managing server objects and special components

7.1 Server Objects

7.2 Memory-Optimized tables

7.3 File stream and File table

7.4 Columnstore Index

7.5 Full-Text indexing

8th Chapter Management Security

8.1 Architecture

8.2 Characters

8.3 Authentication

8.4 Audit

8.5 Administrative rights

The 9th Chapter database encryption

9.1 Master Key

9.2 Certificate

9.3 Transparent Data encryption

Chapter 10th activities of the Management Server

10.1 Events and Monitors

10.2 System View

10.3 Managing the Data Warehouse

10.4 Resource Governor

11th. Monitoring SQL Server

11.1 Performance Counters

11.2 Windows Event Log

11.3 SQL Server Event Log

11.4 Profiler

11.5 Tracking

11.6 Extended Events

11.7 Using trace Flags

12th. Database optimization

12.1 Update STATISTICS

12.2 Data compression

12.3 Index Defragmentation

12.4 table and Index partitions

12.5 Partitioned views

12.6 "Lost" index

12.7 Database Engine Tuning Advisor

12.8 Distributed Replay Controller

13th. Backing Up the database

13.1 Recovery Model

13.2 Backing up devices and backup sets

13.3 How to back up

13.4 Backup Options

13.5 Optimize your backup strategy

14th. Recovery Database

14.1 Designing a disaster recovery strategy

14.2 Recovering a database

14.3 Restore to point in time

14.4 Recovering encrypted databases

14.5 Recovering a damaged database

14.6 Special Recovery

15th. Using DBCC to maintain the database

15.1 Checking database integrity with DBCC CHECKDB

15.2 Using the DBCC repair page

The 16th chapter realizes the Automation management

16.1 agents

16.2 Scheduled Tasks and jobs

16.3 Database Mail

16.4 Alarms and operators

16.5 Maintenance Plan Wizard

11.6 Managed Backups

The 17th Chapter Management Multi-instance

17.1 Policy-based management

17.2 using WSRM

Chapter 18th using PowerShell

18.1 PowerShell Overview

18.2 Using SQL Server PowerShell

This article from "SQLServer2014 series" blog, declined reprint!

Catalog: SQL Server 2014 Management and Maintenance guide