Tuesday, May 13, 2025

๐Ÿ” XLOOKUP: Why It’s a Game-Changer in Excel

If you’ve spent hours debugging VLOOKUP or HLOOKUP formulas that mysteriously break when tables change—XLOOKUP is the upgrade you’ve been waiting for. Introduced to simplify data retrieval in Excel, XLOOKUP replaces both VLOOKUP and HLOOKUP by being more powerful, flexible, and error-resistant.

Let’s explore why XLOOKUP > VLOOKUP & HLOOKUP ๐Ÿ‘‡


1. ๐Ÿ”„ Works in Any Direction

  • VLOOKUP searches down columns

  • HLOOKUP searches across rows

  • XLOOKUP searches both ways—vertically or horizontally

No more juggling between two different functions!


2. ๐Ÿšซ No Index Numbers Needed

Unlike VLOOKUP or HLOOKUP, which require a column or row index number, XLOOKUP automatically finds the correct value—even if the structure changes.

๐Ÿ›  VLOOKUP breaks if the table changes.
XLOOKUP adapts.


3. ✅ Exact Match by Default

  • VLOOKUP and HLOOKUP default to approximate match, which can lead to errors if not set properly.

  • XLOOKUP defaults to an exact match, reducing potential mistakes right out of the box.


4. ↩ Can Search Bottom-Up or Right-to-Left

VLOOKUP can’t look to the left, and HLOOKUP can’t look up. But XLOOKUP can:

  • ๐Ÿ” Search bottom to top

  • ๐Ÿ” Search right to left

That’s serious flexibility.


5. ❌ No More Helper Columns

With XLOOKUP, you can return data from anywhere in the table, not just columns to the right.

๐Ÿ’ก No need to rearrange data or use helper columns.


6. ๐Ÿ“ค Returns Multiple Values

While VLOOKUP & HLOOKUP only return a single value, XLOOKUP can return:

  • ๐Ÿ”„ Multiple columns

  • ๐Ÿ”„ Multiple rows

Perfect for structured and dynamic reports.


7. ๐Ÿงฏ Built-in Error Handling

Instead of wrapping formulas in IFERROR(), XLOOKUP simplifies this with its own [if_not_found] argument:

=XLOOKUP(A2, B2:B10, C2:C10, "Not Found")

๐Ÿ“Œ Summary: Why XLOOKUP is the Future

Feature VLOOKUP / HLOOKUP XLOOKUP
Works Vertically & Horizontally
Needs Index Number
Exact Match by Default
Search Right-to-Left / Bottom-Up
Returns Multiple Values
Built-in Error Handling ❌ (Needs IFERROR) ✅ (if_not_found)


๐Ÿšซ Windows 11: Microsoft Removes OOBE\BYPASSNRO – Here's the New Local Account Workaround

Microsoft continues its push to force online accounts during the Windows 11 setup process by disabling the well-known OOBE\BYPASSNRO.cmd method. But don’t worry — a new workaround has surfaced, thanks to YouTuber NetworkTecho.

Here’s how you can still create a local account in Windows 11 setup without internet access or Microsoft login.


๐Ÿงญ Step-by-Step: New Local Account Bypass (2025)

๐Ÿ”น 1. Begin Windows 11 Setup

  • Boot into the Windows 11 installer.

  • Select your Region and Keyboard layout as prompted.


๐Ÿ”น 2. Stop at the Secondary Keyboard Layout Screen

  • When asked to “Add a second keyboard layout,” DO NOT click Skip.


๐Ÿ”น 3. Open Developer Console

  • Press Ctrl + Shift + J

  • The screen will dim and show a black developer console at the top-left corner (> prompt).


๐Ÿ”น 4. Enter Restart Command

Type this case-sensitive command:

WinJS.Application.restart("ms-cxh://LOCALONLY")

๐Ÿ”ธ Pro Tips:

  • After typing WinJS.A, press Tab to autocomplete to Application.

  • After typing res, press Tab to autocomplete to restart.


