clients

Winsage
July 23, 2025
As Windows 11 support ends, many Windows 10 PCs and laptops lacking compatibility with the new operating system are expected to enter the resale market or be given away. This situation creates opportunities to repurpose these devices for various uses, including: 1. Installing a Linux distribution to cater to business and personal needs, with options like Ubuntu, Fedora, and MX Linux for older hardware. 2. Running ChromeOS Flex for a lightweight experience focused on web browsing and cloud applications. 3. Installing a thin-client OS to access virtual desktops, maximizing existing hardware for businesses transitioning to virtual environments. 4. Converting the device into a media server using software like Plex or Jellyfin for centralized media storage and streaming. 5. Recycling the device responsibly through manufacturer or retailer e-waste programs, ensuring safe processing and potential donation of usable parts. Before recycling, it is important to securely wipe or destroy personal data on the hard drive.
Tech Optimizer
July 23, 2025
Command Prompt, Inc. has been active in database management since 1997 and specializes in PostgreSQL support. Their PgLTS (PostgreSQL Long Term Support) service extends the standard five-year PostgreSQL community support by an additional three years, providing up to eight years of comprehensive support, including CVE back patching and compliance with long-term FedRAMP requirements. The company prioritizes security, stability, clear communication, and transparent ROI for clients.
Winsage
July 21, 2025
Windows administrators need to keep their systems updated for security and performance, with control over the timing and type of updates being crucial. There are three primary methods for managing Windows updates: 1. Per-client updates: Default for standalone clients, offering minimal control. 2. Windows Server Update Services (WSUS): Centralized management since 2005, allowing extensive control but requiring more administrative effort. 3. Windows Update for Business (WUfB): A cloud-based model providing greater control through tools like Group Policy and Mobile Device Management (MDM). WUfB offers several advantages, including policy-based management, granular control over deployments, and the elimination of on-premises WSUS servers. To implement WUfB, organizations must meet specific requirements, including using Windows 10/11 Pro, Enterprise, or Team editions, Azure AD joining, and having the necessary licenses such as Microsoft 365 Business Premium. Administrators can defer feature updates for up to 365 days and quality updates for up to 30 days using Group Policy. They can create servicing rings for managing update deployments, such as testing, pilot, and rollout rings. Configuration involves creating Group Policy Objects (GPOs) linked to the appropriate Organizational Units (OUs) and setting relevant policies. WUfB reporting is available through the Azure Portal, allowing administrators to monitor update statuses and troubleshoot devices.
Tech Optimizer
July 18, 2025
pg_stat_statements is a PostgreSQL extension for monitoring query statistics, tracking execution counts, execution times, and row returns. It uses a hash table to store metrics for each query, identified by a key generated from four parameters: queryid, User OID, Database OID, and a toplevel flag. The extension can become a performance hindrance in high contention environments due to locking operations on the hash table. When numerous unique queries are executed, contention for the hash table can lead to significant performance drops. For example, with pg_stat_statements enabled, a system with 48 CPUs showed a TPS drop from 237,437 to 32,112 when executing unique queries. In contrast, with a high volume of similar queries on a 192 CPU machine, enabling pg_stat_statements resulted in a TPS of 484,338 compared to 1,015,425 with it disabled. Query sampling is introduced as a method to mitigate performance issues by recording metrics for only a fraction of executed queries. The pg_stat_statements.sample_rate parameter allows configuration of the proportion of queries tracked. However, sampling can lead to incomplete data and potential security risks if sensitive information is recorded in non-normalized form. Benchmark tests with varying sample_rate values showed that as the sample_rate decreased, TPS increased, and SpinDelay diminished. At a sample_rate of 1.0, TPS was lowest, while at 0.25 and below, SpinDelay effectively disappeared, indicating that sampling can significantly enhance performance under high contention conditions.
Tech Optimizer
July 16, 2025
Postgres, an open-source database management system, is experiencing a revival due to its compatibility with AI applications and its ability to manage structured data effectively. Despite its strengths, Postgres lacks native high-performance full-text search and analytics capabilities, leading organizations to use separate systems like Elasticsearch, which complicates data management. ParadeDB, an open-source extension developed in 2023, addresses these limitations by enabling sophisticated data search and analytics directly within Postgres, eliminating the need for data transfers. ParadeDB has gained traction, securing its first enterprise customer by early 2024 and recently completing a funding round for platform enhancements. Its integration with Postgres simplifies workflows and reduces operational overhead, making it a compelling alternative to traditional search solutions.
AppWizard
July 15, 2025
UK-based co-development firm Airship Interactive has entered administration, and its assets have been acquired by a newly established studio named Airmergent. Airmergent has retained all 78 employees from Airship Interactive, in compliance with UK TUPE regulations, ensuring ongoing contracts remain unaffected. Airship Interactive officially entered administration on July 1st.
Tech Optimizer
July 9, 2025
Amazon Bedrock Knowledge Bases has introduced a fully managed Retrieval Augmented Generation (RAG) feature that connects large language models (LLMs) with internal data sources, enhancing the relevance and accuracy of responses by integrating contextual information from private datasets. During AWS re:Invent 2024, it was announced that this feature now supports natural language querying for structured data retrieval from Amazon Redshift and Amazon SageMaker Lakehouse, allowing generative AI applications to access both structured and unstructured data sources. The system converts user queries into SQL queries using natural language processing, enabling data retrieval without requiring users to know SQL syntax. Amazon Bedrock Knowledge Bases currently supports structured data retrieval from Amazon Redshift and SageMaker Lakehouse. Although direct support for Aurora PostgreSQL-Compatible is not available, users can utilize zero-ETL integration between Aurora PostgreSQL-Compatible and Amazon Redshift to make their data accessible. This integration replicates Aurora PostgreSQL tables to Amazon Redshift in near real-time, simplifying data management. To enable natural language querying of structured application data stored in Aurora, organizations can set up an Aurora PostgreSQL database, create a schema with interconnected tables (products, customers, and orders), and populate these tables with sample data while maintaining referential integrity. Subsequently, they can establish zero-ETL integration with Amazon Redshift, which involves creating a Redshift Serverless workgroup and mapping the database for synchronization. Once the zero-ETL integration is verified, organizations can create an Amazon Bedrock knowledge base for natural language querying. This requires granting appropriate permissions to the Amazon Bedrock Knowledge Bases AWS Identity and Access Management (IAM) role and ensuring the knowledge base is synchronized with Amazon Redshift. After setting up the knowledge base, users can execute natural language queries, which are translated into SQL and processed to generate human-readable responses. Examples of queries include counting unique customers and identifying customers who have purchased the most products. Finally, it is recommended to clean up resources after use to avoid ongoing charges.
Winsage
July 9, 2025
Calne-based Black Nova Designs has warned that Microsoft will cease support for Windows 10 in three months, which will leave millions of users without security updates or technical assistance, increasing their vulnerability to cyber threats. Managing director Kyle Holmes noted the lack of awareness about this change and emphasized the risks involved. The company recommends six IT tips for businesses: 1. Upgrade from Windows 10 promptly, especially for machines older than 2018. 2. Regularly back up data and maintain robust antivirus protection, with services starting at £60+VAT per month. 3. Strengthen passwords to mitigate vulnerabilities. 4. Verify that correct Microsoft licenses are being used to avoid potential fines. 5. Ensure proper ownership and access to website domains. 6. Seek Cyber Essentials certification to demonstrate adherence to cybersecurity best practices. Black Nova Designs supports over 1,000 clients across the UK, focusing on cybersecurity and proactive IT management.
Search