Emil Kotrč

  • strict warning: Non-static method view::load() should not be called statically in /home/vsjvdnj4xz9c/public_html/sites/all/modules/views/views.module on line 906.
  • strict warning: Declaration of views_handler_argument::init() should be compatible with views_handler::init(&$view, $options) in /home/vsjvdnj4xz9c/public_html/sites/all/modules/views/handlers/views_handler_argument.inc on line 0.
  • strict warning: Declaration of views_handler_filter::options_validate() should be compatible with views_handler::options_validate($form, &$form_state) in /home/vsjvdnj4xz9c/public_html/sites/all/modules/views/handlers/views_handler_filter.inc on line 0.
  • strict warning: Declaration of views_handler_filter::options_submit() should be compatible with views_handler::options_submit($form, &$form_state) in /home/vsjvdnj4xz9c/public_html/sites/all/modules/views/handlers/views_handler_filter.inc on line 0.
  • strict warning: Declaration of views_plugin_row::options_validate() should be compatible with views_plugin::options_validate(&$form, &$form_state) in /home/vsjvdnj4xz9c/public_html/sites/all/modules/views/plugins/views_plugin_row.inc on line 0.
  • strict warning: Declaration of views_plugin_row::options_submit() should be compatible with views_plugin::options_submit(&$form, &$form_state) in /home/vsjvdnj4xz9c/public_html/sites/all/modules/views/plugins/views_plugin_row.inc on line 0.
  • warning: Creating default object from empty value in /home/vsjvdnj4xz9c/public_html/sites/all/modules/date/date/date.module on line 662.
  • strict warning: Only variables should be passed by reference in /home/vsjvdnj4xz9c/public_html/sites/all/modules/date/date_api.module on line 866.
  • strict warning: Only variables should be passed by reference in /home/vsjvdnj4xz9c/public_html/sites/all/modules/date/date_api.module on line 866.
  • strict warning: Only variables should be passed by reference in /home/vsjvdnj4xz9c/public_html/sites/all/modules/date/date_api.module on line 866.
  • strict warning: Only variables should be passed by reference in /home/vsjvdnj4xz9c/public_html/sites/all/modules/date/date_api.module on line 866.
  • strict warning: Only variables should be passed by reference in /home/vsjvdnj4xz9c/public_html/sites/all/modules/date/date_api.module on line 866.
  • strict warning: Only variables should be passed by reference in /home/vsjvdnj4xz9c/public_html/sites/all/modules/date/date_api.module on line 866.
  • strict warning: Only variables should be passed by reference in /home/vsjvdnj4xz9c/public_html/sites/all/modules/date/date_api.module on line 866.
  • strict warning: Only variables should be passed by reference in /home/vsjvdnj4xz9c/public_html/sites/all/modules/date/date_api.module on line 866.
  • strict warning: Only variables should be passed by reference in /home/vsjvdnj4xz9c/public_html/sites/all/modules/date/date_api.module on line 866.
  • strict warning: Only variables should be passed by reference in /home/vsjvdnj4xz9c/public_html/sites/all/modules/date/date_api.module on line 866.
  • strict warning: Only variables should be passed by reference in /home/vsjvdnj4xz9c/public_html/sites/all/modules/date/date_api.module on line 866.
  • strict warning: Only variables should be passed by reference in /home/vsjvdnj4xz9c/public_html/sites/all/modules/date/date_api.module on line 866.
  • strict warning: Only variables should be passed by reference in /home/vsjvdnj4xz9c/public_html/sites/all/modules/date/date_api.module on line 866.
  • strict warning: Only variables should be passed by reference in /home/vsjvdnj4xz9c/public_html/sites/all/modules/date/date_api.module on line 866.
  • strict warning: Only variables should be passed by reference in /home/vsjvdnj4xz9c/public_html/sites/all/modules/date/date_api.module on line 866.
  • strict warning: Only variables should be passed by reference in /home/vsjvdnj4xz9c/public_html/sites/all/modules/date/date_api.module on line 866.
  • strict warning: Only variables should be passed by reference in /home/vsjvdnj4xz9c/public_html/sites/all/modules/date/date_api.module on line 866.
  • strict warning: Only variables should be passed by reference in /home/vsjvdnj4xz9c/public_html/sites/all/modules/date/date_api.module on line 866.
  • strict warning: Only variables should be passed by reference in /home/vsjvdnj4xz9c/public_html/sites/all/modules/date/date_api.module on line 866.
  • strict warning: Only variables should be passed by reference in /home/vsjvdnj4xz9c/public_html/sites/all/modules/date/date_api.module on line 866.
  • strict warning: Only variables should be passed by reference in /home/vsjvdnj4xz9c/public_html/sites/all/modules/date/date_api.module on line 866.
  • strict warning: Only variables should be passed by reference in /home/vsjvdnj4xz9c/public_html/sites/all/modules/date/date_api.module on line 866.
  • strict warning: Only variables should be passed by reference in /home/vsjvdnj4xz9c/public_html/sites/all/modules/date/date_api.module on line 866.
  • strict warning: Only variables should be passed by reference in /home/vsjvdnj4xz9c/public_html/sites/all/modules/date/date_api.module on line 866.
  • strict warning: Only variables should be passed by reference in /home/vsjvdnj4xz9c/public_html/sites/all/modules/date/date_api.module on line 866.
  • strict warning: Only variables should be passed by reference in /home/vsjvdnj4xz9c/public_html/sites/all/modules/date/date_api.module on line 866.
  • strict warning: Only variables should be passed by reference in /home/vsjvdnj4xz9c/public_html/sites/all/modules/date/date_api.module on line 866.
  • strict warning: Only variables should be passed by reference in /home/vsjvdnj4xz9c/public_html/sites/all/modules/date/date_api.module on line 866.
  • strict warning: Non-static method view::load() should not be called statically in /home/vsjvdnj4xz9c/public_html/sites/all/modules/views/views.module on line 906.
  • strict warning: Declaration of date_api_filter_handler::value_validate() should be compatible with views_handler_filter::value_validate($form, &$form_state) in /home/vsjvdnj4xz9c/public_html/sites/all/modules/date/includes/date_api_filter_handler.inc on line 0.
  • strict warning: Only variables should be passed by reference in /home/vsjvdnj4xz9c/public_html/sites/all/modules/date/date_api.module on line 866.
  • strict warning: Declaration of views_handler_filter_boolean_operator::value_validate() should be compatible with views_handler_filter::value_validate($form, &$form_state) in /home/vsjvdnj4xz9c/public_html/sites/all/modules/views/handlers/views_handler_filter_boolean_operator.inc on line 0.
  • strict warning: Declaration of views_handler_field_comment_username::init() should be compatible with views_handler_field::init(&$view, $options) in /home/vsjvdnj4xz9c/public_html/sites/all/modules/views/modules/comment/views_handler_field_comment_username.inc on line 0.
  • strict warning: Declaration of views_handler_field_comment::init() should be compatible with views_handler_field::init(&$view, $options) in /home/vsjvdnj4xz9c/public_html/sites/all/modules/views/modules/comment/views_handler_field_comment.inc on line 0.
  • strict warning: Declaration of image_attach_views_handler_field_attached_images::pre_render() should be compatible with views_handler_field::pre_render($values) in /home/vsjvdnj4xz9c/public_html/sites/all/modules/image/contrib/image_attach/image_attach_views_handler_field_attached_images.inc on line 0.
  • strict warning: Declaration of views_handler_field_node_new_comments::pre_render() should be compatible with views_handler_field::pre_render($values) in /home/vsjvdnj4xz9c/public_html/sites/all/modules/views/modules/comment/views_handler_field_node_new_comments.inc on line 0.
  • strict warning: Declaration of views_handler_field_upload_description::init() should be compatible with views_handler_field::init(&$view, $options) in /home/vsjvdnj4xz9c/public_html/sites/all/modules/views/modules/upload/views_handler_field_upload_description.inc on line 0.
  • strict warning: Declaration of views_handler_field_user::init() should be compatible with views_handler_field::init(&$view, $options) in /home/vsjvdnj4xz9c/public_html/sites/all/modules/views/modules/user/views_handler_field_user.inc on line 0.
  • strict warning: Only variables should be passed by reference in /home/vsjvdnj4xz9c/public_html/sites/all/modules/date/date_api.module on line 866.
  • strict warning: Only variables should be passed by reference in /home/vsjvdnj4xz9c/public_html/sites/all/modules/date/date_api.module on line 866.
  • strict warning: Only variables should be passed by reference in /home/vsjvdnj4xz9c/public_html/sites/all/modules/date/date_api.module on line 866.
  • strict warning: Only variables should be passed by reference in /home/vsjvdnj4xz9c/public_html/sites/all/modules/date/date_api.module on line 866.
  • strict warning: Only variables should be passed by reference in /home/vsjvdnj4xz9c/public_html/sites/all/modules/date/date_api.module on line 866.
  • strict warning: Only variables should be passed by reference in /home/vsjvdnj4xz9c/public_html/sites/all/modules/date/date_api.module on line 866.
  • strict warning: Only variables should be passed by reference in /home/vsjvdnj4xz9c/public_html/sites/all/modules/date/date_api.module on line 866.
  • strict warning: Only variables should be passed by reference in /home/vsjvdnj4xz9c/public_html/sites/all/modules/date/date_api.module on line 866.
  • strict warning: Non-static method view::load() should not be called statically in /home/vsjvdnj4xz9c/public_html/sites/all/modules/views/views.module on line 906.
  • strict warning: Only variables should be passed by reference in /home/vsjvdnj4xz9c/public_html/sites/all/modules/date/date_api.module on line 866.
  • strict warning: Non-static method view::load() should not be called statically in /home/vsjvdnj4xz9c/public_html/sites/all/modules/views/views.module on line 906.
  • strict warning: Non-static method view::load() should not be called statically in /home/vsjvdnj4xz9c/public_html/sites/all/modules/views/views.module on line 906.
  • strict warning: Declaration of views_plugin_style_default::options() should be compatible with views_object::options() in /home/vsjvdnj4xz9c/public_html/sites/all/modules/views/plugins/views_plugin_style_default.inc on line 0.
