codegumbo

Laissez Les Bon Code Roulez!

• Home
• About Me
• Code, etc.

Archive for the ‘XML’ Category

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 · No 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? Tweet This Post

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

• 

• Archives

  • September 2010 (1)
  • August 2010 (3)
  • July 2010 (5)
  • June 2010 (3)
  • May 2010 (4)
  • March 2010 (1)
  • February 2010 (2)
  • January 2010 (2)
  • December 2009 (1)
  • November 2009 (3)
  • October 2009 (12)
  • September 2009 (8)
  • August 2009 (3)
  • July 2009 (7)
  • June 2009 (3)
  • May 2009 (10)
  • April 2009 (9)
  • March 2009 (8)
  • February 2009 (8)
  • January 2009 (7)
  • December 2008 (21)

• AtlantaMDF Reviews

  • Kick some SSAS - Expert Cube Development with Microsoft SQL Server 2008 Analysis Services 2010-08-06
    Recently finished (cover-cover) reading of Expert Cube Development with Microsoft SQL Server 2008 Analysis Services. Since then I've gone through a number of chapters several times as topics aligned themselves with work efforts. Looking at this book today, I noticed the covers are all curled, the pages dog-eared, and yellow highlighter is visible across […]
    DBAMark
  • SharePoint 2007 Developer’s Guide to Business Data Catalog 2009-11-24
    SharePoint 2007 developer’s Guide to Business Data Catalog is an essential guide to anyone who wishes to become proficient in building complex SharePoint applications. This book starts off assuming that the reader is a complete beginner to BDC, and explains in detail what it is. Soon afterwards, the reader is taught what can be done with it and how.The book […]
    wildcat
  • The Art of Unit Testing 2009-11-08
    As a Database Architect, I often work with Object-Oriented Programmers, but thankfully don’t often have to code in other languages other than SQL.  However, it is useful to understand the methods and basic frameworks by which my team members develop; hence, I decided to review Roy Osherove’s The Art of Unit Testing (Manning Press, 2009).  Although many of th […]
    Stu

• Recommended Reading

• BlogRoll