๐Ÿ”น 5. Exit Developer Console

  • Press Enter to run the command.

  • Then press Esc to close the console.
    (If Esc doesn't work, click on the screen to refocus, then try again.)


๐Ÿ”น 6. Local Account Setup

  • The setup will refresh.

  • Now, you’ll see the Windows 10-style local account screen.

  • Enter:

    • Username

    • Password (optional)

    • Security questions

  • Click Next.


๐Ÿ”น 7. Complete Windows 11 Setup

  • Setup will resume.

  • After a black screen, you’ll be logged into your new local account.

  • Finalize privacy settings, and you’re good to go!


✅ Summary

๐Ÿงฑ What Changed ❌ Microsoft removed OOBE\BYPASSNRO.cmd
๐Ÿ”“ New Bypass WinJS.Application.restart("ms-cxh://LOCALONLY") via dev console
๐Ÿง‘ No MS Account You can still set up a local account (as of May 2025)

๐Ÿง  Why It Matters

  • Great for privacy-conscious users

  • Avoid telemetry and online login requirements

  • Useful in offline setups and enterprise deployments

๐Ÿ“Œ Bookmark this guide — Microsoft may change this again in the future, but for now, it works!


๐ŸชŸ Windows Update Error: Understand Mysterious Hex Codes Easily

When installing Windows updates, it's common to face cryptic error messages—often displayed as hexadecimal codes like 0x80073701. For system administrators and power users, decoding these can be frustrating.

๐Ÿ’ก Example Error Code:

0x80073701

๐Ÿ” What Does It Mean?

These hexadecimal codes are part of the Win32 error system and are not immediately human-readable. Thankfully, Windows includes a native tool to help decode them:

๐Ÿ› ️ Use certutil.exe to Translate Error Codes

certutil is a built-in Windows utility primarily used for certificate services, but it also contains a hidden gem: an error code translator.

✅ Command to Run:

certutil -error 0x80073701

๐Ÿงพ Output:

0x80073701 (WIN32: 14081) - ERROR_SXS_ASSEMBLY_MISSING

๐Ÿง  Meaning:

This tells you that a component required by Windows Update is missing—likely a side-by-side assembly (.manifest or .dll file). This often affects cumulative or security updates.


๐Ÿงฐ Next Steps to Fix It

  1. Run System File Checker (SFC):

    sfc /scannow
    
  2. Run DISM to Restore Health:

    DISM /Online /Cleanup-Image /RestoreHealth
    
  3. Reboot and try the update again.

  4. If error persists, use Windows Update Troubleshooter or download the update manually from Microsoft Update Catalog.


๐Ÿ’ฌ Final Tip

When you see any 0x code, remember:

certutil -error 0x[CODE]

...will help demystify it instantly.

๐Ÿ“Œ Bookmark this tip—it’s a time-saver for any Windows admin or tech enthusiast.



Wednesday, January 22, 2025

The Impact of Quantum Computing on IT Infrastructure

 

Introduction to Quantum Computing Quantum computing promises to revolutionize the way we process information by using quantum bits (qubits), which can represent and store information in a fundamentally different way than the bits used by classical computers. This capability allows quantum computers to solve complex problems much faster than current technologies.

Quantum vs. Classical Computing Unlike classical computing, which uses bits as the smallest unit of data (0 or 1), quantum computing uses qubits, which can exist in multiple states simultaneously thanks to superposition and entanglement. This allows quantum computers to process a vast number of possibilities simultaneously, making them incredibly powerful for certain tasks like cryptography and optimization problems.

Challenges of Integrating Quantum Computing Integrating quantum computing into existing IT infrastructures presents several challenges:

  • Technological Maturity: Quantum technology is still in its early stages and is not yet robust enough for widespread commercial use.
  • Cost: Building and maintaining quantum computers is currently very expensive.
  • Skill Gap: There is a significant skill gap in the workforce for quantum computing expertise.

Preparing for Quantum-Ready IT Organizations can prepare for quantum computing by starting to experiment with quantum algorithms, investing in quantum computing skills development, and staying informed about advancements in quantum technology.

Quantum Computing and Data Security Quantum computing poses both risks and opportunities for data security. On one hand, it could potentially break many of the cryptographic algorithms currently used to secure data. On the other hand, it also offers new ways to create virtually unbreakable encryption through quantum key distribution.

Each of these posts provides a thorough examination of its respective topic, designed to engage your readers and enhance your blog’s standing as a key resource in the technology community. Feel free to adapt the content to better fit your specific audience and editorial style.

Exploring the Role of AI in Cybersecurity

 

AI-Driven Threat Detection AI significantly enhances the ability to detect and respond to cyber threats by analyzing vast amounts of data to identify patterns and anomalies that may indicate a security breach. Machine learning models, trained on historical data, can predict potential attacks before they occur, allowing for preemptive action.

AI in Automated Security Protocols Automated security systems powered by AI can dynamically adapt to new threats without human intervention. For example, if an AI system detects unusual activity on a network, it can automatically adjust firewalls or isolate sections of the network to prevent the spread of potential breaches.

Supporting Ethical Hacking AI tools assist ethical hackers by simulating cyber-attacks on an organization’s network to identify vulnerabilities. These simulations help improve the security measures of the network by identifying and addressing potential weaknesses before they can be exploited by malicious actors.

Future of AI in Security The future of AI in cybersecurity looks promising with ongoing advancements in machine learning algorithms and their integration into security platforms. AI is expected to become more sophisticated in detecting zero-day vulnerabilities, automating more complex security protocols, and providing real-time, adaptive threat responses.

Case Studies A notable case where AI was effectively used in cybersecurity involved a large financial institution that implemented AI-driven anomaly detection systems. The AI system was able to detect a sophisticated malware attack that had bypassed traditional antivirus software, allowing the institution to react swiftly and mitigate potential damage.

What’s New in TensorFlow 2.10: Features and Enhancements

 

Introduction to TensorFlow 2.10 TensorFlow 2.10, the latest release from the TensorFlow team, continues to set the standard for machine learning frameworks with its new features and improvements. This version focuses on enhancing performance, scalability, and ease of use, making it a significant upgrade for developers and enterprises deploying AI solutions.

New Features and Enhancements TensorFlow 2.10 introduces several key features that enhance its functionality:

  • Mixed Precision Training: This feature allows models to train faster and use less memory by utilizing lower-precision arithmetic (float16 rather than float32). It's particularly beneficial for models running on GPUs and can significantly speed up the training process.
  • Extended Support for Keras Tuner: TensorFlow now offers better integration with Keras Tuner, making it easier to fine-tune models and optimize hyperparameters.
  • Improved Model Saving and Loading: TensorFlow 2.10 simplifies the process of saving and loading models, especially those with custom objects. This is crucial for deploying models in production environments where reliability and speed are key.

Code Implementation Examples Here’s a simple example of how to implement mixed-precision training in TensorFlow 2.10:

python
from tensorflow.keras.models import Sequential from tensorflow.keras.layers import Dense from tensorflow.keras import mixed_precision # Set up mixed precision policy = mixed_precision.Policy('mixed_float16') mixed_precision.set_global_policy(policy) # Build a simple model model = Sequential([ Dense(256, activation='relu', input_shape=(784,)), Dense(128, activation='relu'), Dense(10, activation='softmax') ]) # Compile the model model.compile(loss='sparse_categorical_crossentropy', optimizer='adam', metrics=['accuracy']) # Model summary model.summary()

Comparative Analysis With Older Versions Compared to TensorFlow 2.9, version 2.10 offers improvements such as a 10-15% speed boost in model training times due to optimizations in mixed precision and graph execution. The API has also been streamlined to reduce boilerplate code, allowing developers to achieve more with fewer lines of code.

Real-World Applications TensorFlow 2.10 is already being used by companies to enhance image and speech recognition systems, improve recommendation engines, and streamline financial modeling. For instance, a tech startup has used TensorFlow 2.10 to develop a more efficient and accurate predictive model for real-time bidding in digital advertising.

Essential Linux Commands for Managing AI Applications

Linux Overview for AI

Linux is the preferred operating system for deploying and managing AI applications due to its excellent stability, superior security, and exceptional scalability. Its open-source nature allows for extensive customization and control, which is crucial for handling complex computational tasks required in AI. The stability of Linux ensures that the system can run continuously without frequent reboots or downtime, which is essential for training models that require extensive computational time. Security features inherent in Linux, like SELinux and AppArmor, provide robust mechanisms to protect sensitive AI data. Additionally, its scalability allows it to handle increasing computational loads efficiently, which is vital as AI systems scale from development to production environments.

Command Line Tools for AI Monitoring

Effective monitoring is crucial in AI systems to ensure optimal performance and efficient resource utilization. Key command line tools include:

  • htop: This interactive process viewer provides a real-time view of the system's current resource usage, including CPU, memory, and swap utilization. It allows developers to monitor their AI applications and system processes from a single interface, making it easier to spot and troubleshoot performance bottlenecks.

  • nvidia-smi: Nvidia’s System Management Interface tool is essential for monitoring NVIDIA GPU performance. It provides detailed information about GPU utilization, memory usage, and thermal status, which is invaluable for optimizing AI model training that relies heavily on graphical processing units.

  • tmux: This terminal multiplexer lets users manage multiple terminal sessions from a single window. It’s particularly useful for AI development, where you might need to run several processes simultaneously—such as data preprocessing, model training, and logging—without losing access to the command line interfaces for each process.

Automating AI Workflows with Bash

Bash scripting can greatly enhance the efficiency of AI workflows by automating routine tasks such as data preprocessing, model training, and output analysis. A typical Bash script for an AI workflow might start with data download and preprocessing, followed by running a training script, and finally analyzing and visualizing the results. For instance, a simple Bash script could automate the preprocessing of new data sets through a series of pipelined commands, execute a training model, and trigger notifications upon completion. Here's a basic example:

#!/bin/bash
# Script to preprocess and train an AI model

echo "Starting data preprocessing..."
python preprocess_data.py input_data.csv processed_data.csv

echo "Data preprocessing completed. Starting model training..."
python train_model.py processed_data.csv model_output

echo "Model training completed. Generating report..."
python generate_report.py model_output report.pdf

echo "Workflow completed. Check report.pdf for results."

This script highlights how to chain commands together, handling outputs of one stage as inputs for the next, thereby automating the entire process.

Securing AI Applications on Linux

Securing AI applications involves several layers of protection, from securing the data to hardening the underlying operating system:

  • Configuring Firewalls: Tools like iptables or ufw (Uncomplicated Firewall) can be used to manage network traffic to and from the AI systems, ensuring that only legitimate traffic reaches the application.

  • Managing User Permissions: It is crucial to enforce the principle of least privilege by creating specific user roles for different AI tasks, thus limiting the access level of each user to only what is necessary for their role.

  • SELinux Configurations: Security-Enhanced Linux (SELinux) provides mechanisms to enforce access control policies that restrict system processes and users to the minimum necessary privileges. Configuring SELinux properly can prevent unauthorized access or modification of AI application files and processes.

Effective Resource Management

Optimizing CPU and GPU usage is critical for enhancing the performance of AI applications. Techniques include:

  • Process Prioritization: Tools like nice and renice allow for the adjustment of process scheduling priority in Linux, giving critical AI processes more CPU time over less critical background tasks.

  • Resource Allocation: Managing resource limits with tools like cgroups (control groups) can help in allocating resources like CPU time, system memory, or network bandwidth among user-defined groups of tasks. This prevents any single process from hogging the necessary resources, thereby ensuring that critical AI tasks get the resources they need.

Implementing these techniques on Linux helps in maintaining an efficient, secure, and stable environment for developing and deploying AI applications.

Unveiling the Power of GPT-4: How It’s Revolutionizing Industries

Introduction

GPT-4, developed by OpenAI, represents a significant advancement in the series of generative pre-trained transformers, pushing the boundaries of artificial intelligence. This iteration builds upon the capabilities of its predecessors, introducing refined algorithms that enhance both understanding and response accuracy. This post explores the breakthroughs of GPT-4, its applications across various sectors, and the broader implications it holds for future technological landscapes.

Technological Enhancements

GPT-4 marks a pivotal improvement in the realm of AI with its sophisticated architectural enhancements. The model leverages deep learning techniques to facilitate more nuanced conversations and complex problem-solving capabilities. These advancements are not just iterative; they represent a quantum leap in the AI's ability to understand context and subtleties in language, which greatly improves interaction quality and reliability in automated systems. We will explore the specific architectural changes and how they contribute to these improvements.

Applications in Various Industries

GPT-4's capabilities extend into several key industries, each benefiting from its advanced predictive and analytical functions:

  • Healthcare: In healthcare, GPT-4 automates the processing of patient data, enhances diagnostic systems, and crafts personalized treatment plans. This not only speeds up administrative processes but also aids in achieving more accurate diagnoses and tailored healthcare strategies.

  • Finance: The financial sector utilizes GPT-4 to streamline operations, enhance risk assessment, and improve customer service. Its ability to analyze vast datasets allows for more accurate predictions of market trends and risk factors, making it an invaluable tool for financial planning and management.

  • Customer Service: GPT-4 powers chatbots that offer human-like interaction capabilities, significantly improving user experience and operational efficiency. These AI-driven systems can handle a wide range of customer inquiries without human intervention, providing timely and accurate responses to customer queries.

Ethical Considerations

The deployment of sophisticated AI like GPT-4 raises important ethical questions. This section examines the potential impacts of such technology on privacy, job markets, and societal norms. Concerns about privacy arise from the extensive data AI systems like GPT-4 require for training. Additionally, the automation capabilities of AI may lead to job displacement in certain sectors, prompting a reevaluation of job roles and the skills future workforces will need. It is essential that developers and regulators work together to implement robust guidelines and frameworks to ensure that GPT-4 and future models are used responsibly.

Future of AI Models

Looking ahead, the integration of AI models like GPT-4 into daily life is likely to increase, touching more aspects of personal and professional activities. This section speculates on potential developments in AI, including how these technologies could become more integrated into everyday activities, the possible regulatory scenarios that might emerge, and how the ethical landscape surrounding AI will evolve. As AI becomes more capable and widespread, its governance and integration into societal frameworks will be critical topics of discussion for ensuring beneficial outcomes for all.

This exploration into GPT-4 not only highlights its current applications but also sets the stage for ongoing discussions about the role of AI in shaping our future.

Thursday, July 6, 2023

How to see DDR memory type in command prompt in Windows 10

 1. Open an elevated command prompt.

 2. Type the following command

wmic MemoryChip get BankLabel, Capacity, MemoryType, TypeDetail, Speed, Tag
The command produces the following output:





In our case, the information we need is MemoryType. Its value has the following meaning:

0 = Unknown
1 = Other
2 = DRAM
3 = Synchronous DRAM
4 = Cache DRAM
5 = EDO
6 = EDRAM
7 = VRAM
8 = SRAM
9 = RAM
10 = ROM
11 = Flash
12 = EEPROM
13 = FEPROM
14 = EPROM
15 = CDRAM
16 = 3DRAM
17 = SDRAM
18 = SGRAM
19 = RDRAM
20 = DDR
21 = DDR2
22 = DDR2 FB-DIMM
24 = DDR3—May not be available; see note above.
25 = FBD2

So in my case, it is DDR3, which is MemoryType of value 24.
Other memory details are as follows:

  • BankLabel - physically labeled bank where the memory is located.
  • Capacity - total capacity of the physical memory—in bytes.
  • Speed - Speed of the physical memory—in MHz.
  • Tag - Unique socket identifier for the physical memory.
  • TypeDetail - Type of physical memory represented. It can be as follows:
    1 = Reserved
    2 = Other
    4 = Unknown
    8 = Fast-paged
    16 = Static column
    32 = Pseudo-static
    64 = RAMBUS
    128 = Synchronous
    256 = CMOS
    512 = EDO
    1024 = Window DRAM
    2048 = Cache DRAM
    4096 = Non-volatile
    

If Task Manager gives you wrong information or no information at all on the type of memory you have, you can query memory details using the command prompt and see what exactly Windows knows about your memory chips.

That's it.


Friday, December 23, 2022

Force all emails to be received or shown in Plain Text

 Outlook has a security setting to force all emails to show in Plain Text. This setting applies to all emails, even the ones that were already received.

When a message is being converted to Plain Text by Outlook, there will be an Infobar at the top of the message which reads:

”This message was converted to plain text.”

Click on this Infobar to convert the message back to HTML.

Trust Center Settings

Trust Center buttonThe “Read al standard mail in plain text” setting can be found in the following location;

  • Outlook 2007
    Tools-> Trust Center…-> E-mail Security-> Read all standard mail in plain text
  • Outlook 2010 / 2013 / 2016 / 2019 / Office 365
    File-> Options-> Trust Center-> Trust Center Settings…-> E-mail Security-> Read all standard mail in plain text

Registry Setting

Registry Editor buttonThe above setting can also be set via the Registry by creating the ReadAsPlain value.

Key:
HKEY_CURRENT_USER\Software\Microsoft\Office\<version>\Outlook\Options\Mail
Value name: ReadAsPlain
Value Type: REG_DWORD
Value: 1

When this key is set to 0 or missing, all messages will display in their normal message format.

Note 1: If you are running a virus scanner that integrates with Outlook, you might also find an option there to convert all messages to Plain Text. Note that in most cases, this option works separate from the option set in Outlook. See the documentation of your security suite for more information.

Note 2: Administrators can also set this as a corporate policy.

Wednesday, January 22, 2020

How to Create a Group Email in Gmail: A Step-by-Step Guide:

How to Make a Mailing List in Gmail



  1. Open the Google Contacts page. Go to https://contacts.google.com/ in your computer's web browser. This will open a page with your Google contacts on it if you're logged into Google. If you aren't logged into your Google account, enter your email address when prompted, click NEXT, enter your password, and click NEXT to log in. If you're logged into the wrong account, click your profile icon in the upper-right side of the page and then either select the proper account (if it's signed in) or click Add account and enter your email address and password when prompted.                                                                                                         
  2. Select contacts. Hover your mouse over a contact's profile picture (or their first initial if they don't have a picture), then click the checkbox that appears in place of their picture or first initial and repeat this process for each contact you want to add.                                             
  3. Click the "Labels"  icon. The button/icon is in the top-left of the page. A drop-down menu will appear.                                                                                                  
  4. Click Create label. You'll see this option at the bottom of the drop-down menu. Doing so prompts a pop-up window.                                                                            
  5. Enter a name. Type in the name that you want to use for your mailing list. This is the name that you'll type into the "To" field when addressing an email later.                                                                                                                                                     
  6. Click Save. It's in the bottom-right corner of the window. Doing so will      save your list of contacts as a label.                                                                                 
  7. Open your Gmail inbox. Go to https://www.gmail.com/ and re-enter your email address and password if prompted.                                                                    This must be the same account for which you created the mailing list.             
  8.  Click COMPOSE. It's on the left side of the Gmail inbox. Doing so opens a "New Message" window.                                                                                                                    
  9. Enter your label's name. In the "To" field at the top of the "New Message" window, type in the name of the group. You should see the group's name and a preview of a few of it's contacts will appear below the "To" field. Click the group name below the "To" field to make it your email's recipient. If you don’t see your group’s name or you are unable to type the group’s name in the “To” field because you don’t remember it, go to the next Step. Otherwise, skip the next Step.                                                                       
  10.  1.    View a list of group names you created. If you were unable to complete the previous Step because you don’t remember the name of the group, do the following to see a list of all of your group names for the gmail account that you are currently using and then select it as your email’s recipient.
    ·         Click on the “To” in the “To” field. In the pop-up window that appears, click on the “My contacts” button near the top right corner of the pop-up window. All of the group names that you created for the current gmail account will be listed in a drop-down menu.
    ·         Click on the group name that you want to use. A preview of a few of the group’s contacts will appear in the pop-up window.
    ·         Click on the box next to “Select All” near the top left corner of the pop-up window to select all contacts in the group.
    ·         Click on “INSERT” that will appear near the bottom right corner of the pop-up window.
    ·         Verify that all the contacts of the group you want to use are now listed in the “To” field of the email.
      
  11. Enter a subject and your message. Do so in the "Subject" text field and the blank text field below it, respectively.                                                      
 

