TAILIEUCHUNG - SQL Server 2008 DBA

Table of Content Introduction to SQL Server 2008 What‘s New in SQL Server 2008? SQL Server 2008 Architecture Pages and Extents Files and File groups Memory Architecture Thread and Task Architecture Installing SQL Server 2005 SQL Server 2008 Installation Case Study/Practical Troubleshooting Upgrading the SQL server Configuring SQL Server Managing Database Services Case Study: Rebuilding System databases Case Study: Server Collation in SQL Server 2008 | Table of Content Sr. No. Particular Page No. 1. Introduction to SQL Server 2008 3 2. What s New in SQL Server 2008 9 3. SQL Server 2008 Architecture 11 4. Pages and Extents 17 5. Files and File groups 19 6. Memory Architecture 21 7. Thread and Task Architecture 25 8. Installing SQL Server 2005 27 9. SQL Server 2008 Installation 35 10. Case Study Practical T roubleshooting 43 11. Upgrading the SQL server 47 12. Configuring SQL Server 63 13. Managing Database Services 79 14. Case Study Rebuilding System databases 85 15. Case Study Server Collation in SQL Server 2008 87 16. Migrating SQL Server 89 17. SQL Server Security 129 18. Automating Administrative Tasks 141 19. Monitoring SQL Server 157 20. Transaction Log Architecture 163 21. Bac kup Restore 169 22. Log Shipping 185 23. Database Mirroring 199 24. Database Snapshots 211 25. Replication 219 26. SQL Server Clustering 249 27. Table Index Architecture 283 28. Performance Tuning 293 29. Isolation Levels in SQL Server 2005 331 30. Understanding SQL Server s DBCC SHOWCONTIG 341 31. Frequently Asked Questions 347 1 Page 2 .

• SQL Server 2008 DBA
• SQL server Configuring SQL Server
• Extents Files
• Rebuilding System
• Managing Database Services