Normalisation

• by terrychoo

• Terry's Business Intelligence

The purpose of normalisation is to remove redundancy and prevent conflict. 1st Normal Form (1NF) – Every field can have only...

2013-08-07

537 reads

Client Pressures and Code Quality

• by terrychoo

• Terry's Business Intelligence

In my experience, code quality always trumps urgency because when code has been released that has questionable quality, it is...

2013-06-09

424 reads

SQL Query Result Order

• by terrychoo

• Terry's Business Intelligence

Every time an SQL query is run without the ORDER BY clause, the sort order of the results returned is...

2013-06-05

630 reads

SQL Logical Query Processing Order

• by terrychoo

• Terry's Business Intelligence

This probably applies more to beginners or people who have been using SQL for a while but have been wondering...

2013-06-03

479 reads

SQL and Relational Theory

• by terrychoo

• Terry's Business Intelligence

Do you know the foundation of SQL? According to the book Querying Microsoft SQL Server 2012 Training Kit on the...

2013-05-31

985 reads

The right terminology for the right audience

• by terrychoo

• Terry's Business Intelligence

For those who has the privilege of being in the technology consulting industry for some time and started out in...

2013-01-17

385 reads

Address Clean-up for Mail Merge using SSIS

• by terrychoo

• Terry's Business Intelligence

Remember the good ol’ days of going through a list of addresses and manually cleaning up hundreds if not thousands...

2012-10-19

731 reads