Speaker Details

Bio
Emil Kotrč, an experienced principal software architect with a demonstrated history of working in the computer software industry. He is skilled in IBM Db2, Agile Methodologies, Databases, and IBM mainframe.
Emil is an active member of IDUG, serving on the IDUG Content Committee and speaking at international conferences (including the upcoming NA 2021 conference).
Past presentation
27 svibanj 2021
10:30 - 11:30
European SQLAdria Seminar – Virtual Event 2021 Experiences with Db2 12 Continuous Delivery - an Update
Db2 12 introduced the mechanism of continuous delivery. In this presentation we will explain the concepts of continuous delivery and will show what does it bring to the application developers and database administrators. We will also discuss experience with the continuous delivery model, point out a few items that need extra attention, and will show what is included in the existing function levels.
This updated presentations will show what is new in this area and will briefly speak about the challenges for a typical vendor.
Objectives
1. Principles of continuous delivery
2. Explanation of code, catalog, and function levels
3. Benefits of continuous delivery for application developers and database administrators
4. Experience with continuous delivery

28 svibanj 2019
15:30 - 16:15
European SQLAdria Seminar – Šibenik 2019 Machine Learning in Examples
Machine Learning (ML) is a rapidly growing field of the computer science that has far reaching applications even outside the academics and specialized industries. Thanks to the Big Data (r)evolution, Machine Learning is becoming popular even in smaller businesses. Moreover, there are many tools and projects that allow running ML algorithms even by enthusiasts without a mathematical or statistical background.
In this presentation we will show some of the most common ML algorithms together with their prevalent use cases and we will demonstrate them on very simple examples. We will also discuss a possible integration with DB2.
Objectives:
1. A very brief introduction into ML and basic ideas.
2. A very brief introduction into the available machine learning tools.
3. Discuss the typical use cases on simple examples.

