SQL Server 2008 is mostly in the domain of system and database administrators. But it's also a repository for data used by applications, which brings the product to those who aren't afraid of a little code. This new release has a lot of goodies that support application development directly.
The article continues at http://redmondmag.com/features/article.asp?editorialsid=2633