Look at the core components of SQL Server that are used to build applications (e.g. SSIS) and when to use them.
Ewan Fairweather currently works as a Program Manager in the Business Platform Division (BPD), where he works on the Customer Advisory Team (CAT) focusing on BizTalk, other application tier technologies and SQL Server. Prior to this, Ewan spent three years working for Microsoft UK in the Premier Field Engineering team. Ewan co-authored the successful Professional BizTalk Server 2006 book and has written many whitepapers for Microsoft including the Microsoft BizTalk Server Performance Optimization guide which is available on Microsoft’s MSDN website.