Techmechtips

Digital Document Management Naming a file is a very neglecting issue but very helpful and beneficial in the long run. In everybody’s computer you will see a pile of files whether useful or pointless. The pointless files are considered as junk and junk files occupy unnecessary space in your computer whether official or personal. So, devise or adopt a healthy system for file naming not only for professional level but personal level too. File naming convention : A file naming convention is a way that describes the system to keep your files in order or easily traceable in case of need. For tracking and preventing duplicating of file, it is necessary to devise some conventions to define naming of file. It will be easier and faster for you or your co-workers to find, identify, and retrieve information, if folders and files are named systematically, logically, and appropriately. There are mainly four types of naming conventions in coding but here we are using three of them for naming conv...

Types of Maintenance  Maintaining a computer system is essential to its lifetime and best performance. Frequent maintenance, such as physical cleaning, antivirus checks, and software updates, avoids crashes, slowdowns, and data loss. It keeps your data safe by protecting it from security risks like malware and viruses. Additionally, by extending the lifespan of hardware components, maintenance lowers the need for expensive repairs or early replacements. An effectively maintained system increases productivity and offers a more dependable, seamless user experience. Frustrating problems and maybe high costs result from neglecting it. To keep you system healthy always ensure timely maintenance of your system.  Effective maintenance minimizes downtime, prevents data loss, enhances performance, and extends system lifespan. It encompasses both proactive and reactive approaches to address issues and optimize functionality.  The main types of maintenance are : 1) Corrective Mainte...

Filter Image in Excel Vlookup, Hlookup, Index, and match functions are used to search data and retrieve the desired results based on the given conditions. The alphabetical, string, and numerical data can be easily obtained using these functions. Nevertheless, it can be challenging to obtain the associated image from the Employee database or table, if you wish to do so using the Employee code or name. However, in the latest version of Excel, retrieving an image from a database that based on some criteria is quite simple using formula too. So, we are trying to tell you how we can retrieve pictures as per given condition or query from a table or database in Excel using three different methods. Maintain Images within the Cell First of all maintain position of your images in cell properly, the images should be inside the cell only. If you are using Excel365 then there is an option called “Place in Cell” but in earlier version you have to select picture then right click to choose size & ...

The insecurity and the increase of crime pressed human to think about some sort of system to keep an eye on. These types of incidents lead to the invention of Surveillance System. What is Surveillance? Keeping an eye on someone or a situation in order to gather information is called surveillance. Monitoring an area for undesirable behaviour or looking into a suspect person are two uses for surveillance. History of Surveillance CCTV was invented by Walter Bruch and was first used back in 1942 in Germany to capture live video footage. He built it, so Nazi scientists and military personnel could safely observe the launch of V-2 rockets at the Peenemunde Airfield. Marie Van Brittan Brown and her husband Albert invented the modern video security system in the late 60s. Video surveillance and recording gained momentum as a security measure in the 1970s and 1980s. Banks and retailers installed CCTV with VCRs to prevent theft. The charge-coupled device (CCD) enters the picture in 1976. Using m...

The Maya operating system has been developed in India. It is based on UBUNTU," a popular Linux system that employs free and open-source technologies. The Indian Ministry of Defence has taken this endeavour to secure its computer systems against unforeseen, vulnerable Cyberattacks that may cause minor to severe disruptions to our internal systems. It was designed with an easy and error-free transition from Windows OS to Maya OS in mind. Its interface and functionalities are quite similar to those of the Windows system, thus switching from Windows to Maya would be seamless. Maya OS also has a feature called Chakravyuh, which is end-point anti-malware and antivirus software that prevents system hacking.  As the name implies, it might be a multi-layer system that protects the system from digital threats. Its development began in 2021, following a series of cyberattacks on India's crucial information and military systems.  India recognises the importance of developing a robust ope...

Wi-Fi and Li-Fi both are wireless method of data transmission, but are different in technology usage. Wi-Fi uses radio waves while Li-Fi uses visible light for data transmission. You are more familiar with Wi-Fi but I am sure very few peoples known about this Li-Fi technology. So, let’s know about these technologies in brief:    What is Wi-Fi? Wi-Fi is a wireless networking protocol through which devices use to communicate without direct cable connections. Wi-Fi stands for Wireless Fidelity. It is based on 802.11 IEEE network standards. The Wi-Fi standards were created by the Institute of Electrical and Electronics Engineers and are certified by the Wi-Fi Alliance. In  1991, NCR Corporation with AT&T Corporation invented the precursor to 802.11 but actually  It has started in the Year 1997 with 902.11 standard. The main requirement for Wi-Fi is a device that receives and transmits a wireless signal, usually a router. Wi-Fi network is established by installing W...

Data Backup plays an important role in today’s digital world. As we are progressing further and developing new technologies to make our life easy-going, we are generating enormous amount of data. This enormous amount of data is known as Big Data. Big data means continuous generation of mystify and demystify data. To protect this sort of data is a crucial part of digital system. In order to safeguard this valuable data there is a need of backup system.  Backup of data is an important task to safeguard your digital assets like drawings, photo and database etc. Dependency on digital computer world insists us to take back up of our valuable data regularly. So, what is Backup? What is  Data Backup ?  Backup is a method to keep your data more securely in other places so that in case of loss of data due to hardware failure, malware attack, accidently delete something,  fire and natural disaster etc. to retrieve the same. This is a wonderful way to protect your digital world...