Wednesday, November 27, 2019

How do I edit the "build.prop" file in Android without Rooting it?


The following method requires you to have a custom recovery like TWRP or CWM. You can either install the custom recovery or even choose to simply boot through it for this process. This is because you have full access to system files in recovery mode. Also, this is only possible if the system partition is mounted, something which stock recoveries don’t allow. To begin with, download and install ADB and Fastboot drivers onto your system.
·         Install an advanced text editor like Notepad++ or Sublime Text on your system. This is will be used later on to edit the build.prop file.
·         Next up, switch off your device and head over to the recovery mode. Once there, tap on “Mount”. A list of all the partitions on your device will open up. Make sure the checkbox next to ‘System’ is checked, and the checkbox next to “Mount system partition read-only” is unchecked.
·         Once you’ve mounted the /system partition, connect your device to your PC and open the ADB window. Once there, type in the following command to transfer the build.prop file onto your system:
1.  adb pull /system/build.prop <path to save file>
For example, I wish to transfer the file to C:\Beebom on my system, hence the command that I’ll be inputting will be:
1.  adb pull /system/build.prop  C:\Beebom
As you can see below, the build.prop file will now be transferred to the specified path, in my case, C:\Beebom.
·         Now that your build.prop file has been transferred to your system, you can edit it easily using the text editor you downloaded previously. To do so, simply right-click on the build.prop file and select “Edit with Notepad++” or any other text editor that you may have downloaded.
·         A new Notepad++ window should now open and you should easily be able to modify the build.prop file. Once you’re done with your edits, simply save the changes.
·         Now that you’ve edited the build.prop file, we need to transfer it back to your device. To do so, run the following command in the ADB window:
1.  adb push <path to your file> /system/build.prop
So, since my file is located at C:\Beebom\, the command that I’ll be inputting will be:
1.  adb push C:\Beebom\build.prop  /system/build.prop
·         Now that you’ve transferred the modified build.prop file, you need to set its permissions as well. To do so, open up the ADB shell by typing in the following command:
1.  adb shell
·         Once you’re inside the ADB shell mode, type in the following command to set the right permissions:
1.  chmod 644 /system/build.prop
And that’s it. You can now close the ADB window. Your build.prop file has now been modified as per your preferences.

Monday, March 25, 2019

Outlook: “Can’t Create File” Error When Opening Excel File Attachment

1.  Create a new folder in C:/ Drive with name "temp0"  path should be C:\temp0

2.    Hold the Windows Key, then press “R” to bring up the Run dialog box.


3.    Type “Regedit“, then press “Enter“.

4.   Go to the following location:-  "HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Outlook\Security\" entry. Double-click "OutlookSecureTempFolder" and change the "Value Data" field to the location of the folder you created, e.g. "C:\temp0"