Posts From May, 2017

-July 2025+
SMTWTFS
293012345
6789101112
13141516171819
20212223242526
272829303112
3456789
  • RSS
  • Add To My MSN
  • Add To Windows Live
  • Add To My Yahoo
  • Add To Google

Statistics

  • Entries (106)
  • Comments (0)

Archives

Will it Shred? The utter basics of XML in SQL Server. 

FWSSUG NEW SPEAKER - Forrest McDaniel
Posted by altadmin Tuesday, May 16, 2017 11:44:00 AM
Meet & Greet at 6:30PM Presentation at 7PM
Please join and RSVP at our FWSSUG MEETUP page!

Abstract: For SQL Server folk comfortable with relational data, XML is an unavoidable evil. SQL doesn't work on it, and nested substrings are awkward, so how can we shred it?
In this presentation I cover the basics of handling XML. I briefly review what XML is, and point out where we commonly see it. I show basic XPath, touch on XQuery, and spend the bulk of my time demoing the main methods in T-SQL for applying XPath to XML.
Bonus topics include XML schemas (and why they actually matter), XML indexes, and a CLR demo.

Bio: Forrest McDaniel
I've only been a DBA for two years, so don't take my word for anything!
Before this new career I was a teacher and tutor, so I love explaining concepts, especially math.
Site Map | Printable View | © 2008 - 2025 Fort Worth SQL Server Users Group | Powered by mojoPortal | HTML 5 | CSS | Original design by Andreas Viklund