Naming convention for SSIS Tasks

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

Formatting SQL Statements (Part 2)

Dieser Artikel in Deutsch… Introduction Developing SQL code follows a completely opposed paradigm compared to developing software code. While one single SQL statement may consist of hundreds of lines, software commands tend to be rather short and compact. You use many commands for achieving a goal in software development. In SQL server it is highly … Read more

Formatting SQL Statements (Part 1)

Dieser Artikel in Deutsch… Overview Capital letters are often used to emphasize single words. This applies, for example, to German as a language. Latin, Greek, … Although there are languages that do distinct between upper and lower case (with respect to nouns), it has nevertheless prevailed in most languages. Even in English you can sometimes … Read more

Functional Design (Aesthetics) of SQL

Dieser Artikel in Deutsch… Overview A good programming style is the basis for readable and comprehensive source code and thus contributes substantially to the maintainability of software in the broadest sense. Well formatted code, definition and adherence to naming conventions are just a few criteria. The design (aesthetics) is subject to personal preferences of developers … Read more