When: Thursday, August 11th, 2011, 6:30 PM - 8:00 PM
Social Time starts at 6:00 PM!
Who:
Jennifer Kenney
Jennifer Kenney is a Senior SQL Developer with Molina Healthcare. She
has been developing software professionally since 1990, and has
concentrated on databases in medical applications. She has twice been a
presenter at the Richmond, VA
Code Camp on issues in SQL Development. She currently lives in
Goochland, VA with a wonderful husband and two marvelous dogs and a cat
who is well above-average.
Abstract
Building a SQL Rules Engine – SQL is not the ideal platform for a
Business Layer, but sometimes you don't have much of a choice! The same
rules for performance apply here as would if you were coding in VB.Net
or C#: you want to encapsulate
your code and you want to read once, apply all your rules, and then
write the changes once. Unfortunately, SQL doesn't have the same tools
to expose multiple arrays of writeable data held in memory to multiple
procedures that exist in the .Net framework.
This presentation focuses on using the XML DML syntax to solve this
problem, allowing for quick reads and writes of in-memory data that can
be passed in and out of multiple black boxes, allowing for quick
processing and code encapsulation. The presentation
also features cartoons.
Where: Location: Markel Plaza
4600 Cox Road
Glen Allen, VA 23060 [map]
This Months Sponsor: