Why Clean Code?

Code is clean if it can be understood easily – by everyone on the team.

With understandability comes readability, changeability, extensibility and maintainability. All the things needed to keep a project going over a long time without accumulating up a large amount of technical debt. Writing clean code from the start in a project is an investment in keeping the cost of change as constant as possible throughout the lifecycle of a software product.

Read more

Reporting in HEAT 2014

SQL Reporting services (SSRS) has been introduced to the latest version of HEAT. We are now given the opportunity to create much more complex and customized reports through SSRS and view these through HEAT2014. Some of the Features:
Read more

new JuniorDeveloper()

I doubt that any of us had a painless initiation into the development world. Obviously we were expecting real-life tech to be planets apart from what we studied, but what we hadn’t braced for was the deep dive into client business rules and 3rd party integrations.

As a new junior joins your company, fresh from graduation or their previous want-away career, they’re about to enter just about the most trying few weeks of their entire life. Forget taking a driver’s test – after 3 days at your first new developer job, you actually wonder what you’re doing on the planet.

So how can we make the transition easier?

Read more

Data brings Moneyball to the workplace –

ITSM 7 Error: Column does not Exist

This error recently occurred at a customer site when they were inserting a new record into External Contact. This can occur when the ITSM meta-data for a table is out of synch with the table structure.  First ensure it is not a caching issue – Force clear cache definitions from Admin and restart IIS. If problem persists and it is reporting the column name then you can add the column manually to the table in SQL.

What to do when a Database Delete happens in MSSQL

I recently had a situation where 3 database deletes happened with no one taking ownership of having done the deletes. Some important things that you should back up are:

  • The Master database.
  • The log folder for that instance of MSSQL. It contains some trace files (extension trc), the SQL event log files and the SQL error logs.
  • All of the windows event logs

Read more

Does the ITIL® Framework Need a Facelift?

The following is an excerpt from a longer article, entitled ‘Does the ITIL® Framework Need a Facelift?’ by Malcolm Fry.

Malcolm believes the framework is an excellent tool, and his comments are not meant to be a criticism but an encouragement to improve.

Relevance

The eternal problem for the ITIL framework has always been to remain relevant mainly because of the speed of change. For example, few of those involved with the ITIL framework would have had a tablet when the framework was last refreshed in 2011. The iPhone® and iPad® devices came to consumers in June 2007 and April 2010, but who could have predicted, rather than guessed, the impact these technologies would have on consumers? Relevancy could be achieved by having a subscription and issuing updates in the form of new and supplementary segments or by using online technology services. This will always be an issue but can be minimised if approached constructively.

 
Read more

Joins in SQL

If you ever struggle with joins in SQL this should help you:

Database Joins

First Post

This is our new blog. Welcome to the site !!!

We custom develop ling of business applications for many businesses throughout South Africa.  We focus on application development and integration and build everything with the latest .NET technology.

We also resell products for Service Management and CRM. Some of our products are MS CRM and HEAT.