Author Archives: tamasrev

About tamasrev

A software developer, specialized in Java, addressing himself as generalist. A proud daddy.

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

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 Uncategorized, programming | 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