Archives

Archives / 2018 / October
  • Some notes on Azure Services Fabric

    Hello everybody,

    today I want to make few notes on Azure Services Fabric.

    First of all, I'd like to point that Azure Services Fabric is a tool, intended for building scalable apps. Besides Azure Services Fabric, Microsoft Azure provides following options of working with scalable applications:

    Azure Container Service

    Azure Service Fabric

    Azure Functions

    Azure Container Service is docker orchestration technology. If you feel yourself as cool admin you can jump right into writing docker files, manage running docker containers etc. But there are three tools for container orchestration available at Microsoft Azure:

    Docker Swarm

    DC/OS

    Kubernetes

    Azure Service Fabric is purposed … more

  • How to make MS SQL stored procedure that is protected from SQL Injection

    Hello everybody,

    today I want to write a simple note on how to make stored procedures in MS SQL server which are protected from SQL injections. 

    Below goes example of SQL stored procedure, that is vulnerable to SQL injection attacks:

    -- Bad code, don't use it ever

    CREATE PROCEDURE SearchCustomers

    @searchCust varcahr(50)

    AS

    BEGIN

    DECLARE @query VARCHAR(100)

    SET @query = 'SELECT * FROM Customer WHERE NAME LIKE ''%' + @searchCust + '%'''

    EXEC (@query)

    END

    Why it is bad? Because if somebody passes into @searchCust value or 1=1 --- then SQL will return all customers. If to add a bit more creativity it's possible to get from that database plenty of information.

    If you wonder, … more

  • OWASP top 10 security risks

    Hello everybody,

    today I want to mention top 10 security risks according to OWASP ( Open Web Application Security Project ):

    Injection

    Cross Site Scripting

    Broken Authentication and session management

    Insecure direct object references

    Cross site request forgery

    Security misconfiguration

    Insecure cryptographic storage

    Failure to restrict url access

    Insufficient transport layer protection

    Unvalidated redirects and forwards

    This top 10 is 10 technology independent ways of checking security of any web site independently of used technologies: either .Net or PHP or Java Server Pages or NodeJS more

  • Proof of Work Schema

    Hello everybody,

    today I want to present schema of something named Proof of Work. 

    There are people which better understand situation with pictures then with words. Also there is a saying one picture is worthy thousands of words.

    First of all, imagine, that all blockchain is 6 computers. All of them of course connected. For example like on the picture:

    Computer 5 is in another colour for a reason. Read next part and you'll get why.

    Next think, imagine, that we have in blockchain 4 elements. Like this:

    And of course, task. It is needed to add one more chain: blockchain5 to all of this. Here is what will happen:

    It's not possible just to add blockchain5 via simple copy in memory … more

  • Unites of measure in Ethereum

    Hello everybody,

    today I want to make clear document on units of measure in Ethereum.

    Unit

    Quaintiti in one ETH

    Most appropriate uses

    Eher( ETH )

    1

    Used for denomination of transaction amounts and mining rewards

    finney

    1000

    szabo

    1 000 000

    Currently used for cost of transaction ( 500 szabo )

    Gwey

    1 000 000 000

    Used for Gas Prices

    Mwei

    1 000 000 000 000

    Kwei

    1 000 000 000 000 000

    wei

    1 000 000 000 000 000 000

    The base invisible unit used by Solidity programmers

    Honestly saying for me it was hard to find this info in such a format. more

  • Tools for local blockchain development

    Hello everybody,

    today I want to write a few words about local blockchain environment for development. 

    In order to have everything on one machine for development you can consider following tools:

    Chrome with metamask

    For coding you can use Visual Studio Code ( there are ways of working with Visual Studio Proffesional or Enterprise but I didn't find way for 2017 editions. Only 2015 )

    nodejs

    windows build tools ( installed via nodejs )

    ethereumjs-testrpc

    With list of those tools C# developers will fill themselves more or less in their plate and ready to go for development. At least I fealt :) more

  • Global variables in Solidity

    Hello everybody,

    today I want to write few words about global variables in Solidity. First of all I'd like to say that global means not only some global variable that you've declared in your code. Also it means part of memory whicy is automatically provided to your contracts.

    In other words global means that those variables are always avaialable for any part. 

    The first is msg. Those three letter stand for word message and it is a structure that has fields sender, value, data, gas, signature. 

    For example in order to get sender, you can use following fragment of code:

    address owner = msg.sender;

    Next very interesting is amoung of ethers send. In order to get it following code can be … more

  • Some Solidity data types from C# standpoint

    Hello everybody,

    today I want to write a few words about data types in Solidity, language of programming for Ethereum and how they can be declared.

    First of all there are simple types like byte, int, int256, uint128, bool etc. All of them are value types.

    There are also bytes, string which are reference types. 

    Reference types has interesting features. 

    bytes a; is equal to byte[] a; in C#.

    mapping is something like Dictionary in C#. For example you can make following dictionary Dictionary<string, int> prices; in Solidity like this:

    mapping (string => int) prices;

    In that case prices will a bit like a Dictionary in C#. For example you can write something like this:

    prices["potatoes" … more

  • Layout of Solidity program from standpoint of C# developer

    Hello everybody,

    today I want to make post about solidity program.

    Programs can start from pragma solidity line. 

    It looks like this:

    pragma solidity 0.3.1; 

    pragma line says what is maximal version in which contract should be compiled.

    often you can see line like this:

    import "filename"

    you can import some file which has extension ".sol" but file name should be without sol ending.

    If to speak in analogies in C# or Java everything or almost everything is a class, but in Solidity everything is contract.

    It can look like this:

    contract ContractName

    {

    }

    Inside of your contract you can declare any kind of variables which are commonly named state variables. 

    Declaration goes … more

  • What is solidity

    Hello everybody,

    Today I want to write a few words about what is solidity, and why on Earth it was invented.

    Before I'll do that few words about blockchain.

    Blockchain consists of two main words: block and chain.

    And special feature of blockchain is that it is made in a way, that each new part of it is made with taking into account previous blocks of information ( through hasing ). Another part is that everybody who is involved in blockchain has that information on theirs computers. In other words new additions somehow include information about previous pieces. 

    Then consider the following. Suppose government of some country want's to print more money. As usually they want to do it for … more

  • GDPR in Blockchain

    Hello everybody,

    today I want to notice very important note about personal information which you can store if you develop blockchain that is used at EU zone.

    Consider following scenario: you develop blockchain technology for your customers. For example you've bought from user some kind of service ( for example piece of source code ).

    According to GDPR rules user can expect right to be forgotten by your service of storing source code. But you can't erase information about his source code for some reason ( other developers built based on his codebase, 

    or in case if source code that you've bought causing harm and you want to avoid/double check his source code, etc).

    How to deal in that … more

  • Income statement abbreviations

    Hello everybody,

    today I want to write a few words about Income statment abbreviations which can be seen there. 

    First of all I'd like to say that Income statement often is named Profit and Loss account. In Acumatica it is named sometimes as PNL ....

    COGS - cost of goods sold

    SG&A expenses - Selling Generative and administrating. In other words operating expanses like salary, rent, electricity, etc.

    Gross Margin = Total Sales - COGS

    Gross Profit = Total Sales - COGS

    Operating profit = revenues - operating expenses - depreciation - COGS

    EBIT = Operating profit = Earnings before interest and taxes

    EBITDA = Earnings before interest taxes, depreciation and amortization = gros margin - … more

  • Depreciation vs Amortization

    Hello everybody,

    today I want to write a short note about Depreciation and Amortization and whati is the difference between both. 

    So both of them reflect information about loosing value of some non current asset. If company bought something for one price, and with time that something looses it's value.

    What the difference?

    Depreciation is connected to tangible asset.

    Amortization is connected to intangible asset.

    For example loosing of value of laptop is characterized by depreciation.

    Loosing of value of software is characterized by amortization. more

  • AR vs AP

    Hello everybody,

    this post is intended for Acumatica developers which wonder about difference between AR and AP screen or as they named accounts payable and accounts receivable. If to speak simply both of them are intended for future benefits. The difference is just who is receiver of those benefits: your company ( accounts receivable ) or not your company ( accounts payable ).

    Consider example: your company sells laptops. In case if HP gave you 10 latpops, then information about them will be written at your accounts payable. But for HP those laptops will be at accounts receivable. Let's say somebody made agreement with your company, that they will pay you in two months for 2 out of your 1 … more

  • Key features of Acumatica

    Hello everybody,

    today I want to make a post about by no means exhaustive but quite descriptive list of features in Acumatica.

    Main features Acumatica

    Accounts payable

    Accounts receivable

    Advanced CRM - convert prospects to accounts with 1 click

    Advanced accounting - multi-currency, consolidation ledgers

    Advanced billing

    Advanced distribution - inventory, sales, purchasing

    Allocate expenses

    Budget tracking

    CRM integration

    Campaign management

    Case management

    Cash management

    Currency management

    Customer management

    Customer portals

    Distribution management

    Employee portal (timesheets, expense reports)

    Enterprise features - mid-sized business costs

    Expense management … more

  • Contract API Optimization

    Today, I want to re-tell about Contract API Optimization. Materials get from conference of Acumatica and introduction by Joshua van Hoesen.

    Three point of ineterst

    Utilisation of ReturnBehavior

    Avoid graph logic by creating Generic Inquiry for data retrieval

    Multi-Threading

    Introduction

    With the continued advancement of integrated software solutions, there has also been a need to address legacy business processes and how they may be implemented in a modern framework. These business processes tend to rely heavily on collecting large amounts of raw data from disparate sources and aggregating it together for further processing.

    Some companies whose business process … more

  • Liabilities in Accountancy

    Hello everybody,

    now let's go for liability definition.

    Liability in accountancy word definition is like this: present obligation of the firm to transfer economic benefits in the future to another party that arise from a past event or transaction.

    Definition has following key parts:

    present obligation

    transfer benefits

    past transaction event

    From this standpoint bank loan is liability. 

    Potential lawsuite without estimated fine size can't be liability, but definetly should be mentioned in footnotes of balance sheet. 

    3 years warranty is also liability. For example warranty for the car. And if company can estimate their obligations on warranty then those kind of liabilities are … more

  • Asset non asset difference

    Hello everybody,

    today I want to write few words about difference between something important in the company, that can be asset and close to asset but not be considered as asset from acocuntancy standpoint.

    First of all let's start from definition. Asset has three key parts in its definition:

    ownership

    generates benefit

    arises from transaction

    Full definition of asset sounds like this: Asset is a resource owned or controlled by the firm that it is expected to generate future economic benefits and arises from a past event or transaction. 

    From this definition stnadpoint piece of equipment which is worth 1M $ is an asset because 

    owned by company

    will generate profit

    resulted … more

  • Development methodologies

    Hello everybody.

    Today I want to make a post about list of development methodologies. How much of them you can name? Agile/Scrum, Waterfal. Which else? Take a look at list that I've discovered for myself:

    Waterfall

    Prototype

    Agile

    Rapid Application Development

    Dynamic System Development Model Methodology

    Spiral Model

    Extreme Programming Methodology

    XP

    Joint Application Development

    Lean Development

    Scrum

    How many of those you know/tried/practiced? more

  • Two sets of principles in Accountancy

    There are two main standartizers of Accountancy:

    IFRS

    US GAAP

    IFRS stands for Inernational Financial Reporting Principles. IFRS is set in London by International Accounting Standards Board IASB.

    US GAAP - United States Generally Accepted Accounting Principles. US GAAP is set by Financial Accounting Standards Board.

    more

  • Prospectus

    Hello everybody,

    in order to become better Acumatica developer I've decided to take course on Accounting: Principles of Financial Accounting.

    Here I'll share some ideas that become new to me.

    So, I want to speak about Prospectus.

    Securities and Exchanges commision requires that any kind of company that borrows money from potential investors provide to them document which has following information:

    Company history

    Management biographies

    Financial statement

    Best-case scenario

    Worst-case scenario

    Other information that will help investors to make informed decision

    So, next time when I'll hear prospectus it will mean for me some kind of document which will say something like … more