Archive for the ‘XML’ Category
Iâ€™m continuing my study of XML and XSDâ€™s for January, and I realize that I ended my last post a bit abruptly. I explained that I can cast an XML datatype to a SQL Server datatype, without giving a lot of background on WHY thatâ€™s important. Understanding Types. Without going into too much detail about [...]
As part of my New Yearâ€™s resolution for 2011, I vowed to do a deep-dive on something technical every month; for January, Iâ€™m focusing on XML. Iâ€™ve been using XML and XQuery in SQL Server for a while now (even presenting on it), but I still donâ€™t consider myself an expert in the area. For [...]
I recently helped a friend solve an XML problem, and thought I would post the solution here. Although there are lots of notes on how to use XQuery in SQL Server 2005+, this was a real world scenario that was trickier than I expected. The friend works for an insurance company broker, and in one [...]
QuickÂ note:Â I’ll be presenting my thoughts on XML and relational design at next week’s meeting of AtlantaMDF.Â If you’re in the area, please come join us for free pizza and education. http://atlantamdf.com You Got XML In My Database? What’s Up With That?
I know it’s short notice, but to be honest, I totally forgot about this until a couple of weeks ago.Â I’ll be presenting today at noon eastern on a LiveMeeting for the Application Developers Virtual Chapter of PASS.Â Deets below: “You Got XML In My Database? What’s Up With That?” MayÂ 11th 12:00 PM EDT (GMT [...]
I’ve been working on a project recently that requires using XML in SQL Server, so I’ve been searching the web to find references. Books Online is unusually obtuse on this subject (the samples are sub-par for this complex subject), so I’ve been trying to find good examples of how it works. Here’s some of the [...]
Not sure how to classify this bit of useless knowledge, but I’m putting it out there in case it sparks some-one’s creative interest.Â Most of my day job entails parsing firewall syslog data; syslog may be a standard method of streaming data from a firewall, but there’s really very little standard about what is contained [...]