Overview SQL Server Integration Services (SSIS) is a very powerful graphical tool set belonging to the Microsoft BI Stack along with SQL Server. It supports a broad variety of data migration, integration and transformation tasks. With that, you will find 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 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 Read More …
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 Read More …
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 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 Read More …
Dieser Artikel in Deutsch… Overview Recently, I had to revise a Stored Procedure with nearly 2.000 lines of code. The procedure was edited by three developers, one after another. It contained sub statements for about 30 tables with varying degrees Read More …
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 Read More …