Developer Guidelines

1. Introduction
2. Coding Guidelines
2.1 Bracing
2.2 Single line statements
2.3 Commenting
2.3.1 Copyright notice
2.3.2 Documentation Comments
2.3.3 Web Service Comments
2.3.4 Custom Server Control and ASP.NET AJAX Control Comments
2.3.5 Comment Style
2.4 Spacing
2.5 Naming
2.6 Namespaces
2.6.1 Assembly Namespaces
2.6.2 ASP.NET Website Namespaces
2.6.3 ASP.NET Web Service Namespaces
2.7 File Organisation
2.7.1 File Organisation
2.8 ASP.NET ID Prefixes
2.9 Data Access
2.10 Data Access
2.10.1 Cache Your Elements
2.10.2 Prefer [] over item()
2.10.3 Avoid the use of ‘eval’
2.10.4 String manipulation
2.10.5 JavaScript compression
3. SQL Guidelines
3.1 Parameters and variables
3.2 Control statements
3.3 Naming
3.4 Paging
3.5 Exceptions and business logic

GIMP 2.8.18 and GIMP 2.9.4 released

As of the 13th July 2016 you can now download GIMP 2.8.18 and GIMP 2.9.4.  In order to download this software please go to http://www.gimp.org/downloads/ for the stable 2.8.18 release and http://download.gimp.org/mirror/pub/gimp/v2.9/ for the development 2.9.4 release.

Also for unstable nightly builds please go to http://nightly.darkrefraction.com/gimp/.  Remember that this is free software and the developers work really hard to write professional software like the GIMP so please do consider donating towards this awesome free PhotoShop alternative.

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/