In the last article we saw the different ways how one can analyse the SQL Queries running under the Magento’s hood. These are listed here again: To see all queries issued to the database Modify the core Magento code that deals with the database query generation Enable Magento Pdo MySql debugging Switch on MySQL logging … Continue reading Magento SQL Logging – (Part II)
Magento SQL Logging – (Part I)
As with any e-commerce solution Magento stores nearly all the data of the online store in a database. To simplify the communication between code and the database Magento provides a number of abstraction functions. The use of abstraction to communicate with the database leads to the question of what queries are being issued to the … Continue reading Magento SQL Logging – (Part I)
Automatically mark the current week in an Excel Chart
Last time we discussed how to highlight a row in Microsoft Excel automatically. This can be accessed here. Today we will discuss how to highlight a particular entry in a Microsoft Excel chart. The final result is shown in Figure 1. To demonstrate how the above is achieved, we will use the following data: Step … Continue reading Automatically mark the current week in an Excel Chart
Highlight a row in Excel based on a cell value
In this blog entry we take a look how to highlight a row in a Microsoft Excel table based on a cell value. First we take a look at the steps required and then we take an example to see it in practice. We will use the “Conditional Formatting” feature of Microsoft Excel. Steps to … Continue reading Highlight a row in Excel based on a cell value
Introduction to File System Monitoring
Microsoft Windows operating systems are made up of different subsystems. One of these subsystems handles and controls the file system. Any operation performed by the user that involves files is supervised and controlled by this subsystem. One of the many functions of the Windows File Subsystem is to notify third-party applications of any file activity … Continue reading Introduction to File System Monitoring