configuring Archives

Tech Optimizer

June 4, 2025

Migrate Google Cloud SQL for PostgreSQL to Amazon RDS and Amazon Aurora using pglogical

PostgreSQL is a popular open-source relational database used by enterprise developers and startups, enabling rapid prototyping and supporting mission-critical applications. Amazon RDS for PostgreSQL and Amazon Aurora PostgreSQL-Compatible Edition facilitate easy setup, operation, and scaling of PostgreSQL deployments in the AWS Cloud, automating administrative tasks like software installation, storage management, and backups. The pglogical extension, compatible with PostgreSQL versions 9.4 and higher, allows for asynchronous replication and is supported on RDS for PostgreSQL and Aurora PostgreSQL from version 12. It uses a publisher/subscriber model for logical streaming replication. To migrate a PostgreSQL database from Google Cloud SQL to RDS for PostgreSQL or Aurora PostgreSQL, users must configure the primary database in Cloud SQL, create a PostgreSQL user with replication privileges, enable logical replication parameters, and create the pglogical extension. The RDS instance also requires a special user for replication, enabling logical replication parameters and creating the pglogical extension. Known limitations of pglogical include the inability to replicate primary key changes directly, the need to manually transfer extensions, and the lack of support for materialized views and large objects. Workarounds involve using surrogate keys for primary keys, manually creating extensions, and converting large objects to bytea columns or storing them in Amazon S3. DDL statements are not automatically replicated, but can be queued using the pglogical.replicate_ddl_command function.

Winsage

May 31, 2025

Bring your PWA closer to users with App Actions on Windows

App Actions on Windows have expanded to include Progressive Web Apps (PWAs) starting from Edge version 137. Developers can now publish their PWAs to the Microsoft Store, allowing for enhanced user interactions. App Actions enable users to access key features of an app directly from their current context, reducing distractions from switching between applications. For example, the note-taking app Goodnotes allows users to send text directly to the app without toggling windows. Developers can integrate App Actions into their Microsoft Store PWAs by defining an Action manifest, setting up a custom protocol handler, configuring the app as a share target, and packaging the app for the Microsoft Store using PWABuilder. Optionally, developers can define a PWA launch handler and test actions using the App Actions Testing Playground.

AppWizard

May 30, 2025

Nvidia GeForce Now Steam Deck Review: The Best Way to Play AAA PC Games on Handheld

The Steam Deck is a popular handheld gaming device that, while affordable and visually impressive, faces limitations in running demanding games. Nvidia's GeForce Now has released a dedicated app for the Steam Deck, improving the gaming experience by allowing access to high-quality titles without the need for complex setup. The app enhances battery life, enabling four to five hours of gameplay compared to two hours with native 3D games. It supports resolutions up to 4K and 60 fps with an Ultimate subscription, although it is limited compared to the PC version. The Steam Deck can access games from various platforms, including Xbox, Epic Games Store, and GOG, with GeForce Now simplifying this process. The app requires a minimum internet speed of 45 Mbps for optimal performance and offers different subscription tiers, with the free version having session limits and resolution caps.

Winsage

May 29, 2025

Securing Windows Endpoints in 2025 Enterprise Environments

In 2025, 61% of organizations worldwide have adopted Zero Trust initiatives, up from 24% in 2021. Microsoft's Zero Trust framework centralizes security policy enforcement through the cloud, with integrated solutions like Microsoft Defender for Endpoint. AI is now a critical component of endpoint security, enabling systems to detect irregularities and autonomously isolate compromised devices. Microsoft introduced Quick Machine Recovery (QMR) to allow IT administrators to fix unbootable PCs remotely. Windows Server 2025 features enhanced security measures, including advanced algorithms and a customized security baseline with over 350 preconfigured settings. Additionally, 75% of organizations are consolidating security vendors, favoring comprehensive platforms like SentinelOne Singularity and Microsoft Defender XDR. Windows Defender Application Control (WDAC) has been enhanced to better regulate application usage, with Microsoft promoting its adoption over AppLocker.

Winsage

May 27, 2025

Time to upgrade to a new PC or laptop? Murcia company’s advice ahead of Windows 10 end of support

Microsoft will end support for Windows 10 on October 14, 2025, ceasing security updates and technical support, which raises concerns about vulnerabilities to cyber threats. Users are encouraged to upgrade to Windows 11, but with Windows 12 expected later this year, many may need to consider new hardware due to compatibility challenges. Fixtech, a tech repair shop in Murcia, offers services to assist users in selecting new PCs or laptops, installing Windows, setting up devices, and transferring data. They advise customers to check if their current computers qualify for an upgrade to Windows 11 before purchasing new hardware. Fixtech provides various services, including computer repairs, custom-built systems, and data recovery, and is available 24/7.

Winsage

May 21, 2025

Announcing new Microsoft Dataverse capabilities for multi-agent operations

