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
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.
In this article I will explain why I do not need them that much
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. …
Software Developer at ITMagination