SQL 2005 comes with some really great support for handling XML natively. In this post I show how you can easily take XML data like an RSS 2.0 feed and using the new xml data type methods, select specific XML information that can then be inserted ('shredded') into a database.

SQL server user-defined functions (UDF) for converting to and from the RFC 822 DateTime format.