• Our Office
  • 12 Alpine Close Lakefield Benoni 1501

Back to Basics: SQL Indexes

SQL Server Index Basics Given the fundamental importance of indexes in databases, it always comes as a surprise how often the proper design of indexes is neglected. It often turns out that the programmer understands detail, but not the broad picture of what indexes do. Bob Sheldon comes to the [...]

Read More

Back to Basics: SQL Joins

I recently had to explain to some people the difference between the different kinds of SQL joins. Now I have been using SQL for well over 15 years and feel myself quite the expert, however this stumped me like a number 10 batsmen facing an Alan Donald yorker. The problem [...]

Read More

What is a Solution Architect?

A solution architect is responsible for the design of one or more applications or services within an organization, and is typically part of a solution development team. He or she must have a balanced mix of technical and business skills, and will often work with an enterprise architect for strategic direction. The [...]

Read More
SOLID

SOLID design principles

You might have heard of SOLID design principles or NOT but with most designs that stand the test of time some aspects of SOLID has always been part of good design. With modern designs and architecture roles these have just received a fancy name. However some concept of SOLID is [...]

Read More