Tag Archives: sql

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 , | 5 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

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