An SSIS package fails, and the execution log is supposed to point to the cause. Instead it presents a tree in which the tasks do not appear in the order they ran, but alphabetically by name. For complex packages that log becomes plainly unreadable. The good news is that a well-considered naming convention makes it … Read more
If you can’t tell at a glance where the WHERE clause of a 200-line SELECT statement starts and ends, you have a structure problem — not a content problem. This article shows how to format SQL statements so that SELECT, FROM, WHERE and JOIN stay immediately recognizable even in long queries. → Part of a series. This is part 2 and covers statement structure (SELECT, WHERE, FROM, JOIN). The basics for … Read more
Anyone who has ever had to debug a badly or completely unformatted SELECT with 30 columns and half a dozen joins knows the feeling: it isn’t the SQL that eats up your day — it’s hunting down what the statement is actually trying to do. SQL formatting isn’t a matter of taste; it’s a maintenance … Read more
A SQL statement that looks neatly indented on one developer’s machine collapses into a staircase on a colleague’s — even though nobody touched the code. The culprit is almost always a difference in editor settings: a different tab width, tabs instead of spaces, a non-monospaced font. Readable SQL code in a team doesn’t start with … Read more
A complex SQL statement is hard enough to read on its own — shifting coding styles in the same file turn every line into an extra re-orientation task. SQL formatting is therefore a team responsibility, not a personal matter of taste. At a glance: Prerequisites: SQL Server or Postgres — the series was written in 2018 with … Read more
Anyone who has ever debugged a 200-line SELECT without indentation knows: SQL formatting is more than a matter of taste. Readable code isn’t just easier to understand — with the right editor tools, it’s also much faster to refactor. In this article: Prerequisite: SSMS serves as the example editor; the principles apply to any editor with … Read more
