SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, Windows Phone 8 app development, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software Kodyaz Development Resources
Development resources, articles, tutorials, code samples and tools and downloads for ASP.Net, SQL Server, R Script, Windows, Windows Phone, AWS, SAP HANA and ABAP, like SAP UI5, Screen Personas, etc.

Software Development

  • How was the Oracle Developer Live 2020 for me

    Today I had the chance to attend to the online sessions of Oracle Developer Live and one of the Hands on Lab session. I wanted to share my experience about the Oracle Developer Live sessions and about the lab session with Oracle data professionals, SQL developers and database administrators.

    First of all, I attended Oracle Developer Live — Oracle Database for Europe, Middle East and Africa on 18th of August

    The agenda is sure for developers and included a lot about SQL coding like best practices, the modern SQL, JSON within Oracle databases, querying JSON, microservices
    You know in recent years, the application developers are using JSON for data and it is a common data communication method to use JSON as structure.

    There was also a session where developers discussed about the relational databases vs JSON

    Actually, there was the Oracle Autonomous Database, Oracle APEX, JSON database, Oracle Converged Database, etc.
    Th graph features and sample SQL queries for graph data was interesting.
    What is new for me is SQL Macro statements. This enables creating function like SQL codes to execute dynamically with input variables. For example, by passing the name of the table you can return the number of rows without the danger of SQL injection

    I had the chance to work with Oracle Autonomous Database on Oracle Cloud with provided free 400$ credits for a month period
    Please follow this link OracleCloud.com with promotion code Devlivedb

    Check the agenda for the Oracle Developer Live Database sessions

  • HIVE_UNKNOWN_ERROR: The specified bucket does not exist

    While I was trying to create an AWS Athena table to query data from an Amazon S3 bucket where data is stored in parquet format files, I got following error message:

    Your query has the following error(s):
    HIVE_UNKNOWN_ERROR: The specified bucket does not exist (Service: Amazon S3; Status Code: 404; Error Code: NoSuchBucket;

    I later realized that the error is caused because of the format of the S3 bucket and subfolder where the content files are stored
    In table creation wizard, there is a hint message for AWS Athena users for identifying the S3 bucket and folders


    On the other hand, the S3 location should be provided in the format of:

  • What I learnt today: What is Low-Code ?

    Today I tried to make a short introduction to low-code.
    I tried to read a few articles and watched a explanatory video that helped me to understand what is low-code
    Especially low-code is announced to be a game changer for the efforts of enterprise companies to complete digital transformation successfully

    As the name implies in a self explanatory way, the amount of code required to build an app is low or less than custom application development.
    Of course, if you code less for the same output when compared with another app that coding takes more time, you have the freedom to try and fail or see if it is successfull or not. Your chance to take two-way decisions gets higher with a fast and cheap development that is the benefit of low-code app development.

    Let's now check how SAP explained Low-Code:
    Low-code development platform allows users to create applications predominantly through graphical interactions and configuration. They allow for a wider range of participants in the application development process and quicker application creation and deployment, helping organizations meet business needs faster. As the term implies, low-code development platforms greatly reduce, but may not completely eliminate the need to hand-code actions.
    The fundamental idea of a low-code development platform is that a wider range of people can contribute actively to application development, and that their target audience is not limited to formal developers.
    Low-code development platforms emerged to allow for quick creation and deployment of applications that can address the specific needs of a business organization, while side-stepping the formal software development process.

    So the definition from SAP for Low-code is nearly the same of previous explanation.
    What is interesting for SAP developers and for me as an ABAP developer who has worked on SAP Screen Personas for years, SAP claims with Slipstream Engine, SAP Screen Personas is a low-code development platform designed to create mobile applications on top of existing SAP functionality.

    I know it smells marketing but just to understand and get used to terminology of low-code application development, you can read this low-code guide
  • Python TypeError: 'str' object is not callable

    Hello Python developers or programmers trying to learn Python

    I'ld like to share an error that confused me a lot on IDLE when I executed a simple Python code while I was following Python 101

    Traceback (most recent call last):
    File "test-python.py", line 14, in
    numc = str(myNum)
    TypeError: 'str' object is not callable

    When I checked the mentioned Python code like, all seemed very logical.
    I was converting a numeric variable using STR() function and storing into an other variable as follows

    myNum = 26
    numc = str(myNum)

    That is interesting that the IDLE points to line 14 where the STR() convert function is used, actually the cause of the error is beforehand.

    I realized that I created a string variable named "str" which was causing all those troubles.

    str = "hello world!"
    myNum = 26
    numc = str(myNum)

    Changing the name of the variable from "str" to another non-keyword name helped me to solve the issue

  • Develop Better Code by Writing Testable Code

    I have enrolled openSAP course "'Writing Testable Code for ABAP" and completed the first week of this very useful 6 week long course.
    The first week is an Introduction to ABAP Unit Testing
    The best part is in the first week ABAP programmers could complete two hands-on exercises on developing ABAP unit tests which provides a fast intro to unit testing on ABAP environment using Eclipse as development environment.

    I just want to put some of my notes here to share with ABAP developers who are interested in learning unit test development

    Some acronyms for test developers to keep in mind:
    FIRST => Fast, Independent, Repeatable, Self-validating, Timely
    KISS => Keep It Simple, Stupid
    DRY => Don't Repeat Yourself

    Try to keep naming rules for the name of the object you are aiming to test.
    Use CUT_ prefix at least which means "Code Under Test" for the instance object you are testing
    Always follow a testing story which can be expressed by "Given, When and Then"

    I also want to share the test pyramid which expresses efforts/coverage vs. cost/runtime visually to highlight the importance of unit testing for your ABAP developments.

    And here are two quotes emphasizing the importance of testing:

    "There are no tricks to writing tests, there are only tricks to writing testable code." by Miško Hevery

    "If the tests are good, then the product code is probably good enough.
    If tests are bad or do not exist, then all hope is lost." by Gerard Meszaros

  • SAP S/4HANA Migration Cockpit Tool

    Hi SAP S/4HANA ABAP developers and SAP professionals, today I want to write about SAP S/4HANA Migration Cockpit data migration tool which is shipped built-in with S/4 HANA.

    Before giving details about the tool, I want to share you a bunch of web resources and reference URLs that will definetely help you understand Migration Cockpit data migration tool for S/4 HANA

    First, start with openSAP course Data Migration to SAP S/4HANA which you can enroll anytime at https://open.sap.com/courses/s4h8

    A second web address that will help you is Trainer which enables you experience a hands-on similar trial of SAP S/4HANA Data Migration for On Premise systems.
    I suggest you to check this address for understanding and visualizing how Migration Cockpit works

    Again for every topic on SAP S/4HANA Migration Cockpit to get more information refer to help.sap.com

    You can view and download a presentation about S/4HANA Migration Cockpit at sap.com

    You can read the blog entry for a brief start to Migration Cockpit tool on onPremise SAP system.

    Check Roadmap Viewer for Data Migration topics and benefit from accelerators

    Another important resource provided by SAP is the SAP Best Practices for SAP S/4HANA Cloud for Enterprise Management. You can reach at SAP Best Practices Explorer under Database and Data Management > Enterprise Information Management

  • Questions and Limitations on Parametric CDS Views on SAP HANA Database

    While working on SAP HANA database with parametric CDS views that can be created using SAP HANA Studio, I come across with a few problems that seem to be hard to resolve.

    For example, ABAP SQLScript developer can create parametric view.
    It is also possible to assign a default value using annotations.
    But it is not certain or at least I could not find a way to call a CDS view without explicitly assigning values to optional parameters.

    Also I could not pass NULL values as CDS view parameter values.

    TOP clause is also a question for me.
    In fact if you are developing SQL, you will know that it is meaningless to use TOP n clause in a SQL View definition.
    Maybe this is the reason SAP HANA database SQLScript also does not let me to use TOP to select top 10 rows for example in CDS view definition.

  • openSAP Course: Enabling Entrepreneurs to Shape a Better World

    Hello all,

    Today I'ld like to talk to you about an OpenSAP course on entrepreneurship titled "Enabling Entrepreneurs to Shape a Better World"

    First of all, I want to remind you all OpenSAP courses are free. You can attend online courses which last from 4 weeks to 7 or 8 week durations with online assignments and peer tasks to complete. I strongly advice all to take these free online courses from OpenSAP. Especially if you are an ABAP developer, you will find courses about SAPUI5 and new UX courses like software design for non-designers, SAP Fiori app development or SAP Hana Cloud Platform courses, etc.

    Please visit OpenSAP now and register for a free course about SAP or SAP technologies like SAP UI5, Personas or on SAP approach and tools on common technology terms like Entrepreneurship, Digital Transition, etc.

    Let's return back to our main topic of this blog post: Enabling Entrepreneurs to Shape a Better World
    Please visit the course introductory page Entrepreneurship to have a rough idea about the course.

    Although the first weeks are concentrated on migration problem all over the world as a study topic for social entrepreneurship, following weeks topics cover the mindset of an entrepreneur, tools and processes that an entrepreneur should master, failure topic and storytelling, etc.

    I must say that the topics and the educators are very interesting and known social entrepreneurs in their expertise areas. The course is even very good at to know these names better on action.

    Let's copy the course content for you here

    Course Content
    Entrepreneurship to Foster Societal Change
    Deep Dive into Problem Solving and Ideation
    Innovative Thinking, Approaches and Business Modelling
    Preparation and Testing
    Storytelling and Motivating
    Scaling Sustainably

    And here is a short list of the entrepreneurs giving speech during the course.
    Ryan Little,
    Andy Goldstein,
    Professor Muhammad Yunus,
    Nick Allardice,
    Patmanathan Pillai,
    Klaus Sailer,
    Zoran Puljic,
    Cliff Prior, and many others,

    improve your mindset for entrepreneurship

  • Node.js Training NodeSchool Istanbul

    I'll be attending soon the Node.js training held by NodeSchool Istanbul.
    That will be a beginner level one day training and will be useful to get the concepts of Node.js rapidly and to see the Node.js on action as the way it is used by experts on it.

    The details and the agenda of the Node.js training can be checked at EventBrite web site

    But to make a short list of the main titles in this short training on Node.js following will be explained:
    What is Node.js
    Node modular structure and NPM (Node Package Manager)
    Node Core API
    Node.js RESTful API
    Building Desktop Applications

    Below I just put a graphical representation of the Node.js components to see where Javascript developers can benefit from Node.js.

    Node.js components

    I wish to leave the training with a handful tips and clues for a new project based on Javascript

  • SAP TechEd 2015 Barcelona KeyNote by Björn Goerke

    Last week I was in Barcelona to attend the SAP Teched 2015 Barcelona.
    It was great experience to be attending TechEd events where thousands of IT professionals gather on similar interest areas with you.
    I was years ago in Barcelona for Microsoft TechEd and I must admit that SAP is doing TechEd as good as Microsoft does.

    Any way, I will share my SAP Teched Barcelona notes with you in my posts and provide you documentation, hands on lab notes, session notes, etc.

    Today what I want to recommend you is to watch the SAP Executive keynote on second day of the Teched by Björn Goerke
    The Developer: Bring Digital Home

    SAP Teched Keynote presentation

  • Microsoft Announced Release Dates for Visual Studio 2015 RTM Editions

    Microsoft announced the released dates for Visual Studio 2015 RTM editions.
    On 20th of July the main line and tools with Visual Studio 2015 are released and these are available for download now.

    Following Editions are available for download:
    Visual Studio Community 2015 (This is free for developers, download free and code using Community edition free)
    Visual Studio Enterprise 2015
    Visual Studio Professional 2015
    Visual Studio Test Professional 2015
    Visual Studio Express 2015 for Windows Desktop
    Visual Studio Express 2015 for Web

    Only the Visual Studio Express 2015 for Windows 10 is not released but soon be available for programmers.

    On 29th of July 29, Windows 10, Windows 10 SDK and Visual Studio Universal Windows app development tools will be released
    For the details of the announcement, please read Windows Blog

    Visual Studio developers can follow and find the download links for Visual Studio 2015 at Download Visual Studio 2015

  • SQL Server 2016 is on the way

    Microsoft has announced the new version of its Data Platform tool, SQL Server 2016 to be first available for Public Preview within a few months.

    I'll be adding SQL Server 2016 features and enhancements introduced for database professionals soon. By the time, you can as always get the most relevant and correct information about Microsoft SQL Server 2016 from Microsoft's SQL Server 2016 product page

    SQL Server 2016
  • SQL Server 2014 In-Memory OLTP

    Hi SQL developers and SQL Server database administrators,

    I've started to study the new In-Memory OLTP enhancements introduced with Microsoft SQL Server 2014 CTP1. I must say that it was easy to start using in-memory optimized database and tables on my development and test laptop.

    The table create syntax and the stored procedure syntax is showing different than as we get used to. But it is not hard to understand and use the new syntax for memory optimized tables and for natively compiled stored procedures.

    As my first impression on the performance improvement that comes with SQL Server 2014 in-memory OLTP, I can easily say that it is great.
    My dummy PC with not configured for SQL Server data tasks provided 1000000 rows insert into memory optimized database table in 4 seconds. On the other hand, it took about 75 times more time to insert 1 million records to a normal table stored on physical disk.

    I'll be concentrating on in-memory optimized database enhancements of SQL Server 2014 more in coming days. So see you on my next post.
    Update: For database administrators who requires a temporary memory resource tı support caching for minimizing IO reads and optimizing IO throughput, SQL Server 2014 introduces Buffer Pool Extension. Buffer pool extension enables administrators to add a SSD (Solid State Disk) or a flash disk for SQL Server engine to use as buffer pool to increase caching for reducing disk IO
  • SQL Server 2014 side by side setup failed

    Hello SQL Server data platform professionals,

    I've been worked as a Transact-SQL developer and take care of SQL Server database maintenance and BI development especially of SQL Server Reporting Services and OLAP cubes in SSAS for long time.
    With the new version of SQL Server release, SQL Server 2014 CTP1 I get excited and impatient to try and learn the new enhancements and improvements in SQL Server for database administrators and SQL developers as well a BI developers.

    If you also want to download and try latest SQL Server release, SQL Server 2014 CTP1 please refer to Free Microsoft SQL Server 2014 Download

    Unfortunately side by side installation of SQL Server 2014 CTP1 with previous versions of SQL Server is not supported at this step yet.

    The setup rules check prepared a report titled Microsoft SQL Server 2014 Community Technology Preview 1 - System Configuration Check Report containing the following failed points on my configuration:

    Checks whether there is an existing SQL Product other than SQL14 CTP1 installed.
    A SQL product other than SQL Server 2014 CTP1 is detected. You cannot install this release until the existing instances of SQL products are uninstalled.

    And an other problem occured during Visual Studio installation check rule:

    Block SQL14 CTP1 installation when versions of Visual Studio that install SQL Server 2012 client libraries are present on the machine.
    Installation blocked due to detection of versions of Visual Studio that install SQL Server 2012 client libraries. SQL14 CTP1 is prerelease software and should be installed only on a clean machine.

    I think I have to wait at least a few days more to test the new SQL Server 2014 features and enhancements for database professionals.
  • SQL Server 2014 and Big Data approach from Microsoft

    Microsoft has announced SQL Server 2014 during TechEd at the beginning of this month. And before the end of month comes, Microsoft has released the first public preview of SQL Server 2014, Community Preview 1 aka CTP1.

    And what will be the most attractive enhancements for data professionals is in-memory OLTP enhancements in SQL Server 2014 database engine. This performance boost is delivered as an output of the project Hekaton which is developed with Microsoft Research

    Why in-memory OLTP can be considered as most important feature of SQL Server 2014? Because in-memory OLTP objects will provide 10 to 60 times performance improvements without any code or application change.

    Besides in-memory OLTP feature, SQL Server 2014 introduces Clustered ColumnStore which is one step ahead of ColumnStore index which was first introduced to SQL Server developers and Data Warehouse developers with SQL Server 2012.

    SQL Server 2014 will enable database administrators to integrate solid-state storage (SSD) into SQL Server easily without interrupting database execution to increase performance and minimizing Disk IO

    All these performance increase with Hadoop Connectivity will make SQL Server 2014 database engine a data platform for enterprises to deal with Big Data.

    Go and download your free evaluation copy of SQL Server 2014 to see what is new in SQL Server 2014 for you.

More Posts Next page »

Copyright © 2004 - 2020 Eralper YILMAZ. All rights reserved.
Community Server by Telligent Systems