Tag Archives: programming

How to execute SQL?

When we run SQL in production database, we should do it carefully. When we do any changes on production systems, we should do it carefully.

But how? It’s not about typing slowly. Continue reading

Advertisements
Posted in programming | Tagged , , , | 1 Comment

How to deal with length-encoded records?

When we deal with length-encoded records, we write a heap of substring calls. Is there a better way? Continue reading

Posted in java | Tagged , , | Leave a comment

Stored Procedures for every DB access

Some applications use a stored procedure for every database access. Strange, isn’t it?

Nevertheless, sometimes it’s the right thing to do. Continue reading

Posted in programming | Tagged , | Leave a comment

Defensively? Optmistically?

Do we really want a self-driving car to show us an error console when it cannot identify an object on the Motorway? Do you want to send out a financial report when most of its records are incorrect? Continue reading

Posted in programming | Tagged , , , | 2 Comments

How to debug with triggers?

In java we got AspectJ to intercept our methods. In SQL we got triggers. A great tool for debugging. Continue reading

Posted in programming | Tagged , , , | 1 Comment

What do you want to depend on?

I must confess. Sometimes I can see fixes that make a chill go down on my spine. And it’s the wrong kind of chill. It’s the chill that tells me that something is wrong. Continue reading

Posted in programming | Tagged , , | Leave a comment

How to debug in production

Sometimes we cannot reproduce an issue. So we must log. Getting production log is an art. Continue reading

Posted in Uncategorized, programming | Tagged , , | 2 Comments

Clean Code in Transact-SQL

I’ve been working with legacy code in Transact-SQL. This is a great opportunity because I still got a lot to learn about SQL, especially about the procedural extensions. All this legacy code lets me experiment with constructs I haven’t even … Continue reading

Posted in programming | Tagged , , , | 3 Comments

What can we learn from arrogant bosses

I believe, everybody encountered an arrogant boss through her career. An arrogant boss is somebody who… Well, someone who looks like an arrogant boss to me, he might be fine for you. Nobody is perfect, not even the managers. There … Continue reading

Posted in programming, soft skills | Tagged , , , | Leave a comment

Please, don’t give me a chance

You need a developer So you’re a manager at Xyz Inc and you want to hire a developer. Along the process you’re interviewing me. During the interview¬†you find out that I know only a little about the core technology you’re … Continue reading

Posted in programming, soft skills | Tagged , | 2 Comments