Building a PASS Voting Solution – Part 6

Today we’ll try to finish up by looking at a couple of the semi-interesting parts of the code in this one page application. We’ll start with the page load event. On the first run of the page (not postback) I’m grabbing the two keys I need if they exist and calling the MyBallot.Validate method (show […]

PASS Board Call For Nominations Open

Nominations opened today and will run through July 21st. Whether you’re planning to be a candidate or not, I hope you’ll visit the election page and review the documents posted. Those documents reflect a lot of time and effort from Hannes and a lot of others to try to improve the election process this year […]

SQLSaturday Orlando Signs

Life in the event leader fast lane, finally got the signs for our upcoming #49 here in Orlando. In past years we’ve gone with the low budget version, but this year since we’ve got ace fund raiser Jack Corbett working on sponsors, we’re investing a little. Ordered 25 of the 18×24 signs on plastic, printed […]

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 […]

SQLAndy

SQL Server