data collection Archives

Tech Optimizer

May 12, 2025

Database performance analysis using pg_profile and pgpro_pwr

pgpro_pwr is a database workload monitoring tool for database administrators (DBAs) to identify resource-demanding operations. It was launched in 2017 as pg_profile by Andrey Zubkov, who moved from being a DBA to an engineer at Postgres Professional. pg_profile is compatible with open-source PostgreSQL and has been integrated into PostgreSQL 17 as of 2024, while pgpro_pwr offers advanced statistical insights and is included in Postgres Pro releases. Both tools monitor database workload metrics through continuously incrementing counters, capturing values at intervals and archiving differences. They do not provide alerting capabilities but are useful for assessing system stability, analyzing load testing outcomes, and identifying system-intensive activities. The tools consist of repository tables, data collection functions, reporting functions, and service tables. To use them, one must install the extension, configure roles, and set up parameters. Reports can be generated for workload statistics over time and comparisons between different time intervals. Examples of report types include wait event statistics and advanced vacuum statistics. Future plans include submitting a patch to introduce vacuum statistics to vanilla PostgreSQL.

Winsage

May 10, 2025

5 features I wish Microsoft would turn off by default on Windows 11

Microsoft's Windows 10 and 11 include features that some users find cumbersome, such as OneDrive, which is integrated but not preferred by all users. OneDrive automatically backs up default system folders during setup and offers only 15GB of storage without a Microsoft 365 subscription. Users can disable OneDrive through Computer Configuration settings. The Widgets feature, particularly the News widget, can interrupt workflow and can be disabled via Settings. The Start menu includes recommendations that some users view as advertisements, which can be turned off in Settings. Windows also has several applications set to run at startup by default, which can slow down boot times; users can manage these through Settings or Task Manager. Additionally, Windows collects diagnostic data, which raises privacy concerns, but users can opt out by adjusting settings in Privacy & Security.

Winsage

May 10, 2025

Microsoft’s New Windows Update — 1 Billion Users Warned: Do Not Delete

Windows users are facing security challenges, including zero-day vulnerabilities and hackers bypassing Windows Defender. Microsoft has removed VPN provisions for Windows Defender and discontinued security support for Windows 10, but users can upgrade to Windows 11 for free. Following the April 8 Patch Tuesday updates, a new folder named "inetpub" appeared on user devices, which Microsoft has warned users not to delete, as it is essential for security protections. This folder is generated after installing updates and is traditionally associated with the Internet Information Services (IIS) web server platform, regardless of whether IIS is installed. If users have deleted the inetpub folder, it can be restored by enabling IIS through the Windows Control Panel.

Tech Optimizer

May 9, 2025

Does Antivirus Software Collect Your Data

Antivirus software collects various types of data to protect systems, including system details (operating system version, RAM, CPU type, computer name), network data (local and external IP addresses, DNS server, network name), user data (Windows username, time zone, language, general location), browsing history (if web protection features are enabled), and file-related information (file names, locations, hashes, and sometimes entire files). The AV-Comparatives report indicates that while some antivirus companies manage data responsibly (e.g., F-Secure, G Data, K7), others (e.g., Norton, Panda, McAfee) have been criticized for poor practices. Data sharing can enhance malware detection but poses privacy risks, as seen in AVG's past actions of selling user browsing history. Users can limit data collection by adjusting settings, reviewing installation agreements, avoiding free antivirus software, choosing privacy-conscious vendors (like F-Secure, ESET, G Data), and reading privacy policies. Despite concerns about data collection, antivirus software is essential for protection against cyber threats, and selecting a transparent provider can help safeguard privacy.

Winsage

May 8, 2025

Can’t upgrade to Windows 11? This Linux project wants to save your old PC from the scrapheap when Windows 10 support ends

As Windows 10 approaches its End of Life in October 2025, the ‘End of 10’ project advocates for transitioning to Linux for users with older PCs that cannot upgrade to Windows 11. The initiative emphasizes the environmental benefits of extending the lifespan of existing devices, highlighting that computer production accounts for over 75% of carbon emissions during its lifecycle. It also points out that Linux offers greater privacy and control compared to Windows 11, as well as cost efficiency since it is free and future updates remain free if the chosen distribution is supported. While there are concerns about the learning curve and potential software compatibility issues, the project encourages users to seek support from online forums or local repair shops. The Linux community is noted for its willingness to assist newcomers, making it a viable alternative for older PCs that cannot support Windows 11.

