SQL Syntax

SQL Tutorial #1
SQL Tutorial #2
SQL Syntax Charts
SQL as understood by SqLite
PromptSql Intellisense for SQL [via Richard]
Another reference

Why Blog?

Here are some articles on what blogs are good for:
Why Businesses should blog
Why Blog?

Publishing is one aspect of blogging. The other more common is simply subscribing to and reading blogs using a special program called a News Aggregator (AKA News readers, RSS readers)

Before anyone starts blogging themselves, they usually become a reader
of blogs.  Only after experiencing the technology do you usually "get
it" and start thinking about keeping their own blog.

It’s easy to find lists and reviews of News Aggregators but here is a quick short list of the ones I would recommend.

Weblogs as websites

Here is a weblog that I created for my TigerCub Den. I’m hosting it at home.

It uses a program that supports weblogs but adds more content-management features. I can create separate pages to link to from the Links along the left side.

The same program (Manila) was used for this impressive High School Website.

Pocket PC Development

Mobile Device programming at CodeProject
Finding files in WinCE
JPG library for PocketPC
Forums:
msmobiles

SqlLite

SqlLite is looking very good.

Don Park posts about it.  And announces:

Upcoming PHP 5 will include and use SQLLite as its default database engine

Very positive testimonial
This PHP site loves it :

…SQLite is a godsend.  It provides a very intelligent file management and indexing system, coupled with a data abstraction interface – SQL.  I imagine SQLite to be used inplace of custom flatfile systems, and custom flatfile management.  Its a small, low-level library that manages optimizes and manages file access and manipulation.

Windows CE 5.0 Supports LockFileEx(). However:

There aren’t any Pocket PC devices shipping on Windows CE 5.0, so, at this point developers must develop against Windows Mobile 2003 and Windows Mobile 2003 Second Edition – both of which are based on Windows CE 4.2. Or was your question more of a "what’s new in Windows CE 5.0" ?

C++ Wrapper for SqlLite at CodeProject
SqlLite++
SqlLite for Windows CE

SqLite 3.0 released

Database alternatives

Database vs Flat File discussion
SleepyCat opensource DB
MetaKit, Free Embedded DB
Sqlite – public domain DB writtein in C.  gives you all the advantages of a flat-file while having all the features of an RDBMS

MSN Desktop Search

I recently replaced Google Desktop search with MSN Desktop Search on my computer.
I like the ability to create shortcuts to launch various files, programs and sites.

Help with Desktop Search
Help with Deskbar Shortcuts

Your deskbar shortcuts are stored in the MsnDeskbarShortcuts.ini file. This file is located in the C:\Documents and Settings\username\application data\MSN Search Toolbar folder.

Here is a collection of shortcuts for the MSN Deskbar
And some more collecections
Inside Secrets of MSN Desktop Search

Here is how to reduce the space taken up by the MSN  Deskbar toolbar.
A  Summary:

Find this folder in your registry:
HKEY_CURRENT_USER\Software\Microsoft\MSN Apps\DB

Next,
add a DWORD value with the name of "Buttons" and change the value of
"Buttons" to "1". On your toolbar, uncheck the MSN Deskbar to clear it
from your toolbar then re-check it to add it again without the button.

King Arthur day

David reminded me that we have a three day weekend coming up.  After all, Feb 17 is "King Arther day" he says.

Using the ATL OLE DB Consumer Templates

Using OLE DB on the Pocket PC can be complex. There is a framework available that encapsulates this complexity. It is the ATL OLE DB Consumer Templates.

This articles explains how the Templates can be adapted and used on Pocket PC platforms

Things You’d Like To Say Out Load At Work

THINGS YOU’D LIKE TO SAY OUT LOUD AT WORK

1. I can see your point, but I still think you’re full of shit.
2. I don’t know what your problem is, but I’ll bet it’s hard to pronounce.
3. How about never? Is never good for you?
4. I see you’ve set aside this special time to humiliate yourself in public.
5. I’m really easy to get along with once you people learn to see it my way.
6. I’ll try being nicer if you’ll try being smarter.
7. I’m out of my mind, but feel free to leave a message.
8. I don’t work here I’m a consultant.
9. It sounds like English, but I can’t understand a damn word you’re saying.
10. Ahhh…I see the screw-up fairy has visited us again…
11. I like you. You remind me of myself when I was young and stupid.
12. You are validating my inherent mistrust of strangers.
13. I have plenty of talent and vision; I just don’t give a damn.
14. I’m already visualizing the duct tape over your mouth.
15. I will always cherish the initial misconceptions I had about you.
16. Thank you. We’re all refreshed and challenged by your unique point of view.
17. The fact that no one understands you doesn’t mean you’re an artist.
18. Any connection between your reality and mine is purely coincidental.
19. What am I? Flypaper for freaks!?
20. I’m not being rude, you’re just insignificant.
21. It’s a thankless job, but I’ve got a lot of Karma to burn off.
22. And your crybaby whiny-assed opinion would be…?
23. Do I look like a people person?
24. This isn’t an office. It’s Hell with fluorescent lighting.
25. I started out with nothing & still have most of it left.
26. Sarcasm is just one more service we offer.
27. If I throw a stick, will you leave?
28. Errors have been made. Others will be blamed.
29. Whatever kind of look you were going for, you missed.
30. Wait! Wait! I’m trying to imagine you with a personality.
31. A cubicle is just a padded cell without a door.
32 Can I trade this job for what’s behind door #1?
33. Too many freaks, not enough circuses.
34. Nice perfume. Must you marinate in it?
35. Chaos, panic, & disorder-my work here is done.
36. How do I set a laser printer to stun?
37. I thought I wanted a career; turns out I just wanted a salary.
38. Who lit the fuse on your tampon?
39. Oh I get it… like humor… but different.