clients Archives

Tech Optimizer

July 9, 2025

Query Amazon Aurora PostgreSQL using Amazon Bedrock Knowledge Bases structured data

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

Businesses warned about looming software deadline that could risk cyber attacks

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.

Winsage

July 9, 2025

Microsoft Patch Tuesday, July 2025 Edition

Microsoft has released updates addressing 137 vulnerabilities across its Windows operating systems and supported software, with 14 classified as "critical." CVE-2025-49719 is a publicly disclosed information disclosure flaw affecting all SQL Server versions since 2016, posing a supply-chain risk due to its potential exploitation without authentication. SQL Server 2012 has reached its end of life, meaning no future security patches will be available. CVE-2025-47981 is a critical remote code execution vulnerability with a CVSS score of 9.8, affecting Windows clients and Windows Server. Microsoft also addressed four critical remote code execution vulnerabilities in its Office suite, including CVE-2025-49695 and CVE-2025-49696, which can be triggered through the Preview Pane. Other high-severity vulnerabilities include CVE-2025-49740, which could bypass Microsoft Defender SmartScreen, and CVE-2025-47178, allowing attackers to execute arbitrary SQL queries with minimal privileges. Adobe has also released security updates for various software, and users are advised to back up data before installing patches.

Tech Optimizer

July 8, 2025

How TimescaleDB helped us scale analytics and reporting

At Cloudflare, PostgreSQL and ClickHouse are used as primary databases for transactional and analytical workloads. PostgreSQL is preferred for product development due to its speed, versatility, and reliability, with hundreds of instances running in various configurations. ClickHouse, introduced in 2017, allows ingestion of tens of millions of rows per second with millisecond-level query performance but comes with trade-offs. The Digital Experience Monitoring (DEX) product was developed with a focus on simplicity and rapid shipping, utilizing a team of three engineers and collaboration with other teams. DEX's initial launch included fleet status logs uploaded every two minutes and synthetic tests with usage caps, leading to a successful MVP launch ahead of schedule. The architecture included an HTTP API, PostgreSQL for storing configurations, and a React UI in the Cloudflare Dashboard. PostgreSQL was chosen for analytics due to its ability to handle structured logs, with a table created for device state logs lacking a primary key but optimized with unique and standard indexes for common queries. The UPSERT query was used for data insertion, and the order of columns in multicolumn indexes was optimized for performance. After launching DEX, the system scaled to 1,000 inserts per second, leading to performance degradation. Precomputed aggregates were implemented to improve query performance, resulting in up to a 1000x improvement. Table partitioning was considered but ultimately not pursued due to its manual management requirements. TimescaleDB was explored as an alternative to enhance query performance, offering features like automatic partition management, continuous aggregates, and compression. A side-by-side comparison with PostgreSQL showed significant performance improvements, particularly for longer time windows. TimescaleDB's integration allowed for efficient data retention and aggregation, simplifying the infrastructure. Following the success of DEX, other teams at Cloudflare began using TimescaleDB for analytics and reporting, consolidating data from various sources and managing high ingestion rates effectively by optimizing data handling techniques such as switching to COPY for bulk inserts and adjusting replication settings.

Winsage

July 8, 2025

Windows 11 Hits 50 Percent Market Share … Almost Four Years After It’s Release

Windows 11 has achieved a market share of 50.24%, while Windows 10's market share has declined to 46.84%. The end-of-life date for Windows 10 is October 14, prompting many corporate clients to transition to Windows 11 or Windows 365, which offers complimentary access to extended security updates. Companies are weighing the costs of extended security updates against upgrading hardware. Retail vendors are facing challenges with an oversupply of computers, as consumers are hesitant to invest in new AI-enhanced models.

AppWizard

July 8, 2025

Pneuma founds new studio Cast Iron Games

Pneuma Games Group has established a new studio, Cast Iron Games, in Tileyard North, Wakefield, specializing in triple-A co-development and games porting. The studio is led by CEO Arden Aspinall and COO Jon Seymour, both of whom have extensive experience in the gaming industry. Cast Iron Games operates as a sister company to Double Eleven, sharing values and principles with it. Aspinall emphasizes the studio's commitment to reliability and quality in client partnerships. Seymour highlights the importance of a collaborative environment for the team, focusing on empowering them to realize clients' creative visions.

