Blog Stats
  • Posts - 7
  • Articles - 1
  • Comments - 38
  • Trackbacks - 2

 

January 2006 Entries

Tag, I'm it!

Yeah, I'm jumping on the Four-Things Tag-wagon. Four jobs I’ve had in my life: Developer (Geek) System Analyst (Nerdy Geek) Enterprise Software Architect (Business Nerdy Geek) Instructor (Talking Head Geek) Four movies I can watch over and over: Patton -- “You want to know why this outfit got the hell kicked out of it? A blind man could spot it. They don't act like soldiers; they don't look like soldiers; why should they be expected to fight like soldiers? “ Shichinin no Samurai...

Shreding XML with XQuery

Over on the Microsoft.Public.SqlServer.XML newsgroup, one Chris Kilmer asked a good question about how to shred a single XML document into multiple tables using multiple stored procedures. Chris's goal with this was to have each stored procedure update one table and pass the XML remaining nodes of the first document off to the next stored procedure. This is actually fairly easy except for one thing: maintaining referential activity between inserted elements. The XML involved is fairly simple: <Invoice>...

Emeril seems, at all times, dangerously close to actually copulating with the food he prepares...

And you'd thought you'd find *IT* Geek content here? You will... eventually. Promise. But now that I have your attention1... Welcome to the new home for my Techno-Geek Foodie blog “Enjoy Every Sandwich.” I'm Kent Tegels, the Database Curriculum Lead for DevelopMentor. I've been blessed by Microsoft as a Most Vaulable Professional for SQL Server since 2004. So as you can guess, this blog is mostly going to be about .NET, SQL Server and the communities involved with those tools. Well that...

 

 

Copyright © Kent Tegels