analyze Archives

Winsage

May 22, 2025

Can Microsoft Turn PC And Cloud Dominance Into AI Supremacy?

Microsoft is advancing an "agentic" future in enterprise computing by leveraging its strengths in Windows PCs and Azure cloud. At Build 2025, executives presented a vision of an "open agentic web" where intelligent software agents operate across devices and applications. Currently, 15 million developers use GitHub Copilot, and 90% of Fortune 500 firms have developed AI agents using Microsoft tools. GitHub Copilot is evolving into a proactive coding agent capable of performing complex development tasks autonomously. Azure AI Foundry is introduced as a unified environment for AI applications, hosting over 1,900 AI models and enabling enterprises to select optimal models for their needs. Windows is transforming into an AI platform with features like AI-driven shortcuts and local AI model access. The Model Context Protocol (MCP) and NLWeb are central to Microsoft's strategy, promoting openness and interoperability among AI agents. Copilot Tuning allows organizations to customize AI agents for specific business contexts, while Copilot Studio supports multi-agent orchestration. Microsoft's integrated AI approach contrasts with competitors like Google and Amazon, positioning it as a leader in providing comprehensive AI solutions.

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.

Winsage

May 19, 2025

ChatGPT’s Image Generator Is Now in Microsoft Copilot. Here’s What You Can Do With It

Microsoft has upgraded its Copilot AI assistant by integrating OpenAI's GPT-4o model, enhancing its image generation capabilities within Microsoft 365 applications like Word, Excel, and Outlook. Users can now create intricate visuals by describing their desired images. Copilot can draft documents, analyze data, create presentations, manage emails, and now generate high-quality, photorealistic images from text prompts. This feature allows for the creation and modification of custom graphics without external design software. The GPT-4o image generation capabilities were initially rolled out to enterprise users and are now available to the general public. This enhancement positions Microsoft Copilot ahead of other creative tools that use older DALL-E models, aiming to compete with industry leaders like OpenAI and Google Gemini.

Tech Optimizer

May 19, 2025

How to catch and optimize problematic queries in PostgreSQL

Performance issues in PostgreSQL can arise as databases grow, leading to declines in query performance. To identify problematic queries, one can log long-running queries by setting the `log_min_duration_statement` parameter in the `postgresql.conf` file. The `pg_stat_statements` module can be enabled to monitor execution statistics of SQL statements, providing insights into query performance, including execution time and the number of calls. Queries with high standard deviation in execution time may indicate inconsistency, while sorting query statistics by total execution time can reveal excessive load from multiple fast queries. Real-time monitoring can be done using the `pg_stat_activity` view to check active queries and their states, and the `pg_locks` view can help identify blocked processes. The `EXPLAIN` command can analyze query execution plans, and using the `auto_explain` module can log plans for slow queries. Understanding cost parameters in query plans helps in optimizing performance, and different join methods (Nested Loop, Merge Join, Hash Join) have varying complexities and costs. To influence the planner's choice of scanning methods, configuration parameters can be adjusted, such as disabling sequential scanning. Extensions like `sr_plan`, `pg_hint_plan`, and `AQO` can further optimize query execution. Monitoring query progress can be done using dynamic views like `pg_stat_progress_*` for various commands.

Tech Optimizer

May 19, 2025

A spoof antivirus makes Windows Defender disable security scans

A researcher known as es3n1n explored Windows security mechanisms to bypass antivirus software validation checks in the Windows Security Center (WSC). He used tools like dnSpy and Process Monitor to analyze how legitimate antivirus solutions register with WSC. He confirmed that WSC validates the signatures of processes calling its APIs. Previously, es3n1n faced controversy when his project, no-defender, was removed from GitHub due to a DMCA takedown request from a software vendor.

Winsage

May 17, 2025

Crapfixer 1.0 is here to fix Windows 11 and turn it into the operating system you deserve — download it now!

