Important links for SQL Server 2016 & 2017 Database Administration & 70-764 Certification

Very Important links for SQL Server 2016 & 2017 Database Administration & 70-764 Certification 



Backup Encryption:

https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/backup-encryption

Create an Encrypted Backup:-
https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/create-an-encrypted-backup

Create a Full Database Backup (SQL Server)

https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/create-a-full-database-backup-sql-server

RESTORE Statements (Transact-SQL)
https://docs.microsoft.com/en-us/sql/t-sql/statements/restore-statements-transact-sql

Database-Level Roles
----------------------
https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/database-level-roles
Server-Level Roles
---------------------
https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/server-level-roles
SQL Server Audit (Database Engine)
--------------------------------------
https://docs.microsoft.com/en-us/sql/relational-databases/security/auditing/sql-server-audit-database-engine
Open Activity Monitor (SQL Server Management Studio)
------------------------------------------
https://docs.microsoft.com/en-us/sql/relational-databases/performance-monitor/open-activity-monitor-sql-server-management-studio

DBCC CHECKDB (Transact-SQL)
------------------------------
https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-checkdb-transact-sql

GRANT Server Permissions (Transact-SQL)
--------------------------------
https://docs.microsoft.com/en-us/sql/t-sql/statements/grant-server-permissions-transact-sql

Data Definition Language (DDL) Statements (Transact-SQL)
-------------------------------------------------------
https://technet.microsoft.com/en-us/library/ff848799%28v=sql.110%29.aspx

Getting Started with Database Engine Permissions
-------------------------------------------------
https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/getting-started-with-database-engine-permissions

Reorganize and Rebuild Indexes
https://docs.microsoft.com/en-us/sql/relational-databases/indexes/reorganize-and-rebuild-indexes

DBCC DBREINDEX (Transact-SQL)
https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-dbreindex-transact-sql

ALTER INDEX (Transact-SQL)
https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-index-transact-sql

Columnstore indexes - Overview
https://docs.microsoft.com/en-us/sql/relational-databases/indexes/columnstore-indexes-overview

Columnstore indexes - defragmentation
https://docs.microsoft.com/en-us/sql/relational-databases/indexes/columnstore-indexes-defragmentation

Guidelines for Online Index Operations

https://docs.microsoft.com/en-us/sql/relational-databases/indexes/guidelines-for-online-index-operations

Statistics
https://docs.microsoft.com/en-us/sql/relational-databases/statistics/statistics

Database Properties (Options Page)
https://docs.microsoft.com/en-us/sql/relational-databases/databases/database-properties-options-page

ALTER DATABASE SET Options (Transact-SQL)
https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql-set-options

sp_autostats (Transact-SQL)

https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-autostats-transact-sql

Incremental statistics … How to Update Statistics on 100TB Database
https://blogs.technet.microsoft.com/dataplatform/2016/04/03/incremental-statistics-how-to-update-statistics-on-100tb-database/


SQL Server Audit Action Groups and Actions
https://docs.microsoft.com/en-us/sql/relational-databases/security/auditing/sql-server-audit-action-groups-and-actions

Create a Server Audit and Server Audit Specification
https://docs.microsoft.com/en-us/sql/relational-databases/security/auditing/create-a-server-audit-and-server-audit-specification

Create a Server Audit and Database Audit Specification
https://docs.microsoft.com/en-us/sql/relational-databases/security/auditing/create-a-server-audit-and-database-audit-specification

sys.fn_get_audit_file (Transact-SQL)
https://docs.microsoft.com/en-us/sql/relational-databases/system-functions/sys-fn-get-audit-file-transact-sql


Create an Operator
https://docs.microsoft.com/en-us/sql/ssms/agent/create-an-operator

Alerts
https://docs.microsoft.com/en-us/sql/ssms/agent/alerts

CREATE USER (Transact-SQL)

https://docs.microsoft.com/en-us/sql/t-sql/statements/create-user-transact-sql