Microsoft Dataverse is a secure and scalable platform that integrates enterprise data with agent functionalities, serving as the backbone for organizations to manage business and operational data. It powers Microsoft Copilot Studio, enabling developers to create agents that execute adaptive tasks while ensuring human oversight. Key features include AI-powered search, prompt columns for embedding generative AI, and the Dataverse Model Context Protocol (MCP) server, which transforms structured data into interactive knowledge for agents. The MCP server offers capabilities such as querying data, engaging with knowledge sources, creating/updating records, and executing custom prompts. Dataverse knowledge is integrated into Copilot Studio, connecting structured and unstructured data from various sources to create a unified knowledge network. Data in Dataverse is pre-indexed for near-real-time analytics, and integration with Microsoft Fabric allows for easy exploration of this data. Dynamics 365 data is now accessible within Microsoft 365 Copilot, streamlining workflows. New knowledge sources and connectors have been introduced, including Snowflake, SAP, and Confluence, enhancing agent capabilities. The Power Platform connector SDK simplifies the integration of external structured data into Power Apps and Dataverse. A centralized Tools hub in Copilot Studio allows for the management of reusable functionalities across agents. Additionally, three new managed agents are available in preview, designed to automate document workflows, generate executive briefs, and process inbound leads, facilitating quick implementation and scalability for organizations.

Tech Optimizer

May 20, 2025

Running I/O intensive workloads on PostgreSQL with Amazon EBS io2 Block Express

Databases are essential for organizations, and their performance is critical to user experience and operational efficiency. AWS introduced Amazon Elastic Block Store (Amazon EBS) io2 Block Express in December 2020 to address performance issues related to storage latency during database operations. This solution enhances storage management for high-performance database servers, supporting up to 256,000 IOPS and 4,000 MiB/s throughput per volume, with a maximum volume size of 64 TiB and sub-millisecond disk I/O latency. A performance comparison was conducted between PostgreSQL databases on Amazon EBS gp3 and io2 Block Express, utilizing the HammerDB benchmarking tool. The analysis involved four tests: OLTP Load test, OLTP Stress test, OLAP Load test, and OLAP Stress test, using r5b.24xlarge EC2 instances. Results indicated that io2 Block Express outperformed gp3 by 2.08 times in transactions per minute (TPM) and provided significantly lower latency for both OLTP and OLAP workloads. Key differences between gp3 and io2 Block Express include durability, with io2 offering 99.999% durability compared to gp3's 99.8% – 99.9%. The maximum IOPS for gp3 is 16,000, while io2 supports up to 64,000 IOPS. Pricing for gp3 is approximately ,375.36/month, while io2 Block Express costs around ,408/month, reflecting its premium performance capabilities. In benchmarking tests, io2 Block Express demonstrated superior performance, achieving 3.95 times faster average performance than gp3 across all scenarios. It is particularly suitable for mission-critical applications requiring consistent sub-millisecond latency and high durability.

Tech Optimizer

May 18, 2025

Do I need antivirus software for Windows 11?

Windows 11 accounts for nearly 44% of global desktop users as of April 2025, making it a prime target for cybercriminals, with 83% of malware in 2020 aimed at Windows systems. Microsoft Defender, which comes pre-installed with Windows 11, offers commendable malware protection, basic ransomware protection, a SmartScreen feature for anti-phishing, and a firewall that monitors network traffic. While it provides a solid foundation for security, additional third-party antivirus software can enhance protection, offering more comprehensive features such as superior parental controls, integrated VPN services, and identity theft protection.

Winsage

May 15, 2025

Microsoft App Assure helps Nord Security build for Windows on Arm

Developers are focusing on optimizing applications for the newly launched Copilot+ PCs, which feature advanced system architecture, all-day battery life, and the ability to run AI models directly on the device. The initial Copilot+ PCs are powered by Snapdragon X Elite and X Plus silicon, with AMD and Intel also introducing compatible processors. Microsoft’s App Assure Program provides guidance and technical support to help developers optimize applications for these devices, particularly for Arm-based Snapdragon X Series devices. NordVPN is a notable example of a company that successfully utilized the App Assure program to develop an Arm-optimized version of their application. The program includes the Arm Advisory Service, which allows developers to consult with Microsoft engineers for a smoother development process. Other companies, such as Proton VPN and F-Secure, have also benefited from the App Assure team in optimizing their applications for the Windows on Arm platform.

Winsage

May 6, 2025

I used Sophia Script to take back control of Windows 11, and I wish I did it sooner

Sophia Script is a PowerShell module available on GitHub that simplifies the process of adjusting Windows settings through the command line interface (CLI), offering over 150 regularly updated functions. It provides GUI-based options for managing tasks like telemetry settings, scheduling tasks, and uninstalling OneDrive, allowing users to select multiple tasks at once. The setup process involves opening the main PS1 file in Notepad++, changing the directory, and executing a command from GitHub, with comprehensive instructions available. Users can customize settings by adding or replacing code with a hashtag next to the script they wish to run, and it allows changes to be applied across all user accounts. Sophia Script is particularly useful for configuring new PCs or fresh installations, as it helps remove unnecessary bloatware and streamline system performance. It can uninstall Microsoft apps, including the Windows Copilot app, and has created five scheduled tasks after running, saving time compared to traditional methods. The creator, Farag2, is also developing a GUI version, SophiApp 2.0.