SNESSUG President
I've been crazy busy and I didn't mention this before, but last Wednesday I was elected (unapposed) to the post of President of the Southern New England SQL Server Users Group (SNESSUG).
Community Building
Building a community is hard. I'm one of the leaders of the Southern New England SQL Server Users Group, SNESSUG, a PASS affiliate. We've been going for just over a year. We were launched by the drive and initiative of one person, who got us going and then had to leave. We've been on our own for about four months now. It's been difficult without the drive of the founder, but we're getting the job done & moving things forward. Andy Leanard, MVP, Solid Quality Mentor, nice guy (for a DBA), has a series of posts that, while short, are very helpful guide-posts for those attempting to start a community or keep one running (read them bottom to top). If you're in that position or thinking about volunteering at your…
Presentation Last Week
Last week I presented at the Southern New England SQL Server User Group (SNESSUG) where I'm the Program Director. I presented from the book, Dissecting Execution Plans, that is supposed to be published any day now. I kept it basic and it flowed very well. The audience seemed receptive and there were a few questions. Mostly around figuring out what to do when you saw certain problems within the execution plans. Since that was the goal of the presentation, I was ready for most of the questions. I got stumped once on a Constant Scan operation. I finally looked it up this morning and feel silly. Here's the query: INSERT INTO [AdventureWorks].[Person].[Address] Â Â Â Â ([AddressLine1] Â Â Â Â ,[AddressLine2] Â Â Â Â ,[City] Â Â Â Â ,[StateProvinceId] Â Â Â Â ,[PostalCode] Â Â Â Â ,[rowguid] Â Â Â Â ,[ModifiedDate] VALUES ('1313 Mockingbird Lane'…