SQL Server 2000 Constraints and scripting in Enterprise Manager

Recent post at SSC that I found the need to reply to - it eventualy lead to talk about scripting out of enterprise manager. I wanted to talk about the pitfall of EM chaning the constraint signature when scripting this out.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=342753&post=true

Southern New England SQL Server User Group

I would like to invite everyone in the Southern New England area to become a member of SNESSUG (Southern New England SQL Server User Group). Myself and fellow colleagues have created this group and we are now a recognized PASS chapter http://www.sqlpass.org/.

We are new so bear with us as we work out the kinks. We will be creating a web site listed under the sqlpass.org site listed above. Membership is free and the meetings will be held on the SECOND Wednesday of every month. If you are interested in more information contact me at finalist2@comcast.net and I will be happy to answer any questions you may have.

TSQL Training - Well worth my time

Since my last posting I had the pleasure of attending a week long course on Advanced TSQL Programming. This course was taught by Itzik Ben-Gan founder of Solid Quality Learning (S.Q.L). Anyone who has had the opportunity to attend a course taught by Itzik will certianly confirm my feelings that Itzik is a fantastic teacher and has an incredible command of the subject matter. I also urge anyone with a SQL background to pay attention to Itzik's postings and comments in the world of all things SQL Server; he is an amazing individual and a major contibuter to the SQL Server community. Itzik, thank you for an amazing course and keep up the great work, it was an absolute pleasure to learn from one of the best in the field!

Here is a link to Itzik's site : http://www.sql.co.il/books/insidetsql2005/