SQL Server 2019 Administration

 سرفصل ها :

System Databases

Recovery Model

Restrict Access

Database Snapshots (Only T-SQL)

Partitioning

partition functions and partition schemes

Triggers

Analysis Services

Integration Services

Reporting Services

Database Mail

Full-Text Index

Transparent Data Encryption (TDE)

Alerts

Performance and Troubleshooting Tools

Locks

SQL Server Profiler

Database Engine Tuning Advisor

Dynamic Management Views (DMV)

Backup

Restore

Security

Encryption

Permissions

SQL Server Audit

Notifications

Understanding High Availability

Failover Clustering

RAID-based Data Redundancy

Using Database Mirroring

Log Shipping

Database Snapshots

Replication

Importing and Exporting Data

Overview of SQL Server

Different between SQL Server Editions

Setup SQL Server

Basic Commands (select, insert, …)

Join

Aggregate functions

Data Access Methods

Data Write Methods

Overview of the SQL Server Configuration Manager (SSCM)

TCP/IP on port 1433

Shared Memory for Express without any config in memory

Named Pipes for Local Machines with multiple listener

Performing Common SSCM Tasks

Starting and Stopping Services

Configuring Services

Configuring Protocols

Server Config

SQL Server Network Configuration

Client Config

SQL Server Native Client 11.0 Configuration

Alias

Command Line

BUM

Planning a Database

Entity Relationship Diagramming (ERD)

Creating an ERD in Visio

Normalizing a Database

Designing for Performance

Designing for Availability

Designing for Security