ABCDEFGHIJKLMNOPQRSTUVWXY
1
SNoIndexSub Index
2
1
SQL Server History, Versions, Editions, Installations & Configurations
SQL Server Architecture
GUI, Un-Attended, Clustered, Alwayson AG
3
2012/2014/2016/2017/2019
4
2DB Architecture, Recovery Models, Backups & Restorations.
Disaster Recovery Scenarios
5
3SQL SERVER SECURITY ( Windows, SQL & DB Level).
SQL Server Auditing (Different Types)
6
4Automation of Administrative Jobs
7
5High Availability Concepts (with Setup\Configuration)DB Log Shipping
8
DB Mirroring
9
DB Replication
10
Clustering (Windows+SQL Server)Active\Passvie
Active\Active
11
SQL AlwaysONwith 3 AG Replicas
12
6SQL Server Patching (Stand Alone, SQL Clustered, SQL AlwaysOn)SP, Hotfix, CU
13
7PERFORMANCE TUNING.
Windows server---Windows Team
SQL Server--SQL DBA
DB Level--SQL DBA		Windows, SQL Server, DB Level
14
8Monitoring & Troubleshooting SQL Server, DB Issue.
15
9SQL Server HealthChecks, Migrations & Up-gradations.
16
10
SQL Server Environments Details, Ticketing Tools, Monitoring Tools.
Ticketing Tool: HPSM, ServiceNow
Incidents, Change Orders, SLA.
17
Environmental Details:Development, Pre-production/PPE/Stage,
Testing & Production.
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100