SQL SERVER Helpful Resources

1. Backup Compression (SQL Server)
2. SQL Server Storage Engine
3. Performance Data Collector for SQL Server 2008-Revealed
4. Data Collector in DQL Server 2008
5. Troubleshooting the Data Collector
6. Introducing the Data Collector
7. Administering Servers by Using Policy-Based Management
8. SQL Server Policy-Based Management Blog
9. SQL Server 2008: Transparent data encryption feature – a quick overview
10. Understanding Transparent Data Encryption
11. SQL Server Encryption
12. Understanding Extensible Key Management
13. SQL Server and Database Encryption Keys (Database Engine)
14. How to: Create a Database Master Key
15. SQL Server 2008 Auditing
16. SQL Server Audit Action Groups and Actions
17. Hot-Add CPU
18. Hot-Add memory
19. Managing memory for large databases
20. How to install SQL Server 2008
21. SQL Server 2008 Installation feedback
22. SQL Server Policy-Based Management
23. Using upgrade advisor to prepare for upgrades
24. Version and edition upgrades
25. Upgrading to SQL Server 2008
26. SQL Server Upgrade Advisor
27. Partitioned switching when indexed views are defined
28. Transferring data efficiently by using portioning switching
29. Backup Compression (SQL Server)
30. SQL Server 2008 Back-up Compression
31. PSS SQL Serve Engineers
32. SQL Server Extended Events
33. Using SQL Server Extended Events
34. Grouping Sets in SQL Server 2008
35. Grouping Sets equilvalents
36. Troubleshooting Group by error
37. Clustered Index Merge Showplan Operator
38. SQL Server 2008 – Merge Capability
39. Using MERGE in Integration Services Packages
40. MERGE (Transact-SQL)
41. Inserting, Updating, and Deleting Data by Using MERGE
42. Optimizing MERGE Statement Performance
43. Change Data Capture Tables (Transact-SQL)
44. Change Data Capture Stored Procedures (Transact-SQL)
45. Change Data Capture functions (Transact-SQL)
46. Change Data Capture SQL Server 2008
47. Table Valued parameters—SQL server 2008
48. Introducing Table-Valued Parameters – Part 1
49. Table Valued Parameters (Database Engine)
50. Table Valued parameters (ODBC)
51. SQL Server Replication
52. How do I find tutorials (Replication)?
53. Troubleshooting (Replication)
54. SQL Server Service Broker
55. Getting Assistance (Service Broker)
56. Troubleshooting (Service Broker)
57. SQL Server 2008 New Data Types
58. Spatial Indexing Overview
59. SQL Server 2008 Spatial Data types
60. Types of Spatial Data
61. SQL Server 2008: Using the Geometry Data Type to Work with 3 and 4 Dimensions
62. Spatial Ed blog
63. Use Sparse Columns
64. SQL Server 2008 Sparse Columns
65. Sparse Columns Support in SQL Server Native Client
66. Filtered Indexes Design guidelines
67. SQL Server 2008 Filtered Indexes
68. SQL Server 2008 Filtered Indexes vs. Index Views
69. Getting Started with Full-Text Search
70. SQL Server 2008 Full-Text Search: Internals and Enhancements
71. Best Practices for Integrated Full-Text Search
72. Full Text Search (SQL Server)
73. FILESTREAM Overview
74. Getting Started with FILESTREAM Storage
75. FILESTREAM Data type: SQL Server 2008
76. Getting Transaction with SQL Server 2008 FILESTREAM
77. SQL Server 2008 FILESTREAM FAQs
78. Using XML Data
79. Guidelines and Limitations in Using XML Schema Collections on the Server
80. Using XML with DATE, TIME, DATETIME2 & DATETIMEOFFSET Data Types
81. Managing XML Schema Collections on the Server
82. Using HIERARCHYID Data Types (Database Engine)
83. HIERARCHYID (Transact-SQL)
84. Working with HIERARCHYID Data
85. Tutorial: Using the HIERARCHYID Data Type
86. SQL Server 2008 – HIERARCHYID Part I
87. SQL Server 2008 – HIERARCHYID – Part II
88. Hierarchies with HIERARCHYID in SQL2008
89. Understanding Plan Guides
90. Designing and implementing plan guides
91. How to: Create a Plan Guide (SQL Server Management Studio)
92. New Plan Guide
93. Plan Guide Properties
94. Introduction to New Data Warehouse Scalability Features in SQL Server 2008
95. Partitioned Tables, Parallelism & Performance considerations
96. Partitioned Table in SQL Server 2008