monitoring Archives

Tech Optimizer

February 21, 2025

Multi-tenant vector search with Amazon Aurora PostgreSQL and Amazon Bedrock Knowledge Bases

The article discusses the implementation of a multi-tenant vector store using Amazon Aurora PostgreSQL-Compatible Edition and Amazon Bedrock Knowledge Bases. It outlines a scenario where users request home surveys, and surveyors update findings stored in an Amazon S3 bucket. The process involves converting documents into vector embeddings for enhanced natural language queries through the Retrieval Augmented Generation (RAG) technique. Key steps include: 1. Ingesting data from S3 into Amazon Bedrock Knowledge Bases. 2. Using an embeddings model to convert documents into vector embeddings. 3. Storing vector embeddings, data chunks, and metadata in Aurora with pgvector. 4. Submitting natural language queries that are transformed into embeddings for retrieval from the vector store. 5. Forwarding relevant documents to a large language model for response generation. To set up the vector store, prerequisites include access to an Amazon Aurora PostgreSQL-compatible database, Amazon S3 for document storage, and Amazon Bedrock for managing knowledge bases. The article provides SQL commands for creating the necessary schema, vector table, and index in Aurora, as well as instructions for ingesting data and ensuring multi-tenant data isolation through metadata filtering. Best practices for deploying a multi-tenant vector store include optimizing chunk size, evaluating embedding models, and monitoring query performance. The article emphasizes the benefits of fully managed solutions to reduce operational complexity.

Tech Optimizer

February 21, 2025

PostgreSQL 18: Part 2 or CommitFest 2024-09

September's CommitFest for version 18 has seen a wealth of accepted patches and new features, including: - Conflict detection and logging in logical replication - Removal of the constant 10000000000 in the planner to improve sequential scan cost assessment - Enhanced memory management and usage monitoring for temporary tuple storage - Asynchronous operations support in pg_upgrade for multiple databases - Speed improvements for Hash Joins - Faster text value processing in JSON - Optimized numeric-type multiplication and division - Introduction of ANALYZE ONLY and VACUUM ONLY commands - Improved checkpointer statistics - Normalization of SET commands in pg_stat_statements - Reporting of remote connection status in postgres_fdw_get_connections - Ignoring format conversion errors in file_fdw - New function has_largeobject_privilege - Functions crc32 and crc32c added - Client-server protocol updates to report search_path changes - Support for named prepared statements in psql - Integrity verification for tar backups in pg_verifybackup

AppWizard

February 20, 2025

Your Android phone could have stalkerware. Here’s how to remove it

Consumer-grade spyware applications, often referred to as "stalkerware" or "spouseware," pose significant risks to Android users by monitoring private messages, photos, phone calls, and real-time locations without consent. These apps are typically downloaded from outside the Google Play Store and can be stealthily installed, often disappearing from the home screen. Stalkerware exploits legitimate Android features, leading to unusual phone behavior such as excessive heat, sluggish performance, or unexpected data usage. To address spyware, users should establish a safety plan and trusted support before attempting removal, as this could alert the installer. Google Play Protect should be enabled to scan for harmful apps. Users should check for unfamiliar apps in accessibility services, review notification access for third-party applications, and inspect device admin app settings for unrecognized applications. Even hidden stalkerware apps will appear in the list of installed applications, which can be accessed through the settings menu. Strengthening device security, such as enhancing lock screen passwords and using two-factor authentication, is recommended. Resources for support include the National Domestic Violence Hotline and the Coalition Against Stalkerware.

Winsage

February 20, 2025

5 most useful SysInternals tools for optimizing your Windows PC

SysInternals is a suite of 74 utilities from Microsoft designed to enhance the performance and reliability of Windows PCs. Users can download the entire suite or select individual tools from the Microsoft SysInternals Learn page. 1. AutoRuns: Identifies unnecessary background processes and obsolete registry entries, providing detailed information about each entry. It allows users to review installed drivers and spot potentially harmful entries. Launched via Start menu or by typing Autoruns.exe in the Run dialog. 2. TCPView: Monitors all TCP and UDP connections in real-time, categorizing them by version and displaying ports and connection timestamps. It helps identify bandwidth-hogging processes. Launched via Start menu or by typing tcpview.exe in the Run dialog. 3. RamMap: Provides an in-depth analysis of memory consumption across processes, helping identify memory-hogging applications and diagnose memory leaks. It offers options to clear memory, including emptying working sets, standby lists, and modified lists. Launched via Start menu or by typing rammap.exe in the Run dialog. 4. DiskView: Offers detailed insights into hard drive usage with a color-coded map of disk sectors, helping users identify fragmentation and unused space. Launched via Start menu or by typing diskview.exe in the Run dialog. 5. CacheSet: Optimizes the Windows file system cache by allowing users to adjust cached data management settings and clear the cache with a single click. Launched by typing cacheset.exe in the Run dialog. The SysInternals Suite is cost-free, effective, and compatible with Windows Recovery mode, making it a practical choice for users looking to enhance their PC's performance.

