Introduction to dynamic SQL
Introduction to dynamic SQL
The idea of dynamic SQL The idea of using dynamic SQL is to execute SQL, which will potentially generate and execute another SQL statement. While querying data you might want to dynamically set columns you would like to query. On the other hand you might want to parametrize table on which you want to operate. The [...] ...
Read More
Introduction to dynamic SQL
5 best ETL practices
5 best ETL practices
  It is not possible to provide a list of instructions to build ideal and perfect ETL. Not only because of complexity of a problem, but also because of  diversity. The scope of ETL can vary depending on project requirements. Every part of building the solution: creating architecture, defining sources, mappings, building validation, applying business rules is [...] ...
Read More
5 best ETL practices
Upsert operation: ETL vs pure SQL
Upsert operation: ETL vs pure SQL
In this post I would like to compare efficiency of upsert operation in ETL tools and SQL. This is one of the most commonly used operations when building ETLs and integrating systems. Developers should always ask themselves whether not to use custom written MERGE instead of creating jobs in selected ELT tool. As an ETL example [...] ...
Read More
Upsert operation: ETL vs pure SQL

 

 

NULL in SQL

  NULL in SQL is very interesting “creature”. First of all, it is important to understand that NULL is not a value, so an expression ‘NULL value’ is incorrect. NULL [...]

page 1 of 2
Contact Me

You can contact me with this form. :)

Not readable? Change text.