Managing Logins, Users, and Schemas How-to Topics
https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/managing-logins-users-and-schemas-how-to-topics


Query Store Catalog Views

https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/query-store-catalog-views-transact-sql

sys.query_store_query

https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-query-store-query-transact-sql

sys.database_query_store_options

https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-database-query-store-options-transact-sql

sys.query_context_settings

https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-query-context-settings-transact-sql

sys.query_store_plan (Transact-SQL)

https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-query-store-plan-transact-sql

sys.query_store_runtime_stats_interval

https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-query-store-runtime-stats-interval-transact-sql

sp_query_store_flush_db
https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-query-store-flush-db-transact-sql

sys.sp_xtp_control_query_exec_stats

https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sys-sp-xtp-control-query-exec-stats-transact-sql

sys.database_query_store_options (Transact-SQL)

https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-database-query-store-options-transact-sql

sys.query_store_runtime_stats_interval (Transact-SQL)

https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-query-store-runtime-stats-interval-transact-sql

sp_query_store_flush_db (Transact-SQL)

https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-query-store-flush-db-transact-sql

Management Data Warehouse

https://docs.microsoft.com/en-us/sql/relational-databases/data-collection/management-data-warehouse

what is Data Collection & Data collector

https://docs.microsoft.com/en-us/sql/relational-databases/data-collection/data-collection

Manage Data Collection

https://docs.microsoft.com/en-us/sql/relational-databases/data-collection/manage-data-collection

Configure Data Collection Parameters (Transact-SQL)

https://docs.microsoft.com/en-us/sql/relational-databases/data-collection/configure-data-collection-parameters-transact-sql

Create Custom Collection Set - Generic T-SQL Query Collector Type

https://docs.microsoft.com/en-us/sql/relational-databases/data-collection/create-custom-collection-set-generic-t-sql-query-collector-type

Data Collector Stored Procedures (Transact-SQL)

https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/data-collector-stored-procedures-transact-sql

sp_syscollector_set_warehouse_instance_name (Transact-SQL)

https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-syscollector-set-warehouse-instance-name-transact-sql

Troubleshooting Insufficient Disk Space in tempdb

https://technet.microsoft.com/en-us/library/ms176029(v=sql.105).aspx

TempDB usage per active session

http://www.sqlservercentral.com/scripts/tempdb/72007/

sys.dm_db_session_space_usage

https://technet.microsoft.com/en-us/library/ms187938(v=sql.105).aspx

sys.dm_db_task_space_usage

https://technet.microsoft.com/en-us/library/ms190288(v=sql.105).aspx

sys.dm_db_file_space_usage

https://technet.microsoft.com/en-us/library/ms174412%28v=sql.105%29.aspx

sys.dm_exec_sessions (Transact-SQL)

https://technet.microsoft.com/en-us/library/ms176013(v=sql.105).aspx

Columnstore indexes - Overview

https://docs.microsoft.com/en-us/sql/relational-databases/indexes/columnstore-indexes-overview

CREATE COLUMNSTORE INDEX (Transact-SQL)

https://docs.microsoft.com/en-us/sql/t-sql/statements/create-columnstore-index-transact-sql

Security and Permissions

https://msdn.microsoft.com/en-us/library/cc293611.aspx

Server-Level Roles

https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/server-level-roles

Server and Database Roles in SQL Server

https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql/server-and-database-roles-in-sql-server

ALTER SERVER ROLE (Transact-SQL)

https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-server-role-transact-sql

Resilient File System (ReFS) overview

https://docs.microsoft.com/en-us/windows-server/storage/refs/refs-overview

Use Cluster Shared Volumes in a Failover Cluster

https://docs.microsoft.com/en-us/previous-versions/windows/it-pro/windows-server-2012-R2-and-2012/jj612868(v=ws.11)

Configure SQL Server Failover Cluster Instance on Azure Virtual Machines

https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-portal-sql-create-failover-cluster

Add Dependencies to a SQL Server Resource

