Catatan

SQL Server size limit

Imej
  Truncate to reduce

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...