backups Archives

Tech Optimizer

July 24, 2026

How we pushed CDC into Postgres, and turned replication into clockwork

Making data from transactional databases accessible to analytical databases is essential in modern data architecture, but it faces challenges such as fragile tooling, high costs, and complex operations. Snowflake has developed a Postgres service that addresses these issues by reimagining Postgres replication. Postgres is a strong operational database, but its change data capture (CDC) capabilities need improvement. Many data pipelines are fragile due to complexities in managing continuous data flow, schema changes, snapshots, and failures. To enhance user experience with Snowflake Postgres, a complete reinvention of the replication process was necessary. A new feature called data mirroring is in public preview, allowing resilient data replication into Snowflake with low cost, minimal lag, and transactional consistency. This feature directly pushes changes from Postgres into Apache Iceberg™ tables in transactional batches, which are then automatically applied to Snowflake tables without extra infrastructure. Change data capture records changes from a transactional database for replay on another system, primarily using logical decoding in Postgres. This method decodes WAL records into logical operations, but the client bears the responsibility for subsequent steps like backfilling, managing schema changes, and handling failures. Built-in logical replication in Postgres only addresses some complexities. A limitation of logical decoding is that the external system does not recognize the state of Postgres, making it difficult to detect schema changes or correlate snapshots with changes. The solution is to push changes from Postgres into a data lake, specifically into Iceberg tables using compressed Parquet format, with object stores like Amazon S3 as the destination. The mirroring process uses a new Postgres extension called snowflake_cdc, which continuously pushes batches of changes into per-table change logs and a meta log. This extension understands the Postgres environment, coordinating schema changes and complex transactions while ensuring alignment between snapshots and changes.

Winsage

July 23, 2026

Windows 11 – The system restore that also includes your files

Since June 23, Microsoft has been implementing a point-in-time restore feature on Windows 11, which is enabled by default for Home and Pro editions when the system drive exceeds 200 GB. This feature captures a complete snapshot of the machine approximately every 24 hours using the Volume Shadow Copy service, including system, applications, settings, and local files. Users can revert to a previous state in case of issues, but restoring from a snapshot older than 48 hours will erase all changes made since then, except for OneDrive data. The feature retains snapshots for up to 72 hours and reserves 2% of drive space, capped at 50 GB. If free space drops below 20 GB, older snapshots are deleted. Restoration occurs locally through WinRE, and users need a BitLocker recovery key if the drive is encrypted. After a restore, the feature pauses and requires user consent to resume. Snapshots from upgraded editions are not accessible, and only the Enterprise edition allows adjustments to snapshot settings. The feature can be disabled in system settings. It is not a backup solution, and users are advised to maintain separate backups for important files.

Winsage

July 23, 2026

3 Windows settings that can make or break your PC

Windows 11 includes various settings that can significantly affect computer productivity and performance. 1. Windows Power Mode: This feature allows users to select performance settings under Settings > System > Power & battery. Options include “Best Power Efficiency,” “Best Performance,” and “Balanced.” For an Intel Core 300 laptop, power consumption varies as follows: - Performance mode: 30W sustained, 60W boost - Balanced mode: 25W sustained, 60W boost - Efficiency mode: 15W sustained, 20W boost Switching from “Balanced” to “Performance” mode can increase performance by 5%, while “Efficiency” mode can save up to 50% battery life with an 18% performance drop. 2. Storage Sense: Found under Settings > System > Storage, this feature automatically cleans up unnecessary files to maintain optimal SSD performance. It activates when free disk space falls below a certain threshold and can be manually triggered. Users can configure it to manage the Downloads folder and convert locally stored files backed up to OneDrive into cloud-only files. 3. OneDrive and Windows Backup: OneDrive syncs files between the cloud and PC, which can slow down performance, especially on asymmetric broadband connections. Users can adjust backup preferences through the OneDrive icon in the Action Center, but Windows may not always respect these settings, potentially leading to unwanted file re-downloads.

