Did you know that you can easily create a Pivot Table using a SQL Server query? Ever wonder if you could store XML documents in a field in your table, and then be able query data directly from the XML in all rows at once? How can you utilize Regular Expressions in order to help make querying data even more powerful? Ever need an easy way to get a row number returned as part of your SELECT query? SQL Server 2005 provides many powerful new features in the form of T-SQL enhancements and the ability to execute .NET code inside of the database (SQLCLR). This presentation will focus on some of the new functionality that developers can take advantage of in order to do more powerful processing on the database itself.

Jason Follas, President of the Northwest Ohio .NET User Group (http://www.nwnug.com), has over 10 years of professional experience developing for the Microsoft platform using Visual Basic and C#. He is a Technical Architect for Perficient, Inc. serving the Toledo and Detroit markets, and is a Microsoft Certified Professional (MCAD, MCSD.NET). Over the course of his career, Jason has worked on a wide assortment of projects for various industries, including an Aircraft Weight and Balance system, eCommerce websites, Risk Management systems, and optimization software. Hobbies and interests include Coin-Op Video Game restoration, emulation (in general), prime numbers and factoring, blogging (reading/writing), astronomy, and annihilating songs by attempting to play them on his guitar.