|
Free .NET USER GROUP MEETING
When: Tuesday, January 3rd, 2006 at 6:00p.m
Where: UCONN Stamford Campus
Topics: XML in SQL Server 2005: Part I The XML Data Type
XML in SQL Server 2005: Part II Using XQuery to Query and Manipulate
Speaker: Stephen Forte, Chief Technology Officer and co-founder of Corzen, Inc |
|
Overview:
Blogs, Web Services and general interoperability has proliferated the use of XML in recent years. With all of that XML out there, there needs to be an easy way to incorporate XML data with SQL Server relational data. SQL Server 2000 introduced the FOR XML clause that produces XML from relational output and SQL Server 2005 greatly enhances that. What SQL Server 2000 lacked was a native way to store and work with XML, you were reduced to storing XML in a TEXT field. SQL Server 2005 has a new intrinsic XML data type that can be used in tables, variables, stored procedures, etc. The advantage is that you can use a whole range of XML Technologies inside of SQL Server that you could not use before including the ability to validate with XML Schema (XSD) and create an XML index for use with XPath and XQuery statements. This session will explore all of the XML technologies of the XML data type, including XML Indices, XQuery, XPath and XSD.
Speakers Bio:
Stephen Forte is the Chief Technology Officer and co-founder of Corzen, Inc, a Manhattan (USA) based provider of online market research data for Wall Street Firms. Stephen is also the Microsoft Regional Director for the NY Metro region as well as an MVP and INETA speaker. He speaks regularly at industry conferences like Tech*Ed, North Africa Developers Conference and other conferences around the world. He is an author of Programming SQL Server 2005 (MSPress) as well as other books on application and database development. Prior to Corzen, Stephen served as the CTO of Zagat Survey in New York City and also was co-founder and CTO of the New York based software consulting firm The Aurora Development Group. He currently is the co-moderator and founder of the NYC .NET Developer User Group. Louis Edouard, CITI's Director of technology, will facilitate the meeting.
The Connecticut Information Technology Institute (CITI) has joined with the International .NET Association (INETA),a non-profit, independent organization, chartered with supporting all user groups interested in the Microsoft. NET platform. INETA is supported by Microsoft Corporation and other sponsors, and provides structured, peer-based organizational, educational, and promotional support to the growing worldwide community of Microsoft® .NET user groups. All facets of the .NET user community, from developers and architects to project managers and IT professionals are welcome. |