Winsage

July 7, 2025

Windows 11 usage is surging? Not so fast – here’s the real story

Numerous tech publications are reporting on a chart from Statcounter Global Stats that shows a decline in Windows 10 usage and an increase in Windows 11 usage as of June 30, 2025. Some articles claim that Windows 11 has caught up to Windows 10 in market share, but the difference is so small it may fall within statistical error. Statcounter's data reflects pageviews rather than actual market share, which can misrepresent the popularity of the operating systems. The firm, established in 1999, has seen a decline in its customer base from 3 million in 2009 to 1.5 million by 2022. Statcounter's data comes from small to medium-sized websites and does not include major sites like Google and Facebook, leading to potential inaccuracies in interpreting market share. Trends indicate a gradual decline in traffic from Windows 10 devices and a rise from Windows 11 devices, particularly as Windows 10's end-of-support date approaches, but these trends do not necessarily reflect the overall Windows PC population.

Tech Optimizer

July 7, 2025

Atlassian moved 4 million Postgres databases to AWS Aurora

Atlassian has migrated its database infrastructure to Amazon Web Services’ Aurora, transferring four million Postgres databases that support Jira implementations. The migration involved approximately 3,000 PostgreSQL servers across 13 AWS regions. The move aims to reduce costs, enhance reliability, and improve performance, upgrading the service level agreement from 99.95% uptime on RDS to 99.99% on Aurora. Samsung has postponed the completion of its chip manufacturing plant in Texas due to difficulties in securing customers. Infosys has advised its employees against exceeding nine hours and 15 minutes of work daily to combat burnout. Qantas has acknowledged a cyberattack affecting six million customers and will provide details on the incident's impact. Xerox has acquired Lexmark from Ninestar Corporation for .5 billion. India and Australia are collaborating on a research initiative to improve tracking of submarines and underwater vehicles. JPMorgan Chase has requested to terminate its custom top-level domains, ".CHASE" and ".JPMORGAN." China’s National Space Administration has released images of Earth and the Moon taken by its Tianwen 2 probe.

Tech Optimizer

July 1, 2025

Fluent Commerce’s approach to near-zero downtime Amazon Aurora PostgreSQL upgrade at 32 TB scale using snapshots and AWS DMS ongoing replication

Fluent Commerce utilizes Amazon Aurora PostgreSQL-Compatible Edition as its OLTP database engine to manage complex customer search queries. The company migrated to AWS Graviton instances to enhance performance and cost-efficiency, requiring a major version upgrade from Aurora PostgreSQL-Compatible 10.14 to 12.4 or higher. The migration involved upgrading over 350 production databases, some as large as 32 TB, using AWS Database Migration Service (AWS DMS) and various upgrade strategies to minimize downtime. The migration process included configuring replication slots, creating snapshots, and validating data between source and target databases. AWS DMS was chosen for its cost-effectiveness, seamless integration with AWS services, and capabilities for ongoing data replication with minimal downtime. The cutover process involved updating application configurations, managing sequence numbers, and ensuring optimal performance through vacuuming and analyzing tables.

AppWizard

July 1, 2025

6 Android phone features that boost productivity

- Android phones, particularly the Google Pixel 6 Pro running on Android 15, offer features that enhance productivity and work-life balance. - The camera can be accessed quickly by double-pressing the power button, and photos can be taken using the Volume Down button. - Bedtime Mode silences the phone, dims the wallpaper, and allows only alarms and essential calls, which can be set up in Settings > Digital Wellbeing and Parental Controls > Bedtime Mode. - Google Messages can be connected to a web browser for easier access to texts and sending messages using a full keyboard by visiting the Google Messages page and following the QR code pairing process. - Important text messages can be pinned to the top of the message list by pressing and holding the conversation and tapping the Pin icon. - App Pin locks the phone screen to a specific app to prevent accidental navigation, which can be enabled in Settings > Security and privacy > More security & privacy > App pinning. - Do Not Disturb can be scheduled for a specific time period by swiping down from the home screen, tapping on Mode, selecting Do Not Disturb, and setting the desired duration.