Passed the CCNA exam today with a score of 912. My revision notes and tips are below.

My free CCNA study materials

Currently working on trying to automate the bulk input of web log files into a MS SQL database with DTS Designer and Active-X script.

Managed to concatenate fields and perform VB commands on the data prior to input. However running through a directory of files to input is somewhat more difficult.

Ideal DTS import solution

The following URL is a template CV that Russians use to get jobs in the west (Apparently). All you need to is add your name/dob/address/phone no/email and invent a couple of company names and addresses and bobs your uncle... :)

Template web CV

Constraints are important within a database structure as they insure database integrity.

This useful SQL command shows how to add constraints to existing SQL tables.

In this command a constraint between 2 tables (tblCountries and tblCompanies) is being created called FK_tblCompanies_tblCountries.

alter table dbo.tblCompanies add constraint FK_tblCompanies_tblCountries foreign key (ISOCountryCode) references dbo.tblCountries(ISOCountryCode)

According to T-mobile the new form of mobile phone communication will be a combination of pictures, sounds and slang phrases. These will produce a new abbreviated language which will be unique between groups of friends.

This news comes as the UK networks finally become MMS cross compatible. Enabling users of different networks to send picture messages to one another is seen as key to the take up of MMS.