roles Archives

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.

AppWizard

May 9, 2025

Sumo Group’s founders are leaving the company

Sumo Group is undergoing a leadership transition as CEO Carl Cavers, COO Paul Porter, and Director of Excellence and Integration Darren Mills step down after 22 years. CFO Andy Stewart and newly-promoted COO Gary Dunn will share the chief executive responsibilities. Tim Repa-Davies has been promoted to the board. Cavers expressed pride in their achievements and confidence in Sumo's future, while Stewart highlighted the natural evolution of the company.

AppWizard

May 9, 2025

Doom: The Dark Ages review

The latest first-person shooter from id Software, titled Doom: The Dark Ages, is set to release on May 15, 2025, with a price of £60. It is published by Microsoft and has been reviewed on an RTX 2080 Super, Intel Core i9 9900KS, and 32GB RAM. The game features a new mechanic called the Shield Saw, allowing players to deflect attacks and engage enemies more aggressively. However, the complexity of the firearms has been reduced, with no dedicated secondary fire modes and a focus on passive upgrades. The game emphasizes accessibility, offering customizable difficulty settings, but the level designs are simpler compared to previous installments. Players can pilot mechs and engage in aerial dogfights, but these moments are brief and feel disconnected from the main gameplay. The overall experience may lead players to prefer earlier entries in the series. The game does not include multiplayer and has not been tested on Steam Deck.

Winsage

May 9, 2025

You Need a Windows Package Manager — Virtualization Review

Microsoft's WinGet is a command-line tool for managing software on Windows, allowing users to install, update, list, and uninstall applications. UniGetUI is an open-source graphical user interface that enhances WinGet's functionality, making it easier for users to manage software without using the command line. UniGetUI supports various package managers and features batch operations, automatic updates, and custom installation options. To install UniGetUI, users can execute the command winget install --exact --id MartiCliment.UniGetUI --source winget or download it from the Microsoft Store. Users can easily navigate its interface to discover, install, and uninstall packages.

Winsage

May 8, 2025

The 12 KB Windows just can’t quit

Raymond Chen discussed the moricons.dll file on his blog, highlighting its significance in the Windows operating system. The file, sized at 12,288 bytes, contains icons from the Windows 3.1 era, including those for Turbo Pascal, Quattro Pro, WordPerfect, Lotus 123, and cc:Mail. Originally, icons were stored in progman.exe, but as their collection grew, they were moved to moricons.dll for better organization. This library has persisted through various Windows upgrades, evolving from Program Manager icons to shortcut files in Windows 95. Despite the transition to 64-bit Windows, which no longer supports MS-DOS programs, moricons.dll has survived, suggesting that some users may still find value in these nostalgic icons.

Winsage

May 6, 2025

Expanding the Surface for Business Copilot+ PC portfolio

AI has evolved into a transformative force for organizations, increasing the demand for secure and high-performance AI-ready Windows 11 PCs. Microsoft has introduced Copilot+ PCs, including the new 12-inch Surface Pro and 13-inch Surface Laptop, both powered by the Snapdragon X Plus processor with an integrated neural processing unit (NPU) capable of 45 trillion operations per second. The 13-inch Surface Laptop offers up to 23 hours of video playback and 16 hours of web browsing, with performance enhancements of up to 50% faster speeds and double the battery life compared to its predecessor. It features an AI-enhanced 1080p front camera for video conferencing and a durable design. The 12-inch Surface Pro is the thinnest and lightest Copilot+ PC, providing 50% faster performance and up to 16 hours of local video playback. Both devices are designed as Secured-core PCs with advanced security features, including Windows Hello for Business and biometric authentication options. They support enhanced productivity through AI features in Windows 11 and Microsoft 365 Copilot, enabling faster file searches and improved team efficiency. Microsoft emphasizes sustainability with the use of recycled materials and energy-efficient designs. The new devices will be available starting July 22 in select markets.

AppWizard

May 5, 2025

Messaging app used by Trump official suspends operations after reported hack

National Security Advisor Michael Waltz was preparing for a television interview at the White House using the messaging app TeleMessage, which is currently facing a temporary suspension due to a security breach. The parent company, Smarsh, is investigating the incident and has halted all TeleMessage services while engaging an external cybersecurity firm. The breach reportedly involves the theft of data from messages sent via TeleMessage's versions of popular messaging platforms, but there is no indication that Waltz's messages were accessed. The White House has not responded to inquiries about the service suspension. Waltz was previously photographed using TeleMessage while communicating with various officials. Former President Donald Trump intends to nominate Waltz as the U.S. ambassador to the United Nations, with Secretary of State Marco Rubio serving as the interim national security advisor. Concerns have been raised about whether private messages are automatically deleted, potentially violating federal records-retention laws, and TeleMessage may compromise Signal's end-to-end encryption.

AppWizard

May 2, 2025

Caught on camera: Mike Waltz using less secure version of Signal messaging app – The Times of India

Mike Waltz has come under scrutiny due to a photograph showing his use of a modified messaging application, TM SGNL, raising security concerns. The photo, taken by Reuters on April 30, 2025, during a White House cabinet meeting, revealed Waltz's phone screen with conversations involving JD Vance, Marco Rubio, Tulsi Gabbard, and Steve Witkoff, who are key figures in foreign relations and national security regarding Ukraine. TM SGNL is a variant of Signal, known for its encryption, but its archiving feature risks compromising end-to-end encryption. Messages displayed included a note to Rubio stating, "there is time," and Vance's message about confirmation from a counterpart. Following these events, President Trump appointed Waltz as UN ambassador and Rubio as interim national security advisor. The White House stated that "Signal is an approved app for government use and is loaded on government phones."

AppWizard

May 1, 2025

Epic Games Store Has a New Free PC Game Now Available

The Epic Games Store is offering the free PC game Super Space Club, available for download until May 8. Players who claim the game during this period will permanently add it to their library without any subscription fees, requiring only a free Epic Games Store account. Super Space Club, developed by GrahamOfLegend, is typically priced at .99 and has a 94% approval rating on Steam from 36 reviews. It is an "endless arcade gunner" where players defend the galaxy as misfit pilots, featuring various characters, ships, and weapons. Players typically spend between 2 to 10 hours on the game.

Winsage

April 29, 2025

Why CEO of $40 billion company that caused biggest-ever Windows outage wishes he had joined Microsoft before going to law school

Cloudflare CEO Matthew Prince reflected on his career decisions, expressing regret for not gaining experience at a larger company before pursuing graduate studies. He received job offers from companies like Yahoo, Microsoft, and Netscape but declined them to attend the University of Chicago Law School, aiming to become a cybersecurity lawyer. In an interview, he noted that working at a mid-sized company during the dot-com boom could have provided valuable experience and networking opportunities. Despite not regretting his later job rejections, he acknowledged that his law degree has been crucial for navigating legal challenges in his company. Prince believes that experiencing a dynamic work environment could have accelerated his career.