Contact Richmond SQL Server Users Group for event and ticket information.

Looks like this event has already ended.

Check out upcoming events by this organizer, or organize your very own event.

View upcoming events Create an event

RSSUG - Jennifer Kenney - Building A SQL Rules Engine

Thursday, August 11, 2011 from 6:30 PM to 8:00 PM (ET)

Glen Allen, United States

Ticket Information

Type End     Quantity
Richmond SQL User Group Ended Free  
SHARE THIS EVENT

Event Details

Jennifer Kenney - Building A SQL Rules Engine

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]