indexing Archives

Winsage

July 1, 2026

Microsoft Boosts File Explorer Launch Speed in Windows 11

Microsoft has released the optional Windows 11 June update, KB5095093, which improves the performance of File Explorer by addressing launch speed and overall functionality. The update includes a redesign of the Home tab for better file indexing, new quick actions for file management, improved responsiveness when mounting disk images, and enhanced address bar functionality. This update will become mandatory by July 2026.

Winsage

June 30, 2026

Microsoft Reveals Windows Setting to Safely Remove USB Drives and Prevent Data Loss

Removing a USB drive from a port without using the “safely remove” option is generally acceptable on many Windows computers, depending on the policy for the external device. Microsoft provides two main options for removable drives: quick removal and better performance. Under the quick removal policy, users can disconnect the device without the “Safely Remove Hardware” process, although this may reduce system performance. Since Windows 10 version 1809, quick removal has been the default policy for external devices. However, users must ensure that all operations, such as copying or formatting, are completed before removal. The better performance policy requires users to use the safe removal option to prevent data loss, as it allows write caching. Failing to do so increases the risk of data loss if the drive is disconnected while Windows is still processing writes. The highest risk of data loss occurs when the drive is removed while Windows or an application is engaged in file operations. The safe removal icon serves as a confirmation that the drive is not in use, helping to prevent accidental ejection during active processes. Users can check the flash drive policy by accessing the device properties in Disk Management. The chosen setting may persist upon reconnection to the same computer port, leading to different experiences for users with similar drives. To minimize data loss, it is recommended to wait for operations to finish and use safe removal when uncertain about the drive's status.

Tech Optimizer

June 20, 2026

PostgreSQL 18 on Amazon Aurora and Amazon RDS: Security, monitoring, and developer enhancements

PostgreSQL version 18 has deprecated MD5 password authentication in favor of SCRAM-SHA-256, with a new parameter, md5_password_warnings, enabled by default to log deprecation warnings. It has enhanced monitoring capabilities by adding columns to pg_stat_database and pg_stat_statements to track parallel worker activity, with the default max_parallel_workers_per_gather set to 0 in Aurora PostgreSQL. The pg_stat_subscription_stats view now includes new columns for tracking conflict types in logical replication. Optimizer statistics are automatically transferred during upgrades, while uuidv7() generates timestamp-ordered UUIDs. The default streaming option for CREATE SUBSCRIPTION has changed to parallel, and the idle_replication_slot_timeout parameter automatically invalidates inactive replication slots. Enhancements to the COPY command include REJECT_LIMIT for error tolerance and a silent LOG_VERBOSITY level. OLD and NEW aliases have been introduced in RETURNING clauses for various DML commands.

Tech Optimizer

June 18, 2026

Announcing Lakebase Search: agent-native retrieval built into Lakebase Postgres

Lakebase Search is a hybrid vector and full-text retrieval system integrated into Lakebase, now in beta on AWS and Azure. It utilizes two Postgres extensions: lakebase_vector and lakebase_text, allowing agents to operate on a single data backend. Agents manage four times more databases than human users and require real-time access to indexed data. The system features a tiered architecture that stores cold data in cost-effective object storage while keeping active data in local NVMe, significantly reducing costs. The lakebase_vector extension offers 32x compression for vectors, allowing a billion vectors to fit into under 10GB of RAM. The lakebase_text extension provides BM25 relevance ranking without high RAM usage. Benchmarking shows that Lakebase Search can efficiently handle large-scale workloads, achieving high recall and low latency with reduced resource requirements compared to traditional architectures. The system allows for continuous search experimentation and dedicated retrieval engines for each agent, enhancing operational efficiency and scalability.

Winsage

June 16, 2026

Start

The Start interface in Windows 11 is a centered floating window that can be accessed by clicking the Start button or using keyboard shortcuts like WINKEY or Ctrl + Esc. Key features include a Search box for initiating searches, a customizable Pinned section for frequently used apps, a Recommended area for recently accessed items, and an All section displaying all installed apps. Users can manage their account through the Account manager, access power options for Lock, Sleep, Shutdown, and Restart, and connect mobile devices via the Phone Link app. Customization options for the Start interface include moving the Start and Taskbar icons to the left, configuring Windows Search settings, and customizing the Pinned and Recommended sections. Users can pin, unpin, and rearrange app shortcuts in the Pinned section, adjust what appears in the Recommended section, and choose between different layout views in the All section. The Account manager allows limited customization of notifications, and users can add folders and mobile device slices to Start. The Quick link menu provides access to legacy management interfaces and can be accessed by right-clicking the Start button or using WINKEY + X.

Winsage

June 13, 2026

Windows Insiders Are Getting Big Windows 11 In-Box App Updates

Microsoft is enhancing transparency in Windows 11 app updates through the Windows Insider Program, allowing users to view detailed descriptions of updates for key applications like Calculator, Camera, Clock, Media Player, Paint, Photos, and Sound Recorder on the Windows Insider Documentation Hub. Notable changes include: - Calculator: Enhanced accuracy for square-root results, improved readability in high-contrast themes, fixed layout for right-to-left languages, and reliability updates. - Camera: Improved zoom slider, front camera support, additional video resolution options, better QR link functionality, and intuitive default settings. - Clock: New timer features, option to disable daily goals in Focus mode, and a 15-minute snooze feature. - Media Player: Custom captions, indexing banner in the play queue, playlist enhancements, bug fixes, and improved reliability. - Paint: More responsive toolbar, adjustable eraser transparency, refined stamp brush strokes, selection improvements, and performance enhancements. - Photos: AI watermarking, improvements for viewing small images and pixel art, enhancements for scanned text, crash bug fix, and streamlined keyboard navigation. - Sound Recorder: Live waveform display for Bluetooth microphones, simplified deletion processes, bug fixes, and additional enhancements. The timeline for these updates is uncertain, but app updates are expected to be deployed more quickly than system updates.

