AUTOMATIC INVERSION OF CONTROL TOOLS! ARE THERE ANY MAJOR BENEFITS?
AUTOMATIC INVERSION Automatic Inversion/Dependency Injection as a design pattern has been around for a while now…and it’s one I quite like. At a very simple level it makes changing components (dependencies) easier. I have also found that applying the design pattern to our code makes it’s easier to test and improves the overall maintainability. There […]
STATISTICAL PROCESS CONTROL: 7 STEPS TO IMPROVEMENT
Driving Improvement in Process Improvement Progressive manufacturers utilize Statistical Process Control to “listen” to their processes so that potentially harmful changes will be quickly detected and rectified. However, not all SPC programs deliver to their highest capability as there are many elements to get right to achieve maximum utility. Highly effective SPC programs combine technical […]
DON’T PANIC! READ ON TO SEE HOW YOU CAN USE A SQL SERVER TABLE VARIABLE TO SOLVE YOUR QUERY
SQL Server Table Variable There are times when a temporary table can be useful for particular data tasks that need to be performed in SQL Server….however sometimes a table variable is a better option. This short post will detail two sample scenarios where a table variable provides a better solution when working within certain constraints. […]
CONNECT BY LEVEL CONDITION: HOW TO CHART DATA OVER TIME WHEN MISSING VALUES USING ORACLE
Connect By Level Condition As most of us software engineers know occasionally a situation will arise where data needs to be charted over time. However problems can arise where there are intervals for which no data exists. Connect By Level Condition could be the answer to this! The following looks at an Oracle based solution […]
MICROSOFT CODE CONTRACTS
Code Contracts Following on from last month’s blog on Design by Contract, this month we take a look at Microsoft’s implementation of this which is called Code Contracts. First a little background into why you might want to implement Code Contracts in your .NET projects. Let’s take a simple method which we might have written […]