I have 7 yrs of experience in SQL (As a developer as because it is used as back end of my projects). I would like to become an architect. For that what are all the features /concepts that I must be familiar with in SQL. Please do share if any document/resource/link that you followed to become familiar with the same.
NOTE: The list could include advanced features in SQL 2008, Management studio, Advanced Features/concepts with examples and so on.
Thanks in advance.