August 2007 Entries
Last year's CodeMash turned out to be a phenomenal event, and I'm proud to have played a part of the crew that was able to bring it together. If you haven't heard yet, we're currently planning CodeMash 2.0.0.8 which will take place January 9-11, 2008 at the same venue (the Kalahari Waterpark Resort in Sandusky, OH - an indoor waterpark with an awesome conference facility that also serves particularly well as a great family destination in the middle of winter).
If you have never heard of CodeMash before, then take moment to review the information on the website (which has been updated for...
This article was prompted by a question from the audience about the internals of XML Indexes. In particular, they were interested in where the internal system table used by Primary XML Indexes is stored, and what might happen to this index if the database is detached and then reattached on another server.
http://www.jasonfollas.com/wiki/SQLXML_Tricks_XMLIndex.ashx
Note: I will likely continue to expand on this particular article to include information about secondary indexes and when to use each type.
The Day of .NET in Ann Arbor has been a successful spring conference for two years now. So successful, in fact, that we have been asked about why we don't hold it twice a year. /shrug
So, by popular demand, there will be a Day of .NET in Ann Arbor on October 20, 2007 as Washtenaw Community College. The Call for Speakers is currently underway (as well as the sponsorship drive for those of you with a corporate checkbook).
Details can always be found at: http://www.dayofdotnet.org
An audience member asked me if there was a way to be able to determine the element names that exist within the XML stored in a table. His business problem was that he archives XML in a field of a table, and needed to identify whether one row's XML contained a different set of elements than another row's (i.e., if an untyped XML's "schema" changed between versions).
In this article, I demonstrate T-SQL and XQuery syntax that will generate a table structure containing a list of element names (per primary key value). From this point, "traditional" querying can be used...
Every new blog needs that obligatory awkward first post that says, "Here I am!" This is that post.
For those who joined the party late, I used to blog at http://jasonf-blog.blogspot.com. That blog will be left intact, so long as Blogger.com keeps hosting it. I will likely bring some of the long-form articles over to this new domain and publish them on my wiki so that they don't get lost due to inactivity.
Anyone who subscribed to my old blog's feed through Feedburner should automatically be reading the new blog's content.