The most recognisable spreadsheet application in the World

Today Microsoft Excel is one of the most popular spreadsheet application in the World. It is literally everywhere, in Schools, at Universities, it is probably installed on your personal computer and on your company’s computer.

Throughout the years Excel has become a powerful spreadsheet application, it allows user to extend its functionality by external add-ins or user-define functions (UDF) written in VBA, and with Excel 2016 (few years ago), Microsoft announced to build in some Business Intelligence (BI) functions. It led to increase interests in Excel.

Let’s take a look of how…


This article will explore the issue in greater detail

Photo by Snowing on Freepik

In my last published article I said goodbye to Stored Procedures, briefly mentioning SQL injection and providing a conclusion in the context of advantages and disadvantages of stored procedures. The big selling point for stored procedures is that it naturally prevents from SQL injection. Unfortunately, this may not always be the case, and one would argue that keeping good code practices will most likely make SQL injection attack virtually impossible, regardless of whether stored procedure is used, or not.

This article, designed for beginners, will explore the issue in greater detail.

Case study


In this article I will explain why I do not need them that much

Photo by Megafilm on Freepik

Back in the days many business applications that were using SQL databases, tended to have part of the logic in stored procedures. On the one hand this may increase the performance (or naturally we tend to believe so), but on the other hand it can make maintenance (versioning and testing) or migration to a different vendor much more difficult. In the past I also built applications (mostly desktop) that used loads of stored procedures. …

Tom Kandula

Software Developer at ITMagination

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store