Winsage

February 19, 2025

The Windows 11 Release Preview channel update finally makes the battery indicator useful

Microsoft has introduced an enhanced battery indicator in the Windows 11 Release Preview build version 26100.3321. The new feature includes a color-coded system for battery status: a green icon indicates charging, a yellow icon signals energy-saving mode (activated at 20% battery or less), and a red icon alerts users to low battery levels. Users can also display the battery percentage in the system tray by enabling the “Battery Percentage” option in Settings > Power & battery. The update is being rolled out gradually, so not all users will see it immediately. Other features included in the rollout are file sharing via the taskbar and improvements to Windows Spotlight. Resources are available for users interested in the Windows Insider Program.

AppWizard

February 19, 2025

Warning over privacy of encrypted messages as Russia targets Signal…

Russia-backed hacking groups have advanced their techniques to infiltrate encrypted messaging platforms like Signal, WhatsApp, and Telegram, posing a threat to journalists, politicians, and activists. These hackers are targeting Signal's "linked devices" feature using malicious QR codes to gain real-time access to victims' messages. Incidents have included compromised Signal accounts leading to military strikes. The Sandworm group has been linked to compromising Signal accounts on devices captured in Ukraine, utilizing a Russian-language website to provide instructions for linking accounts to their infrastructure. Successful breaches often go undetected for long periods, with attackers using modified Signal group invite pages and phishing kits. Additionally, threat actors have stolen Signal database files from Android and Windows devices, with malware like Infamous Chisel extracting sensitive data. Attacks on Signal and other messaging services are increasing, with Russia-aligned groups employing social engineering tactics against users of WhatsApp. In response, Signal has enhanced security measures, including a new interface to alert users of unauthorized device links and additional authentication steps.

Tech Optimizer

February 19, 2025

Norton 360 Deluxe: the multi-layered digital shield and VPN for your devices

In the first half of 2024, Canada reported 41,000 cyber incidents, emphasizing the need for enhanced online security. Norton 360 Deluxe offers a comprehensive security solution that includes features such as dark web monitoring, a built-in VPN, parental controls, and 50GB of cloud storage. A 15-month subscription is currently available at a reduced price, allowing protection for up to five devices against various cyber threats.

Tech Optimizer

February 19, 2025

Amazon’s Best Tax and Security Duo, TurboTax Deluxe and McAfee Bundle Is 63% Off

Amazon is offering a bundle that includes Intuit TurboTax 2024 Deluxe Federal + State and a 15-month subscription to McAfee Total Protection for three devices at a 63% discount. The bundle costs .99, providing savings of off the regular price. TurboTax 2024 Deluxe allows for five federal e-files and one state return, guiding users through over 375 deductions and credits, and includes an Audit Risk Meter. It can import prior year data and essential forms. McAfee Total Protection 2025 features antivirus protection, secure VPN, password manager, and identity monitoring. Both applications are compatible with PC and Mac, with TurboTax requiring MacOS 13 or later.

Tech Optimizer

February 19, 2025

Protect up to 10 devices from online threats with Norton 360 Premium

Norton 360 Premium is a comprehensive security solution that offers antivirus and antimalware protection, an integrated virtual private network (VPN), parental controls, dark web monitoring, and 75GB of secure cloud storage. It supports up to 10 devices and is compatible with macOS, iOS, Windows, and Android. A 15-month subscription is available for .99.

Winsage

February 19, 2025

Snake Keylogger Variant Hits Windows, Steals Data via Telegram Bots

Cybersecurity experts at FortiGuard Labs have identified a new variant of the Snake Keylogger, known as AutoIt/Injector.GTY!tr, which targets Windows users and has blocked over 280 million infection attempts worldwide, particularly in China, Turkey, Indonesia, Taiwan, and Spain. The malware spreads primarily through phishing emails with malicious attachments or links and focuses on popular web browsers to steal sensitive information by logging keystrokes, capturing credentials, and monitoring clipboard activity. It exfiltrates data to its command-and-control server via email and Telegram bots. The malware uses AutoIt scripting to create standalone executables that evade antivirus detection. It installs itself by dropping "ageless.exe" in the %Local_AppData%supergroup folder and "ageless.vbs" in the %Startup% folder to ensure persistence. The malware employs process hollowing to inject its payload into a legitimate .NET process, allowing it to hide from detection. Additionally, the Snake Keylogger can retrieve the victim’s geolocation and extract sensitive information from browser autofill systems, including credit card details. It utilizes various techniques for data collection, credential access, defense evasion, and exfiltration, posing a significant threat to Windows users.