I use Access when I don’t have dedicated admin tools for editing data, frequently the case for infrequently changed data in smaller projects. Linked tables work reasonably well, just have to create a DSN first. Except…it doesn’t seem to work (at least obviously) for synonyms. Here’s one I created (viewing as sysadmin): And the view […]Read more "MS Access Annoyance: Doesn’t Link Synonyms"
Here’s the editorial for SSC today and while it’s a humorous story about asking for donuts and getting a free breakfast for everyone, it’s also a cautionary tale for those trying to do good as managers, and even for employees submitting suggestions. Looking back, I still think it was a fair suggestion in response to […]Read more "The Breakfast Plan Goes Awry"
Conference calls are a fact of life for most of us. Remote offices, remote workers, clients – lots of reasons to do a call. Hard to argue with the cost, definitely a money saver. For some things they work well, for situations requiring a lot of collaboration though, they take a lot of extra effort […]Read more "Conference Calls Are Hard"
It’s been a busy month for me for PASS activities. I spent almost the entire week last week on PASS related items and probably 60+ hours for the month: Reviewing the annual budget A call on SQLSaturday to work on plans for 2011 Tons of time on the Spring Event I won’t share much in […]Read more "PASS Update #35"
If you’re a blogger or a twitterer or a SQL speaker or PASS volunteer, you do it because you have found it to be fun, worthwhile, even challenging perhaps. I bet you remember doubting the value before you started and hesitating to take the leap, and maybe you tried it because you had someone inspire […]Read more "Growing the SQL Community – Carefully"
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 […]Read more "Building a PASS Voting Solution – Part 6"
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 […]Read more "PASS Board Call For Nominations Open"
I’ve been experimenting with stories in the editorial, experiences of my own that are amusing and have some kind of interesting lesson embedded. Stories can be interesting, uplifting, even tiresome, not sure at all where the boundary is yet, or if it can even be defined that way. The good part about stories (and life […]Read more "Guest Editorial on SSC – Selling Used Cars/Experience Requires Repetition"
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 […]Read more "SQLSaturday Orlando Signs"
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 […]Read more "Building a PASS Voting Solution – Part 5"