SQL Server, PASS, and other data mishaps
Archive for year 2010
I received my diagnosis
Aug 19th
Luckily, I didn’t have to pay a single thing for it.
Brent Ozar unwittingly made the diagnosis the other day in a comment on Stuart Ainsworth’s blog (I shortened it a bit)

Since I have served on both of those PASS Committee’s (Program Committee as a leader) I must be insane.
I mean, no one willingly jumps in front of that many bullets, at least not for long. Whether he meant it or not, Brent is right though, when you put yourself into one of these types of committee’s you truly are opening yourself to all sorts of bullets. This sort of “target practice” has been one of the toughest things for me to learn how to deal with as a PASS volunteer. The good news though, is that its amazing what it will do for you professionally, its one thing when your “favorite” developer is firing Air soft bullets in disagreement with you, its quite another when leaders of the SQL community who you have a huge amount of respect for start firing .50cal’s.
Many of my companies developers (several hundred total) have commented to me in the last few years that I have “mellowed” out a bit, a few of them have laughed and blamed it on old age, but in reality, I know its a side effect of serving in very public roles within the PASS Community.
PASS Summit Community Choice Session results revealed
Aug 16th
This year the Program Committee decided to try something different to increase community involvement with the abstract selection process for the annual summit. We decided to allow any registered PASS members to vote on the final 4 community sessions to be presented at the Summit in Seattle this year. With our historically low turnout in surveys of our membership, I turned to the team at PASSHQ with a simple question about whether or not we could use the same voting tool that is in place for the upcoming Board of Directors election. Considering our surveys have traditionally resulted in 300-500 results , at the time I put a personal goal on the survey response rate of 500, anything greater than that and I would consider the time and energy It took to put it together a win, anything less and well, we wouldn’t be doing any more exploring in the use of public voting for Summit Sessions.
I’m VERY pleased to say that by all indications, the voting process was a great success, sure we will always aim to do better but, for now, having over 1100 people vote on what they want to see at the Summit is a huge win for PASS as an organization. In the App Dev group, the winner was declared by 2 votes. 2 votes out of 600 is pretty outstanding, if you didn’t take the time and vote, you could have been the vote that swayed the result!! Don’t miss your chance next time!! The winning sessions can be found here.
I want to take the time to thank each and every member of the awesome PASS Community who voted. As well as Jeremiah Peschka (Twitter|Blog) & Lori Edwards (Twitter|Blog) for dealing with my crazy ideas on putting this together, and keeping me in check. Andy Warren (Twitter|Blog) for helping me get the voting tool he built for pass working for this use. Id also like to give a huge thanks to Hannes, Wesley and Elena at PASSHQ for helping bring all of this to PASS (pun intended)
Shadows Rock, Filtering Platform not so much!
Aug 16th
RDP remote control (shadowing) of multiple sessions is a great way to allow geographically separated teams to work on the same Server console. You can do this from task manager
Today I had a new install of windows 2008 that was rejecting the attempts at remote control, the error was ”remote control failed”, nothing was logged in the System or Application event logs. In the Security event log was only one error: “The Windows Filtering Platform has blocked a bind to a local port”
After plenty of fiddling and making sure there was no ”firewall” or reason for the filtering platform to be enabled, I came across this command I never knew existed “shadow”
Apparently whatever had the filtering platform angry and blocking access was ok with that simple command. So in this case going to a command window and running “shadow 3” worked perfectly, I could once again see both terminals and the windows filtering platform allowed me to actually work, instead of impeding me at every turn.
The Windows Filtering Platform on Server 2008 and 2008 R2 has been the culprit more times than I can count lately when the “gremlins” are inhabiting our servers, If only there were a way you could turn it off totally, but I guess that’s sort of like Internet Explorer, it cant be unbundled from the OS.
Dont forget to vote for the PASS Summit Community Choice sessions
Aug 12th
If you are a PASS member, on August 3rd you should have gotten an email inviting you to vote on four of the sessions to be presented at the 2010 PASS Summit.
There are some great sessions up for selection, You can review them here.
If you havent voted yet, be on the lookout today for a reminder. You should get an email with personal links to vote, it will only take a few minutes of your time and your opinion counts!
If you’ve already voted, I want to thank you, if not please take this time to do so. If we can get enough community interest in this process I can see it growing and morphing into something more so while your opinion counts on the actual selections, your vote can also help shape the future way PASS does session selections.
More on PASS Summit Community Choice sessions & a general PASS update
Jul 30th
More on PASS Summit Community Choice sessions
Last week I posted about letting the PASS membership select 4 of the Community sessions to be presented at this year’s North American Summit. As with most things I’ve touched lately, the devil is in the details. I have been working with PASS HQ quite a lot to get this process all ironed out. As of today, We are expecting the emails with all of the details to go out in the first part of next week. One of the last minute *details* we’ve had to account for is related to asking community members to vote in the 4 different categories, it turns out we aren’t able to require it to work that way. The short reason why is because of the way the PASS voting solution is designed (remember, its actually designed for voting in the upcoming BOD election) We cant have 4 separate categories and allow you to vote only in 1 each. While we are still separating the sessions into categories and asking you to vote on each one separately, we wont be able to enforce it. As it turns out, its not that big of a change and even if our members choose to cast their votes all in the same category, their votes will simply be cancelled out since we are going to choose the highest vote getter in each of the categories. So start watching those email boxes for more detailed information!
Other PASS goodness
Summit Selection Process follow-up meetings, since shortly after the community selection process finished, I have been on phone conferences with the selection teams for feedback about the entire selection process. These meetings have been going great, and overall the feedback was extremely positive, both about the process and the volunteer experience in general. That’s not to say the team members weren’t critical of a few hiccups we experienced but overall it was good. In these meetings nothing was off-limits, and I got some GREAT new ideas that should really improve a few of the key procedural pieces of the process. Many of the technological limitations and issues we knew about going into the selection but, with all the timelines, we just couldn’t get changes made quick enough. Since PASS is building a summit management tool for 2011, we should have many of those technology issues behind us for the start of next year’s selection process. All in all, It always helps us to get feedback about the selection as soon as its over while its still fresh in everyone’s minds. the #1 piece of feedback that kept recurring is: Communication is key. What I have taken from this is that even if you think everyone’s on the same page, its often ok to ask again if there are any questions, better safe than sorry.
Microsoft Speaker selections, Ive been doing this for the last 4 years and this year was the first year where I felt like we (the community team) have been actively engaged with the Microsoft Selection process, we’re still trying to figure out how all the different pieces fit together and where we can add value and community feedback into their processes. So far things are working better than I expected but not as good as I’d like. Seems to be the story of my life these days!!! All of this is great news for the community since it will produce a better Summit but, its been bad news for myself and the other volunteers working on it. For me, being the pseudo ring leader, Its just 1 more thing added to an already full plate this time of year. From the day the call to speakers is announced to the date the summit actually starts, is when things get pretty hectic with the Program Committee, there are always a few “regularly scheduled items” that have to be completed by certain deadlines not to mention the things that go BOOM. The regular scheduled stuff isnt a big deal, the BOOM’s on the other hand, lets just say Disaster Recovery planning isn’t just for Databases or Computers, it is valuable in most any important process.
