Building a PASS Voting Solution – Part 5

Today we move over to the web side of things. I put this together with VS 2010, and it’s a single aspx page with a single class and a user control. I’m using DevExpress controls (they provide me with a free subscription, good stuff). Here’s the normal view that a voter will see if they’ve […]

Building a PASS Voting Solution – Part 4

We’re almost at the end of the SQL side of things, just needing to send out notifications/reminders. I was torn here, I already had a proc to send a link to a single user, but using it here would mean a loop. Even if it was slow it wouldn’t matter, we do a handful of […]

PASS RSS Feeds

Another “didn’t know” for me, we have multiple feeds from PASS HQ that focus on various areas – grab the entire list from http://www.sqlpass.org/Home/RSS.aspx.

PASS 2010 Election Nominating Committee Announced

Actually came out last week and I missed it, here is the link to the details of the nominating committee led by Immediate Past President and Big Kahuna Wayne Synder! Call for nominations will open June 23, 2010 – watch sqlpass.org for details on that.

SQLSaturday Schedule Changes

As will happen from time to time, we’ve had two changes on the schedule, wanted to make sure everyone catches them so as not to show up and have no one there! SQLSaturday #45 in Louisville has been moved to January 22, 2011. This will be their second annual event, in the snow this time! […]

Building a PASS Voting Solution – Part 3

Today we’ll look at the server side code portion of the solution. I’m definitely in favor of stored procs, so that’s what you’ll see here. I typically only handle errors within a proc if I have the ability to do something there to fix the problem, otherwise I raise them back to the application. I […]

Building a PASS Voting Solution – Part 2

Yesterday I wrote about deciding to build a quick and dirty voting solution. Or to try to at least! Should be interesting to see how I fare with you all:-) Here are the tables I ended up with: As you might guess Ballot holds the overall description of what is being voted on, BallotDetail […]

Notes from the June 2010 oPASS Meeting

We had adjusted our meeting date to work around previous commitments for both Jack Corbett and I, and that may have been a factor in the low turnout of 13 attendees, along with the hard rain shower around 4 pm. Started just a couple minutes late, ran through the standard PASS chapter deck and talked […]

Building a PASS Voting Solution – Part 1

Last year for the annual Board of Directors election we used Zoomerang as our e-voting solution. It’s not the worst solution – easy to use, low cost, no real testing to do. But in practice it caused some pain. Quite a few emails to voters were lost to spam filters and we didn’t have a […]

SQLAndy

Misc