Geeks With Blogs
A Developer's Expedition May 2008 Entries
Philly Code camp 2008.2 success!!!
The Philly Dot Net user group pulled off another successful code camp. This time around over 350 people showed up to get their free training on a variety of subjects. I would like to thank everyone involved and all participants for making this such a success! I would also like to thank everyone that attended my session on Developing the Blueprint for Enterprise Architecture. You guys had some good questions!!! I hope you liked the exercises and I hope you gained more insight to the process of designing ......

Posted On Sunday, May 18, 2008 12:53 PM

Code Camp 2008
Our second installment of the 2008 Code Camp series will be held at the DeVry University campus in Fort Washington, PA on Saturday, May 17 from 8:30-5:00. Please register on our web site.-->Detailed directions are on the DeVry web site. sold out. There will be another Code Camp in May.--> Lots of code, just say no to slides! 8+ hours 40+ sessions (8:30, 10:00, 12:30, 2:00, 3:30) 8 tracks + lunchtime entertainment 500 seats with tables (laptops welcome) Free breakfast, lunch, ......

Posted On Friday, May 9, 2008 8:33 PM

SQL 2005 Schema change auditing
You have to love the xml type in SQL Server 2005. Here's a simple way I found to make use of it: You can audit all the object/schema changes to the database with a simple database-level trigger. First, create a very simple table (inside a schema I name 'Audit'): CREATE TABLE [Audit].[Objects]( [EventID] [int] IDENTITY(1,1) NOT NULL, [EventData] [xml] NULL, PRIMARY KEY CLUSTERED ( [EventID] ASC ) WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] Then, the trigger: CREATE TRIGGER [Trig_AuditObjects] ......

Posted On Thursday, May 1, 2008 9:33 PM

Copyright © Ken Lovely, MCSE, MCDBA, MCTS | Powered by: