Posts From May, 2017

-October 2018+
SMTWTFS
30123456
78910111213
14151617181920
21222324252627
28293031123
45678910
  • RSS
  • Add To My MSN
  • Add To Windows Live
  • Add To My Yahoo
  • Add To Google

Statistics

  • Entries (105)
  • 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 - 2018 Fort Worth SQL Server Users Group | Powered by mojoPortal | HTML 5 | CSS | Original design by Andreas Viklund