SQL Random Rows
Found a super slick way to select random rows from MS SQL 2000. I’m just going to quote is here for posterity.
The old method was to grab the primary keys of all the records, then putting them into an array, count the array and pick a random number using the system random function. This [...]
F-A-S-T database engine for .NET & C#?
Anyone have any experience with database engines for .NET (preferably free)? I’m building an application which will require the following capabilities:
Relational
ability to store hundreds of thousands(nay millions) of records per table.
VERY fast. Users search the DB, and return grouped/sorted results. Normal people don’t like to wait.this website has alot listed, but only [...]
Realtime Black Lists
So I was wondering — what Realtime Black Lists does everyone use to combat spam? I’m currently using: relays.ordb.org and bl.spamcop.net but I’m sure there are others out there that I might benefit from. Between the blacklists and SpamAssassin, a good deal of spam dies before it gets to my inbox, but I [...]
More data!
So over the years I have built RSS feeds to give me status updates of various things — mainly computers that I manage, drive space free, and statistics for websites.
So I was checking the total number of minutes used on my mobile phone for the month and thought it would be wonderful if they [...]
Outsourcing to India
Wired has an interesting article about the outsourcing to India: The New Face of the Silicon Age. Interestingly, since starting my own consulting company, I’ve been competing with Indian companies for business, and have lost many bids to them. But for all the work, I applaud them. I think it’s great that [...]