https://docs.microsoft.com/en-us/sql/sql-server/failover-clusters/windows/add-dependencies-to-a-sql-server-resource

sys.dm_db_index_physical_stats

https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-db-index-physical-stats-transact-sql

sys.fn_trace_gettable

https://docs.microsoft.com/en-us/sql/relational-databases/system-functions/sys-fn-trace-gettable-transact-sql

Get started with SQL database auditing

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-auditing

Secure your Azure SQL Database

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-security-tutorial


Database Engine Error Severities

https://docs.microsoft.com/en-us/sql/relational-databases/errors-events/database-engine-error-severities

Quick Start: Extended events in SQL Server

https://docs.microsoft.com/en-us/sql/relational-databases/extended-events/quick-start-extended-events-in-sql-server

Extended Events Tools

https://docs.microsoft.com/en-us/sql/relational-databases/extended-events/extended-events-tools

Advanced Viewing of Target Data from Extended Events in SQL Server

https://docs.microsoft.com/en-us/sql/relational-databases/extended-events/advanced-viewing-of-target-data-from-extended-events-in-sql-server

Use the system_health Session

https://docs.microsoft.com/en-us/sql/relational-databases/extended-events/use-the-system-health-session

Configure SQL Server Failover Cluster Instance on Azure Virtual Machines

https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-portal-sql-create-failover-cluster

High availability and disaster recovery for SQL Server in Azure Virtual Machines

https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-sql-high-availability-dr

Configure Read-Only Routing for an Availability Group (SQL Server)

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/configure-read-only-routing-for-an-availability-group-sql-server

Top Tips for Effective Database Maintenance
https://technet.microsoft.com/en-us/library/2008.08.database.aspx


Use Cluster Shared Volumes in a Failover Cluster

https://docs.microsoft.com/en-us/previous-versions/windows/it-pro/windows-server-2012-R2-and-2012/jj612868(v=ws.11)

Clustering and High-Availability

https://blogs.msdn.microsoft.com/clustering/2014/05/08/deploying-sql-server-2014-with-cluster-shared-volumes/

Always On Failover Cluster Instances (SQL Server)

https://docs.microsoft.com/en-us/sql/sql-server/failover-clusters/windows/always-on-failover-cluster-instances-sql-server

Assign Alerts to an Operator

https://docs.microsoft.com/en-us/sql/ssms/agent/assign-alerts-to-an-operator


Define the Response to an Alert

https://docs.microsoft.com/en-us/sql/ssms/agent/define-the-response-to-an-alert-sql-server-management-studio

Operators

https://docs.microsoft.com/en-us/sql/ssms/agent/operators

Create an Operator
https://docs.microsoft.com/en-us/sql/ssms/agent/create-an-operator

Alerts
https://docs.microsoft.com/en-us/sql/ssms/agent/alerts

Before Installing Failover Clustering

https://docs.microsoft.com/en-us/sql/sql-server/failover-clusters/install/before-installing-failover-clustering

SQL Server Failover Cluster Installation

https://docs.microsoft.com/en-us/sql/sql-server/failover-clusters/install/sql-server-failover-cluster-installation
Create a New SQL Server Failover Cluster (Setup)

https://docs.microsoft.com/en-us/sql/sql-server/failover-clusters/install/create-a-new-sql-server-failover-cluster-setup

When Creating a New Resource or Role in Windows Server 2012 R2 Failover Cluster, the Network Name Fails to Come Online or Failed to Create Associated Computer Object in Domain

https://blogs.technet.microsoft.com/askpfeplat/2014/11/17/when-creating-a-new-resource-or-role-in-windows-server-2012-r2-failover-cluster-the-network-name-fails-to-come-online-or-failed-to-create-associated-computer-object-in-domain/

Create a Server Audit and Server Audit Specification

https://docs.microsoft.com/en-us/sql/relational-databases/security/auditing/create-a-server-audit-and-server-audit-specification

Restore Pages (SQL Server)

https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/restore-pages-sql-server