Tag Archives: sql

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

Advertisements
Posted in programming | Tagged , , , | Leave a comment

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

The stupid developer

Once I had to write a complex SQL query so we can extract denormalized data from the database.

Another developer had to review my code. Hint: he wasn’t the stupid one. Continue reading

Posted in programming, soft skills | Tagged , , , | 1 Comment