Wednesday, November 15, 2023

SQL-Home

1.SQL Architecture

SQL Server Database Healthcheck report HTML Format From multiple servers

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
20Brief 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.







Popular Posts