Column Stores are a newer data structure found in SQL Server storing high density volumes of data in Binary Large Objects within the SQL Server database. Instead of storing data in a btree structure where each row is aq separate object processed one at a time, a column store data object may process a large number of records with the […]

Dilip shares experience using code generating tools: Here, is what I have experienced by using some of the popular code generating software tools. There are merits and de-merits in using self generating codes software. And still, I have always looked at them as key contributors. The benefits we experienced It gives many logical clues which perhaps we might have missed. […]

In response to my editorial from 6/18 on Self Determined Projects Dilip writes: To the best of my knowledge, many of us have been following this approach for years. I had a developer with a commerce background who wanted to work on an engineering related project of stress and strain analysis in bridge construction. He did wonders. He not only […]

There have been a few responses to the Code Generation editorial from the 17th of june. Most have emphasized the benefits of code generation as being useful. There were a few pitfalls, however. Developers were not maintaining their understanding of the layers of code that were automatically generated Custom modifications to the code were lost when classes were re-generated Sometimes […]

Many companies grant the software developers a benefit of working on projects they determine themselves. The philosophy is that providing some aspect of self determinism generates more satisfaction in the workplace. There is a cost associated with this practice; it doesn’t come for free. The cost is accrued when the time is spent doing non-project work for the companies applications. […]

In 1990 I was told that by the year 2000 there would not be a need for trained software developers anymore. Software development would no longer require complicated code writing and the likes. Instead, software development would simply be the process of plugging together different software modules in the form of objects. There would be a few software developers creating […]

Many have commented on the posting regarding a recent comparison of Java to Dot Net for performance of a specific algorithm. We seem to have a consensus that the majority of the time application performance is not determined by a single section of code, but by the application as a whole. Today I wanted to include some coding techniques that […]

Today I came across a thread on linkedin asking the question, “Is the java engine faster than Dot Net.” Intrigued I read further and found that the answer for that particular code was definitely Java was at least twice as fast. I’m not providing more detail because it wasn’t really the comparison that I came away with as being important. […]

Many of the current languages for software development are object based opposed to procedural based. The major difference between the two types of languages is that object based languages contain the procedures implementing the capability of those objects. Procedural languages contain procedures that externally manipulate types. Types are simply complex data constructs, with no internal characteristics other than properties. This […]

A new IDE for writing SQL is being developed by Jet Brains that may take over a lot of the existing tools. It is currently in a restricted Early Access Program of which I have not yet been accepted. I’m simply reporting based on the features they publish on their website. The new tool is called 0xDBE. 0xDBE is built […]