Catatan

MSSQL Deadlock

 SELECT * FROM sys.dm_tran_locks; SELECT creation_time, total_rows, text FROM sys.dm_exec_query_stats qs CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) order by creation_time desc SELECT      blocking_session_id AS BlockingSession,     session_id AS BlockedSession,     wait_type, wait_time, wait_resource FROM sys.dm_exec_requests WHERE blocking_session_id <> 0;

Comparing the Evaluation Results of Processed and Reduced Datasets Using Excel

 Since your dataset was reduced from all attributes to only two (Status & Target) , you should compare the evaluation metrics (e.g., accuracy, precision, recall, F1-score) of the classification models before and after reduction. 1. Collect Evaluation Results from Weka After running classification models on both datasets ( full dataset and reduced dataset ), record the following metrics: Accuracy (%) Precision (%) Recall (%) F1-Score (%) Cross-validation (k=10, k=20) results Percentage split (70:30, 80:20) results 2. Organizing Data in Excel Step 1: Create a Table in Excel Format your results into a table: Dataset Model Accuracy (%) Precision (%) Recall (%) F1-Score (%) Full (Before Reduction) J48 85 84 83 84 Full (Before Reduction) Random Forest 88 87 86 87 Reduced (After Reduction) J48 75 74 73 74 Reduced (After Reduction) Random Forest 78 77 76 77 Step 2: Insert a Bar Chart Select the table data. Go to Insert β†’...

Brute Force Approach - Algorithm Design Technique

Imej
Sam Kas Co is a shipping company that owns six ships. In emergency cases, the company will release the coordinates of each ship to other ships. The nearest ship will be assigned to help the trouble ship. Assume now that a ship. MayDay with coordinate (10,5), is in trouble. Table below shows the current coordinates for all the other ships.   Ship Name Coordinate X Coordinate Y Air 18 11 Bay 7 1 Cell 3 7 Dream 11 4 Eve 6 6   1.       Write a pseudocode that receives the coordinate of the troubled ships and a list of other ships’ coordinates. The algorithm will return coordinate that of the nearest ship to the troubled ship.   FindNearestShip(troubleShipX, troubleShipY, ship_list)       minDistance = INFINITE   ...

Excel Text transform

Formula  =PROPER(M1032) 

How to Create a CHM or Compiled HTML Help (.CHM) File

Imej
 Ref: https://learn.microsoft.com/en-us/previous-versions/windows/desktop/htmlhelp/create-a-help-project

Discover MAC Address through NMAP & ARP

 https://chatgpt.com/share/66fb5b2f-e3b0-8001-8079-1915b31fc199 tools to detect any mac address specific for brand Advantech in the network and to set ip without access to the equipment To detect MAC addresses of specific devices like Advantech in a network and assign IP addresses without direct access to the equipment, you can utilize several tools and techniques. Here's an outline of how to achieve both tasks: 1. Detect MAC Address Specific to Advantech Devices MAC addresses typically have the first three octets (known as the Organizationally Unique Identifier, OUI) that identify the manufacturer of the device. To detect Advantech devices: Tools to Detect MAC Addresses: Nmap (Network Mapper) : Nmap is a powerful network scanning tool that can be used to detect devices on a network based on their MAC addresses. Example command to scan for Advantech devices: sudo nmap -sn 192.168.1.0/24 This command will ping all devices in the subnet and display their MAC addresses. You can look f...

Arduino compiling "Failed to execute script 'esptool' due to unhandled exception"

The error message "Failed to execute script 'esptool' due to unhandled exception" is common when trying to upload code to ESP32 or ESP8266 boards using the Arduino IDE. It typically indicates an issue with the esptool.py script or related dependencies that handle communication with the ESP board. Here are some steps to troubleshoot and resolve the issue: 1. Check Python Installation The esptool relies on Python, so make sure you have Python installed correctly. Open a terminal (or command prompt) and run: bash Copy code python --version or bash Copy code python3 --version If Python is not installed, install it from here . 2. Update ESP32/ESP8266 Board Libraries The problem may also be related to outdated board libraries. You can update them via the Arduino IDE: Open the Arduino IDE. Go to Tools > Board > Boards Manager . Search for "ESP32" or "ESP8266" and update the corresponding board package. 3. Install Required Python Libraries If the req...