Category 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

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

Generating SQL with SQL

How do you write SQL commands? Sometimes I use SQL queries for that. Continue reading

Posted in programming | Tagged , | 4 Comments

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 programming, Uncategorized | Tagged , , | 2 Comments

Explaining Recursive SQL queries

Recursive SQL queries are not that different from recursive functions. Continue reading

Posted in programming | Tagged , , | Leave a comment

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