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

 

DevelopMentor

Stuff related to or about DevelopMentor. Filtered for your sanity.

Using Signed Assemblies for SQLCLR: Doing the Safety Dance.

You know that song. Yes, that song. The beeping. The arm flailing. The Safety Dance. I so wanted it stay in the 80s – along side the uncounted Wild Turkey inflicted hangovers. It just won’t. Every now and then that damn beeping rhythm creeps into my conscious thought when I least need it to. Like today. I’ve been trying to figure out how to use the last-minute-added ability to catalog signed assemblies that need External Access or Unsafe permission without having to set the database...

The first rule of Talk Club is not to talk about the rules of Talk Club

Offered without comment as none is needed: The brain reacts in exactly the same way when a talk goes wrong. You see an error on the screen that you’ve never seen before. Your demo has broken on a line that you don’t remember writing. For some reason, the error message is in Greek. Your forehead tingles as blood floods the capillaries, flushing your face in seconds and turning it into an I’M A F***CKING IDIOT beacon for everybody to see. Sweat creeps out of glands in places you didn’t...

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

 

 

Copyright © Kent Tegels