Archive for February, 2008
Today, I had the opportunity to attend the Financing Your Vision seminar at Calgary Technologies. This is the one-day seminar that covers all of the financing options available to entrepreneurs – covered by speakers with direct and relevant experience in their respective fields. It seems to be aimed primarily at high tech entrepreneurs, but the [ READ MORE ]
When alltop.com was brought to my attention the other day, I set it up as my second tab* on Internet Explorer. As a result, I quickly discovered the single major flaw with the Alltop strategy — there has to be a reason for it to win the steel-cage-death-match for my browser tabs — and hence [ READ MORE ]
I was working on the new application database recently, and it came time to create some triggers to keep date/time and a few other fields up to date. Therefore, it seems like a good time to talk about trigger naming standards. They’re simple, because I’m convinced trigger use should be limited (see Trigger-holic, below). At [ READ MORE ]
Column defaults are a handy way of ensuring a given column is populated with a specific value unless another value is supplied as part of the insert or update logic. A popular choice, for example, is to use GETDATE() or GETUTCDATE() to populate a mandatory DATETIME column. This is fine, unless you need more sophisticated [ READ MORE ]