Archive for the ‘XML’ Category

Something new for 2011: XML & XSD, part 2

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 [...]

January 31, 2011 · stuart · No Comments
Posted in: Something New, SQLServerPedia Syndication, XML

Something new for 2011: XML and XSD

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 [...]

January 10, 2011 · stuart · 4 Comments
Posted in: Something New, SQLServerPedia Syndication, XML

Querying XML in SQL Server 2005+: namespaces

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 [...]

September 1, 2010 · stuart · 2 Comments
Posted in: SQL, SQLServerPedia Syndication, XML

Speaking at Atlanta.MDF on Monday, June 14

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?

June 9, 2010 · stuart · No Comments
Posted in: SQL, SQLServerPedia Syndication, User Groups, XML

Speaking today: PASS AppDev Virtual Chapter

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 [...]

May 11, 2010 · stuart · No Comments
Posted in: PASS, SQL, SQL Server, SQLServerPedia Syndication, XML

SQL Server & XML: links of interest

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 [...]

May 14, 2009 · stuart · No Comments
Posted in: SQL Server, SQLServerPedia Syndication, XML

it’s all in how you look at it…

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 [...]

December 4, 2008 · stuart · No Comments
Posted in: XML