Tech Optimizer

June 13, 2026

Why Use App-Level Auth When Every Database Has Auth? (Splunk Enterprise CVE-2026-20253 Pre-Auth RCE)

On June 10th, Splunk released an advisory for CVE-2026-20253, a high-severity vulnerability with a CVSS score of 9.8 that requires no authentication. The vulnerability is associated with the PostgreSQL Sidecar Service Endpoint and affects Splunk Enterprise versions 10 and above. In default installations, the service is not installed on Windows but is installed and enabled by default on AWS. The vulnerability allows unauthorized users to create and truncate arbitrary files through an API that lacks authentication controls. Additionally, it enables the execution of SQL commands via a backup and restore mechanism, potentially leading to remote code execution (RCE). A Detection Artefact Generator has been developed to help organizations assess their vulnerability to this issue.

Winsage

June 7, 2026

Microsoft is letting you kill Bing in Windows 11 Search, after years of forcing it on every PC

Windows Search has been criticized for mixing local and web results, often prioritizing Bing over local applications or files. Microsoft is addressing this by allowing users to disable Bing integration and is developing a local-only version of Windows Search. This new feature will enable users to exclude web searches and Microsoft Store results, eliminating prompts for uninstalled applications. Enhancements being tested include a local search experience without interference from various services, faster search capabilities, prioritization of local results with minimal input, and support for substring searching. Users will be able to initiate local searches with just two characters, and substring searching will allow for more flexible file name searches.

Tech Optimizer

June 6, 2026

Azure HorizonDB Enters Public Preview: Web IQ Already Powers Copilot and ChatGPT

Microsoft announced the public preview of Azure HorizonDB, a fully managed PostgreSQL-compatible database designed for agentic AI workloads, during Microsoft Build 2026 in San Francisco. HorizonDB features a "database-as-logs" architecture, allowing for sub-millisecond multi-zone commit latency and independent scaling of compute and storage. It incorporates a Rust-based storage engine, native DiskANN vector search, and in-database AI model invocation. Additionally, Microsoft launched Web IQ, a web-grounding API layer integrated into Microsoft Copilot and OpenAI's ChatGPT, which provides passage-level structured evidence objects rather than full documents. Web IQ is model-agnostic and aims to enhance information density and reduce costs. Both services are currently in limited availability, with HorizonDB open for preview signups across five Azure regions.

Tech Optimizer

June 6, 2026

PostgreSQL vs SQL Server 2026: $0 vs $15K License

PostgreSQL has become the most utilized database for developers for two consecutive years as of 2026, while SQL Server has introduced native AI capabilities and vector search functionalities in its latest release. PostgreSQL is favored for new projects due to its permissive licensing, cross-platform operation, and extensive ecosystem of extensions, whereas SQL Server is preferred by organizations already using Microsoft products for its robust tooling and enterprise support. As of June 2026, SQL Server ranks third in the DB-Engines popularity ranking with a score of 698, while PostgreSQL ranks fourth with a score of 688. Developer adoption trends show that 49% of respondents in the Stack Overflow 2024 Developer Survey use PostgreSQL, compared to 27% for SQL Server. The latest stable version of PostgreSQL is 18.4, released on May 14, 2026, while SQL Server 2025 (version 17.x) became generally available on November 18, 2025. PostgreSQL is free under a permissive license, while SQL Server's Enterprise Edition can cost upwards of ,123 per two-core pack, with an eight-core minimum. PostgreSQL supports various operating systems, including Linux, Windows, macOS, and BSD, while SQL Server operates on Windows and Linux. PostgreSQL uses PL/pgSQL as its primary procedural language, allowing for multiple procedural languages, whereas SQL Server uses T-SQL. PostgreSQL's JSONB type offers rich indexing, while SQL Server added native JSON support in its 2025 release. Both databases are capable of handling high transaction volumes, but PostgreSQL excels in read-heavy scenarios due to its multi-version concurrency control, while SQL Server's columnstore indexes provide advantages for analytical workloads. PostgreSQL supports tables up to 32 TB, while SQL Server can handle a maximum database size of 524 PB. SQL Server's high availability technology includes Always On Availability Groups, while PostgreSQL offers built-in streaming and logical replication. The security features of both databases meet enterprise standards, with PostgreSQL providing a transparent patching process and SQL Server integrating with Microsoft tools. Real-world usage examples include Stack Overflow using SQL Server, while Instagram and Reddit utilize PostgreSQL. Developer sentiment increasingly favors PostgreSQL for new projects, emphasizing flexibility and open-source solutions. For new startups or greenfield projects, PostgreSQL is recommended due to its zero license cost and compatibility. Existing Microsoft enterprises are advised to stick with SQL Server for its integration benefits. Migration from SQL Server to PostgreSQL is becoming common, with a structured approach required for successful transitions.