A little cheap thrill for me. I passed 50,000 views on the blog yesterday. Thanks to everyone who has stopped by to read my fumbling attempts to understand SQL Server better. I hope some of the posts have proved useful to you. I learn a lot from putting them together.
It is rapidly coming up on election time at the Professional Association of SQL Server users (PASS). Once more, a person I respect and admire is running for office. Tom LaRock has been a volunteer with the organization longer than I have (I’m approaching four years) and for the entire time I’ve been involved he’s been in the thick of things, working for the organization and working with the other volunteers. He does great work. He’s presented at the Summit, three times I think, and he’s presenting again this year. He’s one of the people chiefly responsible for the new Virtual Chapters. He’s been serving on the Board as an appointee. I think it’s finally time to make it official and elect this great guy to the board. He’ll do a good job, as he has done, and he’ll be able to do more because, rather than worrying about running for office, again, he can strap in & work hard for two years if he gets elected.
Tom’s going to be hosting live chats where he’s going to answer your questions about his plans for his time on the board. If you have any doubts that he’s the right guy (and he is) or you don’t know Tom, get on over there and listen to what he has to say.
To see the other candidates (not a slouch in the bunch, but I’m backing Tom), go on over to the campaign space and see what they have to say for themselves.
I presented last night at the Cape Cod .NET User’s Group. What a great bunch of people. About 20 people showed up at the nice facility they’re using, Venture Think Together. A little pizza and a little chat and the meeting got started. Marcia McLean, their president, gave me a nice little introduction and I went through my slides. As I did them, I kept thinking about some of the advice offered up by Brent Ozar yesterday. Suddenly my slides seemed so wordy. It started to throw me off, but I just ignored it & plowed on. Overall, I think the presentation went well. I hit a couple of snags on some of the examples that I’m going to tweak before I present this at the PASS Summit in just a few weeks.
Tomorrow night, Wednesday, September 23, I’m going to present on “Best Practices for Working with SQL Server Execution Plans” for the Cape Cod .NET User’s Group. It’s basically a rehearsal for the presentation that I’ll be doing at the 2009 PASS Summit in just 5 weeks. Can you believe it’s already almost here? I’m so jazzed. This year is going to be a great summit. I can’t wait to see everyone again… I… Where was I, oh yeah, come down to Hyannis if you can make it. It should be a fun evening. Not quite as good as the Summit, but a good time.
I don’t generally do lots of blog aggregation and cross post linking & stuff. It’s just not something I’m that into. However, this time is an exception. Gail Shaw, Gila Monster to those who hang on out SQL Server Central, has posted an excellent explanation of times when Estimated and Actual row counts vary for a reason. I’m one of those who emphasises that differences between estimated & actual is an indication of… something. It could be out of date or missing statistics or it could be caused by query language like multi-statement table valued functions, but it’s usually and indication of a problem. Except when it’s not. Read Gail’s explanation for more.