Diff two versions of an SSIS package — even a trivial rename produces eight “changed regions” in the XML, and the diff doesn’t even locate the actual edit correctly. The same modification in a stored procedure shows three lines of diff, reviewable in 30 seconds. Source code management is a maintainability decision — not a … Read more
Overview Documentation should be an inherent part of any database development project. Virtually everybody would agree with this. However, documentation is usually the first goal to be a victim of project pressure. “If you want to know what the code does, have a look at the code.” This is a very common view on missing … Read more
Overview The definition of programming guidelines and naming conventions only makes sense if the advantage outweighs the effort. One important prerequisite for this is the identification of the benefits. Readability and maintainability of code are generally in the focus of developers when talking about naming conventions. In case of SQL Server Integration Services (SSIS), however, … Read more
Dieser Artikel in Deutsch… Overview Most editors of well-known development environments including SQL Server Management Studio (SSMS) use monospaced fonts. With that, each character occupies the same amount of horizontal space. Texts can be easily indented and aligned when using monospaced fonts. An efficient feature for aligning and indenting text elements is the Tab-key. By … Read more
