PASS Data Architecture Virtual Chapter RebornThe PASS Data Architecture Virtual Chapter had its first official meeting and presentation in October 2010. Not much happened after that. The founder and leader of the virtual chapter found himself unable to dedicate his time to the chapter and earlier this month, he sent an email to the rest of the group who had signed on to help stepping down from the chapter. The other members of the group decided on new chapter co-chairs, Lorra Newton (@lorranewton) and Thomas LeBlanc (blog|@TheSmilingDBA).
I signed on as site admin and was up late last night customizing the site. Please ping me with any feedback you have on the site or the layout.
Next Meeting Announced
|Start Time:||Thursday, April 21, 2011 12:00 PM US Central Time (6:00 PM GMT)|
|End Time:||Thursday, April 21, 2011 1:00 PM US Central Time (7:00 PM GMT)|
|Presenter:||Thomas LeBlanc (blog|@TheSmilingDBA)|
|Live Meeting Link:||https://www.livemeeting.com/cc/usergroups/join?id=28NR92&role=attend&pw=PTSs%26%5E%282Z|
|Database Standards SOP
Join Normalization nut Thomas LeBlanc for a review of a standard operating procedure used among DBAs at an employer. See the changes he made after joining the BI group at this employer. The session will go through naming conventions, check list for creating a table, formatting in stored procedures, and more. A brief preview of the SQLRally talk 3rd Normal Form: That’s Crazy Talk!!! Will be given about Lookup tables. This discussion comes from 21+ years of developing databases for application developers. The use of identity columns for primary keys, and the need for a unique constraint on transaction tables that do resort to ID columns will be covered.
Thomas is a semi-retired Senior DBA turned ETL Lead Architect @ Amedisys in Baton Rouge, LA. Worked in the IT field for 21 years experience w/ COBOL dBase, FoxPro, Visual FoxPro, VB 3 thru 6 and .Net(C#). Designing and developing Normalized & Dimensional database has become his passion. Full-time DBA work started about 9 years ago. he has been blessed with speaking at SQLRally this year. Free time is spent helping other & improving his relationship with family & God.
|Add to your calendar|