KC SQL: You Rock!
A big thank you to the Kansas City SQL Server Users Group for giving me their time and attention last night. Despite getting confused as to where the meeting was being held and thus being late (DOH!), I had a great time talk about the XML features in SQL Server 2005. The presentation download is here. The extra bit of code for loading a file directly into an XML column of table follows:
create table dbo.xmlDocs(pkid smallint identity(-32767,1) primary key,doc xml)
go
insert into dbo.xmlDocs
select * from openrowset(bulk 'c:\tmktx\Great BBQ joints in Kansas City.xml',single_blob) p
go
I'd especially like to thank Bill Graziano and Troy Schuh for making the arrangement and the nice gift. While we do this kind of stuff for the community, its really nice when a group goes out of their way to say thanks like these guys did. Also thanks to the nice folks at Idera for giving that group a license and 1yr of upkeep on their SQLSafe product and providing the pizza. I can't believe I missed a chance to snarf down pizza... next time, I'll double check the address.