AppWizard

April 25, 2025

Data privacy firm files complaint against Ubisoft

The European Center for Digital Rights (NOYB) has accused Ubisoft of excessive data collection practices related to the game Far Cry Primal, which may violate GDPR regulations. Players reportedly connected to external servers 150 times within ten minutes of launching the game, including connections to Google, Amazon, and Datadog. Despite being a single-player game, it requires an internet connection for ownership verification. NOYB has expressed concerns about the lack of transparency regarding data transmission to external servers.

AppWizard

April 24, 2025

Trojanized Alpine Quest app geolocates Russian soldiers

Russian soldiers are facing a digital threat from a modified Android application, Alpine Quest, which has been tampered with to track their locations and extract sensitive information. The malware, known as Android.Spy.1292.origin, was embedded in an older version of the app and distributed as a free upgrade to Alpine Quest Pro via a fraudulent Telegram channel. Once installed, the trojan collects various types of information, including geolocation, downloaded files, phone numbers, and app versions, and can download additional modules to exfiltrate specific files. Additionally, researchers at Kaspersky discovered a backdoor hidden in counterfeit software updates for ViPNet, a secure networking suite. The malware, disguised as msinfo32.exe, connects to a command-and-control server to steal files and deploy more malicious components. On the Ukrainian side, Russian operatives are conducting a phishing campaign targeting Ukrainian officials and allies, using social engineering tactics to hijack Microsoft 365 accounts. Attackers contact victims via messaging apps, invite them to video calls, and trick them into providing OAuth codes, granting access to their accounts.

Winsage

April 23, 2025

When Microsoft made the Windows as a Service pivot

Former Microsoft engineer Dave Plummer discussed the company's shift from paid upgrades to a Windows as a Service model, highlighting the challenges faced after the success of Windows 7 and the disappointing reception of Windows 8. He noted that Microsoft made Windows 10 available as a free upgrade for users of Windows 7, 8, and 8.1, which allowed the company to gather valuable telemetry data while introducing users to subscription services. However, the telemetry raised privacy concerns among users, as it included advertising and upsell mechanisms. Plummer expressed a desire for a version of Windows Pro without telemetry and advertising, indicating he would pay for such a product. He also mentioned that the transition to a service model helped address piracy by offering free upgrades to users with non-genuine copies of Windows.

Winsage

April 19, 2025

Microsoft «kills a feature that protected «older» versions of Windows 11 — and no one knows why

Microsoft will discontinue support for virtualization-based security enclaves (VBS enclaves) in Windows 11 versions 23H2 and 22H2, as well as in Windows Server versions 2022, 2019, and 2016. Support for VBS enclaves will only be retained in Windows 11 version 24H2 and later, and in Windows Server 2025 and later. VBS enclaves enhance memory operation security by creating virtual trust levels within a Trusted Execution Environment. Microsoft previously addressed a privilege escalation vulnerability within VBS enclaves (CVE-2025-21370) and plans to integrate the Rust programming language into the Windows kernel starting with Windows 11 version 23H2 in 2024.

Winsage

April 16, 2025

I disabled these 5 Windows services to improve my PC performance

Windows operating systems have numerous background services that can consume system resources and slow down performance. Users can improve responsiveness by disabling non-essential services. 1. Windows Search: Indexes files and data for quick searches; can tax CPU and RAM. To disable: press Ctrl + R, type services.msc, locate Windows Search, stop the service, and set Startup type to Disabled or Manual. 2. SysMain (formerly Superfetch): Preloads frequently used applications into memory but can lead to unnecessary disk activity on SSDs. To disable: access services.msc, find SysMain, stop the service, and set Startup Type to Disabled. 3. Windows Update Delivery Optimization: Shares update files with other PCs, consuming bandwidth. To disable: go to Settings -> Windows Update -> Advanced Options and turn it off. 4. Remote Desktop Services: Enables remote connections, which can drain resources and pose security risks. To disable: locate Remote Desktop Services in services.msc, stop it, and set Startup type to Disabled. 5. Connected User Experiences and Telemetry: Collects usage data and can transmit sensitive information. To disable: turn off the service and navigate to Settings -> Privacy & Security -> Diagnostics & Feedback to disable Diagnostic data. Additional services that may be disabled include Print Spooler, Fax, Bluetooth Support, and Windows Error Reporting Service for further performance optimization.