Crapfixer is a utility for Windows 11 that has been completely overhauled and reached version 1.0 two weeks ago. It helps users streamline their operating system by analyzing and providing recommendations for fixes. Users can launch the application, click Analyze, and receive a list of recommendations to implement with a click on Run CFixer. It also offers a manual exploration option with features like hiding Copilot, disabling telemetry, and removing ads. The new version includes the ability to analyze logs online and an AI feature to remove "Ask Copilot" from the context menu. Crapfixer 1.0 is available for download on GitHub.

Winsage

May 15, 2025

Microsoft Copilot+ Recall: who should disable it, and how

Microsoft's Recall feature for Copilot+ PCs was initially announced a year ago but delayed due to privacy concerns raised by cybersecurity experts. The updated version was released in April 2025 for Windows Insider Preview builds and rolled out more broadly in May. Key updates include requiring user permission for activation, encrypting database files with hardware-based Trusted Platform Module (TPM), and implementing a filter to prevent saving sensitive information. Recall is enabled on a per-user basis, can be uninstalled, does not require a Microsoft account, and processes data locally. However, it still has vulnerabilities, such as allowing access with a regular Windows PIN after initial biometric authentication and failing to consistently filter sensitive data. Recall can log interactions during calls and capture self-destructing messages, posing privacy risks. It can impact performance and battery life, especially during gaming. Users handling sensitive data or frequently using video conferencing may want to disable or remove Recall. Instructions for disabling or removing Recall are provided, along with precautions for those who choose to use it.

Winsage

May 12, 2025

Copilot on Windows: Windows Insiders can now use Vision with 2 apps and new Highlights feature with 1 app

The Microsoft Copilot app on Windows has received an update that enhances Copilot Vision, allowing users to share a single browser or app window for guided assistance with specific tasks. Users can ask Copilot to highlight areas of interest within the shared window. The update also introduces support for sharing up to two applications simultaneously, enabling Copilot to analyze and provide insights across both. The update is identified as version 1.25044.92.0 and higher and is being rolled out to Insiders in the U.S. via the Microsoft Store. Users can provide feedback through the app.

Tech Optimizer

May 12, 2025

Database performance analysis using pg_profile and pgpro_pwr

pgpro_pwr is a database workload monitoring tool for database administrators (DBAs) to identify resource-demanding operations. It was launched in 2017 as pg_profile by Andrey Zubkov, who moved from being a DBA to an engineer at Postgres Professional. pg_profile is compatible with open-source PostgreSQL and has been integrated into PostgreSQL 17 as of 2024, while pgpro_pwr offers advanced statistical insights and is included in Postgres Pro releases. Both tools monitor database workload metrics through continuously incrementing counters, capturing values at intervals and archiving differences. They do not provide alerting capabilities but are useful for assessing system stability, analyzing load testing outcomes, and identifying system-intensive activities. The tools consist of repository tables, data collection functions, reporting functions, and service tables. To use them, one must install the extension, configure roles, and set up parameters. Reports can be generated for workload statistics over time and comparisons between different time intervals. Examples of report types include wait event statistics and advanced vacuum statistics. Future plans include submitting a patch to introduce vacuum statistics to vanilla PostgreSQL.

Winsage

May 12, 2025

Microsoft Releases Detailed Guide to Fix Windows Blue Screen Errors

Microsoft has released an official guide to address the Blue Screen of Death (BSOD) issues in Windows 11 and Windows 10, updated on May 11, 2025, following a significant global outage in July 2024 caused by a problematic CrowdStrike update. The guide categorizes troubleshooting into basic and advanced steps, highlighting common error codes like PAGEFAULTINNONPAGEDAREA (0x00000050). Approximately 75% of stop errors are attributed to faulty drivers, making driver verification essential. Basic troubleshooting includes removing recently added hardware, booting into Safe Mode, checking Device Manager for problematic components, ensuring 10-15% free disk space, installing the latest Windows Updates, and using System Restore. Advanced troubleshooting involves using Event Viewer, running Windows Memory Diagnostics, and analyzing memory dumps with WinDbg. The guide emphasizes the resource-intensive nature of Driver Verifier and suggests testing suspicious drivers in smaller groups. It also includes hardware-specific troubleshooting tips, such as checking for overheating components and performing disk diagnostics with the “chkdsk” command.