SQL Joins Visual Representation

http://www.codinghorror.com/blog/2007/10/a-visual-explanation-of-sql-joins.html

GIMP 2.8 is just around the corner, can you taste it LOL

OK so it's been over 2 years since GIMP 2.8 was suppose to be released, but with GIMP 2.7.5 [which is a development release] just released a few days ago, it seems imminent that GIMP 2.8 is finally going to be here.

I know it's been ages but I must thank the few developers that have kept GIMP going as it is a phenominal piece of software, especially when looking at the latest development release mentioned above. A few things that I'm still dissapointed about in the GIMP are that there's still no unselection tool, and I know the reason GIMP developers haven't included this tool is because they feel that there shouldn't be a situation where you need to unselect a tool, but I've found certain instances where this tool might come in handy in the GIMP. Anyways GIMP is open source so I might just write some code myself to include a deselection tool when I have some spare time :P.

The other thing is the lack of highligting a menu item once it's been selected, although looking at GIMP again it looks like they do add a tick mark next to menu items which have been selected. But enough about the 1 or 2 things that GIMP doesn't have, why don't you download the current development version below and give it a try, trust me you won't be dissapointed ;).

The best features for me that I've noticed with the new dev release is GIMP's Single-Window Mode as well as how the images are stacked at the top when you're in Single-Window Mode and multiple images have been opened. To select the single window mode in GIMP go to Windows => Single-Window Mode.

Download GIMP 2.7.5 now.

More Useful Links

Scott Hanselmans	=>	Dev Tools List
Editable/Printable Invoice, Version 2	=>	Editable/Printable Invoice, Version 2

Windows Intune [Thanks to my boet Craig Kruger for showing me this little gem from Microsoft]. By the way did I mention that Craig is a phenomenal Hardware and Networking specialist, Google or Microsoft would do well to snatch him up :), although his current company CyberLogic isn't that bad either :P.

Constraint Naming Conventions

Check Key Constraints => CK_ParentTable_Column
E.g.: CK_Employee_EmployeeId
Default Key Constraints => DF_ParentTable_Column
E.g.: DF_Employee_EmployeeId
Foreign Key Constraints => FK_ParentTable_ChildTable_Column
E.g.: FK_Employee_Job_EmployeeId
Primary Key Constraints => PK_ParentTable_Column
E.g.: PK_Employee_EmployeeId

Unique Key Constraints => IX_ParentTable_Column
E.g.: IX_Employee_Email

CREATE TABLE SYNTAX

CREATE TABLE employee (
EmployeeId INT NOT NULL IDENTITY(1, 1),
FirstName VARCHAR(255),
LastName VARCHAR(255),
Email VARCHAR(255) CONSTRAINT IX_Employee_Email UNIQUE
)

ALTER TABLE SYNTAX

ALTER TABLE employee
ADD CONSTRAINT IX_Employee_Email UNIQUE(Email)

For more info on constraints and constraint naming please refer to the following links:
http://msdn.microsoft.com/en-us/library/ms174979.aspx
http://blog.sqlauthority.com/2007/02/05/sql-server-primary-key-constraints-and-unique-key-constraints/
http://msdn.microsoft.com/en-us/library/ms177420.aspx

Hosting Server

Hetzner	»	http://www.hetzner.co.za/
Millennium	»	http://nextmill.net/

NPOI

Code Samples
http://npoi.codeplex.com/releases/view/19351#DownloadId=70100

Google Apps made easy

There is a nice way of using Google Mail and Calendar if you are using Chrome as a browser.

Step 1.
Install Chrome (if you have not yet... you probably cannot... or no one has told you how much better it is)

Step 2.
Download this and install this little application.
http://dl.google.com/tag/s/ap=mydomain.com/googlewebapps/en/googleappsstandalonesetuptagged.exe

You are done!
What you get is a separate window for your Email and Calendar.., which makes life so much easier...

Once you run this.. it looks like this:



And it looks like this:



Credit goes to Gerhard Pretorius for this useful post.