27 svibanj 2019
16:00 - 17:00
European SQLAdria Seminar – Šibenik 2019 Unsung Heroes of the Db2 for z/OS Application Development, Db2 12 Edition
Db2 is constantly evolving over the years, bringing new features with every new release. It might be hard for the developers and administrators to catch up with all the new useful technologies and possibilities. Often, even the features that are not brand new and that have the potential to help reducing the costs by improving the performance or making the application simpler, are not yet fully exploited.
This presentation will list and remind some features that might help application developers to use more power of the Db2 engine. The discussed topics will cover advanced SQL like the MERGE statement, SELECT from data change references, multi-row operations, lock avoidance techniques, built-in functions like GENERATEUNIQUE(), timestamp functions, and some other small tips. We will also cover highlighted features of Db2 12.
Objectives:
1. Review some of the new features brought through the Db2 releases.
2. Advanced SQL statements like MERGE, SELECT FROM table change reference.
3. Multi-row operations, cursors.
4. Lock avoidance techniques.
5. Several smaller tips using built in functions.

26 svibanj 2019
18:00 - 18:30
European SQLAdria Seminar – Šibenik 2019 Continuous Delivery

12 lipanj 2018
15:45 - 16:30
European SQLAdria Seminar – Šibenik 2018 DSNUTILU for fun and profit
Db2 for z/OS comes with a set of Stored Procedures that can help application developers to perform various administrative tasks. The main benefits of these procedures are their ease of use via the SQL CALL statement and the simplification of processes. One example of the supplied stored procedures is DSNUTILU, which allows Db2 utility operations from the application programs.
In this presentation we will show how to use DSNUTILU, we will discuss possible real life scenarios, and the benefits and drawbacks of its usage in local and remote application programs.
Objectives:
1. An overview of Db2 supplied stored procedures.
2. Description of DSNUTILU and examples of possible use cases.
3. Discussion of DSNUTILU benefits and drawbacks.

