Index

1. SQL Architecture
2. New Features (2000-2005-2008-2008R2-2012-2014-2016-2017-2019)
3. What’s New in SQL Server 2019 since SQL Server 2005, 2008, 2008R2 , 2012, 2014, 2016, 2017
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. SQL Server Isolation Levels with examples
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. Prerequisites for Database Mirroring
39. Prerequisites for Configuring Log Shipping
40. Prerequisites for Installing SQL Server AlwaysOn
41. Difference between in-place & Side by Side Upgrade of SQL server
42. Configure Replication Of Database Which Is Part Of AlwaysOn Group
43. SnapShot Replication Configuration
44. LOG SHIPPING VS. MIRRORING VS. REPLICATION
45. Difference between in-place & Side by Side Upgrade of SQL server
46. Upgrade SQL Server 2005 to SQL Server 2008
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.

55.