1.
SQL Server Database Healthcheck report HTML Format From multiple servers
2.
3.
4. SQL Server Features (2000-2005-2008-2008R2-2012-2014-2016-2017-2019)
5. Version History
6. SQL Server Code Name List
7. Difference between Enterprise and Standard Editions
8. Working with System Databases
9. SQL Server Roles & DB Roles
10. Backup, Restore & Recovery
11. Compress database backups in SQL Server 2000 & 2005
12. Compatibility Level
13. ACID Properties
14. Checkpoint
15. Pages
16. Indexes
17. Locks
18. Isolation levels
19.
20. Brief about SQL Server Service Broker
21. Maintenance Plans
22. Log Shipping
23. Mirroring
24. Replication
25. SnapShot Replication Configuration
26. Always on Configuration
27. Ports used in SQL Server
28. LSN
29. Temp DB trouble shooting
30. DBCC Commands
31. Performance Counter and Values
32. Clustering
33. SPN
34. Query Store
35. Trace Flags
36. TDE
37. Scripts
38.
39.
40.
41. Difference between in-place & Side by Side Upgrade of SQL server
42. Configure Replication Of Database Which Is Part Of AlwaysOn Group
43.
44.
45.
46.
47. Brief about SQL Server Service Broker
48. Trouble Shooting.
49. Capacity planning
50. Components of the SQL Server Engine
51. Data Masking
52. Rebuild MASTER DB
53. DB Mail
54. SQL Server Column Level Permissions.
55.