documentation Archives

Tech Optimizer

March 3, 2026

Snowflake Postgres: Unify Postgres and Analytics on One Platform

Snowflake Postgres is now generally available on AWS and Azure in all major regions, enabling users to initiate a database in minutes. It integrates transactional and analytical data, accelerating innovation by eliminating complex data pipelines, thus saving time and minimizing risks. Comprehensive resources, including technical documentation, a getting started guide, and a demo overview video, are available for users.

Winsage

March 1, 2026

Windows Package Manager 1.28.190 is final

Microsoft has launched WinGet 1.28.190, aligning its version number with App Installer to resolve discrepancies. The previous version 1.12.470 has been replaced by this update. Key changes include consistent directory separators for portable packages, compatibility of the –suppress-initial-details option with winget configure test, corrections to the experimental “font” property, and the introduction of the experimental sourceEdit feature, which allows users to set a source for package management. The update signifies a consolidation of versioning and enhances clarity for users and administrators.

Winsage

February 27, 2026

Is Microsoft really spying on you with Windows telemetry?

Windows 10 was released in 2015 and faced criticism for its telemetry feature, which some viewed as a surveillance tool. In 2017, the Dutch Data Protection Authority found Microsoft's telemetry settings non-compliant with local privacy laws, leading to changes by Microsoft. Telemetry, termed diagnostic data by Microsoft, is essential for device reliability and security, with a baseline level of data collection set to "Required." Users can opt to limit data collection to this level. The Optional category of diagnostic data may include device settings and browsing history, raising privacy concerns. Microsoft introduced the Diagnostic Data Viewer in 2018 to enhance transparency, allowing users to inspect the telemetry data sent to them. As of now, Microsoft has over a billion monthly active Windows 11 users.

Tech Optimizer

February 27, 2026

Replicate spatial data using AWS DMS and Amazon RDS for PostgreSQL

The process of migrating spatial data from self-managed PostgreSQL, Amazon RDS for PostgreSQL, or Amazon Aurora PostgreSQL-Compatible Edition to Amazon RDS for PostgreSQL or Amazon Aurora PostgreSQL-Compatible Edition using AWS Database Migration Service (AWS DMS) is outlined. Spatial data includes points, lines, polygons, and collections of these features, which are essential for applications like mapping and asset tracking. AWS DMS treats spatial columns as large objects (LOBs) and requires proper configuration for LOB handling and PostGIS support to avoid migration failures. PostGIS is an extension for PostgreSQL that manages geospatial data types and functions, enabling operations such as radius searches and distance calculations. Amazon RDS for PostgreSQL fully integrates with PostGIS, making it suitable for geospatial applications. The migration solution involves ensuring compatibility of PostGIS versions between source and target databases, configuring AWS DMS, and validating the migration. Prerequisites include having an AWS account, RDS instances for source and target, a DMS replication instance, and the PostGIS extension installed on both databases. Tables must have primary or unique key constraints, and geometry columns must be nullable for LOB handling. Best practices for configuring PostGIS include validating version compatibility, monitoring resource usage, and establishing backup strategies. Implementation steps involve creating a spatial table in the source database, preparing the target database, configuring the AWS DMS task with specific settings, and monitoring the migration process through CloudWatch logs. Common errors during replication may relate to LOB handling or PostGIS data types. Post-migration validation includes comparing row counts, verifying geometry data types, and ensuring the functionality of PostGIS spatial functions. Finally, it is recommended to clean up all resources post-migration to avoid ongoing charges.

Winsage

February 26, 2026

Windows Update KB5077241 February 2026 Issues Nvidia GPU Bugs Task Manager Errors and ViVeTool Guide

Windows Update KB5077241, released in February 2026, is a 4.5GB feature update for the 24H2 and 25H2 versions. It poses significant performance risks for older hardware, particularly laptops and desktops without a Neural Processing Unit (NPU). Users with outdated Nvidia graphics cards, specifically the 900 Series (Maxwell) and 1000 Series (Pascal), report issues such as game stuttering, screen flickering, and system boot failures. The update also contains a flaw that inaccurately displays CPU usage in Task Manager, showing 0% utilization even under load. Many users face installation issues, encountering Error 0x800F0983, requiring them to delete update cache files and run repair tools. The update introduces features like a Taskbar Speed Test, Sysmon Security, improved Sleep/Wake functionality, and WebP wallpaper support, but many remain locked. Users can enable these features using ViVeTool with specific commands. Overall, the update is advised against for those with older Nvidia GPUs due to potential conflicts and performance issues.

Winsage

February 24, 2026

Microsoft extends security patching for three Windows products at a price