Winsage

July 21, 2026

Persistent Telemetry: Permanent Microsoft Windows Identifier

Discussions about consumer privacy in the Windows ecosystem have focused on optional diagnostic settings and telemetry controls. Recently, the Global Device Identifier (GDID), a permanent device-level token embedded in the Windows operating system, was revealed in a U.S. Department of Justice complaint related to a cybercriminal investigation. The GDID uniquely identifies a Windows installation and is used by Microsoft services. It is generated when a device is linked to a Microsoft account and resides in the Windows registry, being included in data sent to remote servers. There is no option to disable or delete the GDID, and attempts to do so can disrupt essential features. This has led privacy-conscious users to consider alternatives like Linux, which offers more control over data and does not require persistent identifiers. For Windows users, strategies to minimize data linked to the GDID include using local accounts, disabling optional diagnostics, and reviewing cloud app sync settings. Privacy advocates are calling for better user controls and opt-out mechanisms for hardware tracking tokens.

Winsage

July 20, 2026

Enable BitLocker on Windows 11: 11 Steps, 45 Min [2026]

A stolen laptop can lead to a significant data breach, particularly when taken from public places. Windows 11 has introduced BitLocker, a full-disk encryption feature that became mandatory for Australian businesses in 2026. The Office of the Australian Information Commissioner reported 766 notifiable data breaches in the latter half of 2024, with unauthorized access to devices being a major cause. Full-disk encryption is crucial for compliance with the Essential Eight framework, which mandates data protection on portable devices. BitLocker ensures that data on an encrypted drive becomes unreadable if the drive is removed and connected to another computer. It aligns with the Essential Eight framework, requiring evidence of encryption rather than just claims of protection. There are three types of encryption on Windows 11: Device Encryption, BitLocker Drive Encryption, and File-Level Encryption. BitLocker is available only on Windows 11 Pro and higher editions. To use BitLocker, certain prerequisites must be met, including having Windows 11 Pro or higher, a Trusted Platform Module (TPM) 2.0, UEFI firmware with Secure Boot enabled, and local administrator rights. The process to enable BitLocker involves confirming the edition, checking TPM status, enabling BitLocker through Windows Settings or PowerShell, and backing up the recovery key. Organizations can deploy BitLocker fleet-wide using Microsoft Intune, and additional security measures like TPM+PIN can be implemented for pre-boot authentication. Common pitfalls during BitLocker rollout include skipping recovery key backup and assuming that Home edition machines are covered. Troubleshooting common BitLocker issues involves identifying symptoms and applying appropriate fixes. Advanced tips for enhancing security include suspending BitLocker before maintenance and auditing compliance at the fleet level. BitLocker is integral to protecting data on portable devices, and compliance documentation is essential for proving that every device has an active recovery key.

Winsage

July 17, 2026

July’s Patch Tuesday sees an end-of-support collision amidst a massive, record-setting patch wave

The Print Spooler flag monitors shared printers and reflects the queue status of print jobs. The win32k flags manage aspects of 32-bit application printing, including font rendering and window management, while GDI+ flags handle metafiles. Printer sharing from a print server allows clients to print in various sizes and formats, cancel jobs, and verify queue status. Printing from 32-bit applications accommodates diverse document types and ensures consistency across different outputs. Document exports maintain font and layout integrity, and EMF+ files can apply effects to large images. Storage and file systems focus on maintaining integrity through NTFS high-risk flags and File History, with a Windows Server 2025 bundle addressing boot processes and BitLocker. NTFS extended attributes are utilized for backup workflows, and unexpected shutdown simulations ensure volume recovery. File History allows for file backups with customizable options. On Server 2025, Secure Boot/BitLocker combinations can be initiated. The HID input flags manage various input devices, while the WinSock bundle includes drivers for Bluetooth and multicast. The NetAdapterCx driver requires extensive enable-disable cycles under Driver Verifier.