11 lipanj 2018
15:00 - 16:00
European SQLAdria Seminar – Šibenik 2018 A Handful of Application Development Goodies in Db2 12
Db2 12 for z/OS is a version that both, application developers and database administrators, will love. It does not only come with a set of useful new features, but it also brings a new continuous delivery model, which will be beneficial for both - developers will enjoy new features delivered faster and administrators will like the proven stability.
In this presentation we will focus on the main benefits of Db2 12 from the application developer perspective. In the first part, we will review some of the new SQL features in Db2 12 and we will also discuss their main advantages and possible use cases. The second part of the presentation will be dedicated to other topics related to the application development, especially the continuous delivery model and the performance improvements.
Objectives:
1. A brief overview of Db2 12, introduction of continuous delivery from the application developer perspective.
2. Overview of new features related to application development - enhanced MERGE, enhanced Triggers, SQL pagination, improvements in the Temporal tables support, …
3. Discussion of other features beneficial for the application development - dynamic plan stability, performance improvements, continuous delivery, …

13 lipanj 2016
16:30 - 17:15
European SQLAdria Seminar – Šibenik 2016 Unsung Heroes of the DB2 for z/OS Application Development
DB2 is constantly evolving over the years, bringing new features with every new release. It might be hard for the developers and administrators to catch up with all the new useful technologies and possibilities. Often, even the features that are not brand new are not yet fully exploited despite they have a potential to help reducing the costs by improving the performance or making the application simpler. 
This presentation will list and remind some features that might help application developers to use more power of the DB2 engine. The discussed topics will cover advanced SQL like the MERGE statement, SELECT from data change references, multi-row operations, lock avoidance techniques, built-in functions like GENERATE_UNIQUE(), timestamp functions, DB2 supplied stored procedures, and some other smaller tips. 
Objectives: 
1. Review some of the new features brought through the DB2 releases. 
2. Advanced SQL statements like MERGE, SELECT FROM table change reference. 
3. Multi-row operations, cursors. 
4. Lock avoidance techniques. 
5. Built-in functions and supplied Stored procedures. 
6. Several smaller tips. 

 

sqladria

SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group.

Follow us

facebook
linkid
twitter

 

Events in 2021

VIRTUAL EVENT - 27th - 28th May 2021