Much like SQL Server embraced native storage of XML data, Postgresql has embraced native storage of JSON. The benefits and detriments are identical. It can be used and/or abused. JSON is much more popular with the Java community than XML data notation. It is not as easy to read as XML, but remains very flexible. More significant, is the fact […]

One of the reasons we tend to build SQL statements in our application code is because it is difficult to sort the results using different fields. You have at least a couple solutions to this scenario, if you wish to use stored procedures. Do not sort the data in the stored procedure; sort the results in the application Modify your […]

As a follow on to yesterday’s editorial, "SQL Injection is Still Alive", I want to provide some quick tips on how to protect against SQL Injection. The first thing you need to do is get rid of code that builds SQL Statements by concatenating commands with user input. The reason was demonstrated yesterday. If your source engine is SQL Server, […]

I heard this last week about an application that was attached by SQL Injection. The application wasn’t very old. I’m quite surprised at this turn of events. How SQL Injection works is well documented all over the web. Ways to exploit SQL databases through injection are simple. Blocking SQL Injection is simple as well. This is a topic I have […]

Continuing with the thoughts on using Chunky web service calls, one reader reminds us that using Chunky increases the potential for concurrency issues. Data remains in the client cache for a much longer period of time. It has a higher chance of becoming stale, and not representing the value currently in your data storage. SQL Server has a technique that […]

I’ve been reading about using chunky calls for REST based applications. This technique has been around for quite a while, and is growing in popularity. Chunky applications often implement MVC in the browser, using libraries based on Java Script. This kind of application allows you to scale, by taking advantage of the client computer browser to performa lot of heavy […]

Continuing on the theme of balancing priorities in IT roles, I want to turn, today, to operations. When I think of operations I think of the goal to keep the lights on. Change occurs slowly. Focus is placed on maintaining smooth operations with minimal disruption to systems and access to those systems. So what is there to balance in operational […]

Today I want to focus on coding in Dot Net as it pertains to comments. Folks responded to yesterday’s editorial with a position that comments are essential for them. I agree, and want to break out different kinds of comments I like to use in Dot Net Code. First there is the ability for you to define the purpose of […]

Expanding on the topic of balance I wanted to consider balance when writing custom software. There are a number of things we balance when writing code. We need our code to be understandable to ourselves and others that follow. We need the code to accurately reflect the system requirements. We need our code to be SOLID as much as is […]

If you’re like me you are constantly trying balance the different aspects of life in order to be healthy and efficient. We try to balance diet, exercise, wife, kids, family, friends, inner self, etc. All of these things take time, and if not balanced impact one another. Like a clown bicycle, having some spokes longer than another, resulting in an […]