AppWizard

July 16, 2026

DIY Steam Cartridges Bring Physical Game Media Back To PC With SSDs

A Reddit user developed a game cartridge system for Steam using individual SATA 2.5-inch 128GB SSD drives, allowing for tangible management of game libraries. This system, created by u/Jibril-sama, directs Steam to the corresponding game page upon SSD insertion and operates on a Linux base, with Windows compatibility lacking auto-navigation. Another user, u/halcyonforeveragain, showcased repurposed SD cards for use with the Steam Deck, enhancing game transfer capabilities. However, modern titles may require SSD performance for optimal gameplay, as traditional hard drives and standard SD cards may not meet the necessary speed. The cost for a 128GB SD card and USB4 card reader is about USD, while a 128GB SATA SSD with a docking station costs approximately USD. Customizing cartridges with art or labels is also suggested for a personalized gaming library.

Winsage

July 16, 2026

Windows 11 has more recovery options than ever, and here’s exactly when I would use each one to fix a broken PC

Microsoft has enhanced Windows 11 with various recovery tools that allow users to address system issues without needing to perform a complete reinstall. Key features include: - Reset This PC: Offers two options: "Keep my files" (reinstalls Windows while retaining personal files) and "Remove everything" (wipes the computer before reinstalling). Users can choose between a Local reinstall or Cloud download. - Cloud Rebuild: Accessible via the Windows Recovery Environment (WinRE), it reformats the OS partition, downloads a fresh Windows image, and restores the original setup without relying on local recovery images. - Go Back (Rollback): Allows users to revert to a previous installation after an upgrade if issues arise, utilizing the Windows.old folder, but is time-sensitive (files purged after about ten days). - Uninstall Updates: Enables users to remove recent updates that may cause problems without a full system reset. - System Restore: Creates restore points to revert to a stable state without affecting personal files. - Startup Repair: A tool in WinRE that scans for and fixes common startup issues. - Safe Mode: Starts Windows with essential drivers and services to troubleshoot problems. - Quick Machine Recovery: Automatically connects to Microsoft's recovery service to download fixes if Windows fails to start due to a faulty update or driver. - Point-in-Time Restore: Automatically reverts the system to a previous working state when updates fail. Other tools include the Windows Recovery Environment (WinRE), Recovery Drive for bootable USB access, Command Prompt, Startup Settings, and the Windows Backup app for restoring settings and files. The legacy Backup and Restore (Windows 7) tool is still available for creating backups and full system images.

Winsage

July 15, 2026

Windows 11 finally gets an undo button for your entire PC

Microsoft unveiled its July 2026 Patch Tuesday update, identified as KB5101650, for Windows 11 versions 25H2 and 24H2. The update introduces the Point-in-Time Restore (PITR) feature, allowing users to take full backups and create snapshots every 4 to 24 hours, with snapshots retained for a maximum of 72 hours. PITR can restore local files and applications. Users can now pause Windows updates for up to 35 days. Other enhancements include discreet widget operation, optimized taskbar notifications, faster File Explorer startup, quicker disk image mounting, improved Bluetooth functionality, reduced eye strain through screen tinting, and enhancements in voice control and input capabilities. Not all features will be available immediately after installation, with security-related improvements being deployed universally.

AppWizard

July 14, 2026

GOG dunks on Sony and reminds everyone why PC gaming is so beloved: “You don’t need a storefront’s permission to play what you bought”

Sony will stop producing physical discs by 2028. GOG, a digital games retailer, allows users to purchase games and create their own physical backups, promoting consumer autonomy. Unlike Steam, GOG provides downloadable installers for every game, enabling offline access and management without regional restrictions. GOG offers resources for users to create physical copies of their digital purchases. The UK retail association has raised concerns that PlayStation's decision could eliminate a 2 million market and undermine consumer freedoms.