There is a very interesting article about how MSDN 2 utilizes SQL Server 2005 technologies, specifically Service Broker and CLR integration. The article goes into why certain decisions were made and how the asynchronous messaging available with Service Broker is a natural choice for this content aggregation system. It's certainly something that could be looked at as a model by others trying to build similar applications. Here's a link to the article:
Inside MSDN: Building the MSDN Aggregation System
Technorati Tags: T-SQL |
SQL Server |
Microsoft SQL Server |
SQL Server 2005
IT Security, MySQL, Perl, SQL Server, and Windows technologies.