Support for Windows 10 Enterprise LTSB 2016 and Windows 10 IoT Enterprise 2016 LTSB will end on October 13, 2026, while Windows Server 2016 will reach its end of support on January 12, 2027. Organizations using these products will receive one final monthly security update on the specified dates, after which they will not receive security patches, updates, or technical support. The Extended Security Updates (ESU) program allows organizations to purchase coverage for up to three years beyond the end of support, with pricing starting at a specified amount per device for the first year and doubling for each subsequent year. Windows Server 2016's ESU pricing has not been announced, and Microsoft recommends upgrading to newer Long-Term Servicing Channel releases. In the European Economic Area, Windows 10 users can access ESU until October 14, 2026, without payment or cloud account requirements due to advocacy from Euroconsumers.

TrendTechie

February 24, 2026

От ffmpeg до торрентов для терминала: 7 новых TUI-инструментов, которые советуем

Many developers are turning to TUI (Text User Interface) tools for tasks traditionally done in GUI applications. MONICA is an interactive layer over ffmpeg that simplifies command usage, available on GitHub. The lic tool allows users to create a LICENSE file with a single terminal command by selecting a license from a TUI menu. It can be installed via Homebrew or pip and debuted in late December 2024, receiving 21 stars. PNANA is a TUI editor that combines the simplicity of nano with features from modern editors like Sublime, built with C++17 and FTXUI. Users need to compile it from source as no binary releases are available. CodeWeaver compiles a codebase into a single Markdown document, allowing for easy sharing and documentation. It can be installed via Go. Clox (version 1.3) introduces console clocks and calendars in the terminal, supporting various time zones and formats, and can be installed as a Python module. Torrra v2 is a TUI torrent client that allows users to search and download torrents directly from the console, enhancing UI speed and navigation. It can be installed via pipx or other package managers. A command for visualizing git history in the terminal is provided: `git log --graph --decorate --all --pretty=format:'%C(auto)%h%d %C(#888888)(%an; %ar)%Creset %s'`. An alias can be created for convenience. All tools aim to enhance productivity in the terminal and are actively evolving.

Winsage

February 24, 2026

Windows 11 27H2: Microsoft splits the Canary channel – Is the big overhaul finally coming?

The software department in Redmond is preparing for a significant update named 27H2, set for 2027, aimed at addressing legacy issues from older Windows versions. The Windows Insider Program is currently testing the 28000 series, with a notable shift to the 29500 build series indicating a "platform lift" that includes enhancements to the kernel and hardware abstraction layer (HAL). Microsoft plans to phase out VBScript and WordPad, eliminate support for outdated printer driver architectures and certain legacy file systems, and adopt a "core OS" approach to optimize performance for AI technologies. This update is seen as a strategic retreat from the idea of "Windows 12," focusing on stability and a comprehensive overhaul of the underlying architecture while avoiding market fragmentation. However, there are concerns that substantial changes could render older hardware or specialized software obsolete.

Winsage

February 24, 2026

Support for Windows Server 2016 is coming to an end

Microsoft has announced the end of support for several Windows products launched in 2016, including Windows Server 2016, Windows 10 Enterprise 2016 LTSB, and Windows IoT Enterprise LTSB 2016. Windows Server 2016 has been in the extended support phase since January 2022, with security updates available until January 12, 2027. Windows 10 Enterprise 2016 LTSB and Windows IoT Enterprise LTSB 2016 will reach the end of their extended support on October 13, 2026. Microsoft offers the Extended Security Updates (ESU) program for these products, allowing critical security updates for a fee, with costs for Windows 10 Enterprise 2016 LTSB set to increase annually per device. ESU will also be available for Windows Server 2016, but pricing details are not yet released. Windows IoT Enterprise LTSB 2016 will receive extended support through hardware manufacturers, with terms and costs varying by supplier. Microsoft emphasizes that using unsupported software increases risks and that migrating to a newer version of Windows is the only long-term solution.

AppWizard

February 23, 2026

Ijazzghost’s Minecraft Mods: Dive In!

ijazzghost creates transformative Minecraft mods that enhance gameplay through visual upgrades and innovative features. Their mods introduce new items, blocks, mobs, and mechanics, appealing to various playstyles such as building, exploring, and survival. The mods include enhancements like improved textures, lighting effects, and gameplay tweaks that streamline inventory management and adjust game balance. They also add new content, including unique biomes, crafting systems, and quests. Installation is straightforward, with comprehensive documentation available. Mods can be found on the official ijazzghost website and reputable mod repositories, and require a mod loader like Forge or Fabric for installation.