Misha has a co-worker who has unusual ideas about how database performance works. This co-worker, Ted, has a vague understanding that a SQL query optimizer will attempt to find the best execution path for a given query. Unfortunately, Ted has just enough knowledge to be dangerous; he believes that the job of a developer is to write SQL queries that will "trick" the optimizer into doing an even better job, somehow.

This means that Ted loves subqueries.

For example, let's say you had a table called tbl_updater, which is used to store pending changes for a batch operation that will later get applied. Each change in updater has a unique change key that identifies it. For reasons best not looked into too deeply, at some point in the lifecycle of a record in this table, the application needs to null out several key fields based on the change value.

If you or I were writing this, we might do something like this:

update tbl_updater set id = null, date = null, location = null, type = null, type_id = null where change = @change

And this is how you know that you and I are fools, because we didn't use a single subquery.

update tbl_updater set id = null where updater in (select updater from tbl_updater where change = @change) update tbl_updater set date = null where updater in (select updater from tbl_updater where change = @change) update tbl_updater set location = null where updater in (select updater from tbl_updater where change = @change) update tbl_updater set type = null where updater in (select updater from tbl_updater where change = @change) update tbl_updater set date = null where updater in (select updater from tbl_updater where change = @change) update tbl_updater set type_id = null where updater in (select updater from tbl_updater where change = @change)

So here, Ted uses where updater in (subquery) which is certainly annoying and awkward, given that we know that change is a unique key. Maybe Ted didn't know that? Of course, one of the great powers of relational databases is that they offer data dictionaries so you can review the structure of tables before writing queries, so it's very easy to find out that the key is unique.

But that simple ignorance doesn't explain why Ted broke it out into multiple updates. If insanity is doing the same thing again and again expecting different results, what does it mean when you actually do get different results but also could have just done all this once?

Misha asked Ted why he took this approach. "It's faster," he replied. When Misha showed benchmarks that proved it emphatically wasn't faster, he just shook his head. "It's still faster this way."

Faster than what? Misha wondered.

[Advertisement] Picking up NuGet is easy. Getting good at it takes time. Download our guide to learn the best practice of NuGet for the Enterprise.

An anonymous reader quotes a report from Ars Technica: For some years now, detractors of battery electric vehicles have held up hydrogen as a clean fuel panacea. That sometimes refers to hydrogen combustion engines, but more often, it's hydrogen fuel cell electric vehicles, or FCEVs. Both promise motoring with only water emitted from the vehicles' exhausts. It's just that hydrogen actually kinda sucks as a fuel, and automaker Stellantis announced today that it is ending the development of its light-, medium- and heavy-duty FCEVs, which were meant to go into production later this year. Hydrogen's main selling point is that it's faster to fill a tank with the stuff than it is to recharge a lithium-ion battery. So it's a seductive alternative that suggests a driver can keep all the convenience of their gasoline engine with none of the climate change-causing side effects. But in reality, that's pretty far from true. [...] Between the high development costs and the fact that FCEVs only sell with strong incentives, the decision was made to cancel the production of hydrogen vans in France and Poland. Stellantis says there will be no job losses at its factories and that R&D staff will be put to work on other projects. "In a context where the Company is mobilizing to respond to demanding CO2 regulations in Europe, Stellantis has decided to discontinue its hydrogen fuel cell technology development program," said Jean-Philippe Imparato, chief operating officer for Enlarged Europe. "The hydrogen market remains a niche segment, with no prospects of mid-term economic sustainability. We must make clear and responsible choices to ensure our competitiveness and meet the expectations of our customers with our electric and hybrid passenger and light commercial vehicles offensive."

Read more of this story at Slashdot.

Longtime Slashdot reader Qbertino writes: Heise, a German IT news publisher, reports (English version via Google Translate) that the German state of Brandenburg is getting the world's tallest wind turbine, with an overall height of 300 meters (approximately 365 meters including rotor blades), designed to capture so-called third-level winds at higher altitudes. The article also includes a short 3D animation illustrating the construction and its size relative to standard modern wind turbines. The wind turbine uses a dual-framework base instead of a traditional closed tower to access stronger high-altitude winds, aiming to match offshore energy output while keeping onshore operating costs. According to Heise, the prototype could lead to the installation of up to 1,000 units across Germany -- fitting seamlessly between existing wind farms without needing extra land.

Read more of this story at Slashdot.

Intel is laying off more than 5,000 employees across four states, according to updated Worker Adjustment and Retraining Notification filings. From a report: Most of the cuts are happening in California and Oregon. Intel more than doubled its layoff estimates for Santa Clara and Folsom to a total of 1,935 affected employees, according to California WARN filings. The cuts began taking place in Folsom on July 11, and in Santa Clara on July 15.

Read more of this story at Slashdot.

Scale AI is laying off 14% of its workforce and 500 contractors as part of a major restructuring just weeks after Meta bought a 49% stake and absorbed its CEO into a new superintelligence lab. The Verge reports: Jason Droege, CEO of Scale AI, sent an email to all Scale employees today, which was viewed by The Verge. Droege said he plans to restructure several parts of Scale's generative AI business and organize it from 16 pods to "the five most impactful": code, languages, experts, experimental, and audio. The company will also reorganize its go-to-market team into a single "demand generation" team that will have four pods, each covering a specific set of customers. "The reasons for these changes are straightforward: we ramped up our GenAI capacity too quickly over the past year," Droege wrote. "While that felt like the right decision at the time, it's clear this approach created inefficiencies and redundancies. We created too many layers, excessive bureaucracy, and unhelpful confusion about the team's mission. Shifts in market demand also required us to re-examine our plans and refine our approach." Droege said that he believes the changes to the company will make it more able to adapt to market shifts, serve existing customers, and win back customers that have "slowed down" work with Scale. He also said that the company would deprioritize generative AI projects with less growth potential. "We remain a well-resourced, well-funded company," he wrote. Scale's generative AI business unit will have an all-hands meeting tomorrow, followed by a company-wide meeting on July 18th. Osborne said that Scale plans to increase investment and hire hundreds of new employees in areas like enterprise, public sector, and international public sector, in the second half of 2025 and that severance has been paid out to impacted roles. "We're streamlining our data business to help us move faster and deliver even better data solutions to our GenAI customers," he said.

Read more of this story at Slashdot.

Longtime Slashdot reader bobdevine shares a report from OSTechNix: For the first time, Linux has officially broken the 5% desktop market share barrier in the United States of America! It's a huge milestone for open-source and our fantastic Linux community. While many might think of Linux as a niche choice, this new data shows a significant shift is happening. According to the latest StatCounter Global Stats for June 2025, Linux now holds 5.03% of the desktop operating system market share in the United United States of America. This is fantastic news! [...] One truly satisfying detail for me? Linux has finally surpassed the "Unknown" category in the USA! It shows that our growth is clear and recognized. "It took eight years to go from 1% to 2% (by April 2021), then just 2.2 years to reach 3% (June 2023), and a mere 0.7 years to hit 4% (February 2024)," notes the report. "Now, here we are, at over 5% in the USA! This exponential growth suggests that we're on a promising upward trend."

Read more of this story at Slashdot.

An anonymous reader quotes a report from TechCrunch: Security researchers say Chinese authorities are using a new type of malware to extract data from seized phones, allowing them to obtain text messages -- including from chat apps such as Signal -- images, location histories, audio recordings, contacts, and more. In a report shared exclusively with TechCrunch, mobile cybersecurity company Lookout detailed the hacking tool called Massistant, which the company said was developed by Chinese tech giant Xiamen Meiya Pico. Massistant, according to Lookout, is Android software used for the forensic extraction of data from mobile phones, meaning the authorities using it need to have physical access to those devices. While Lookout doesn't know for sure which Chinese police agencies are using the tool, its use is assumed widespread, which means Chinese residents, as well as travelers to China, should be aware of the tool's existence and the risks it poses. [...] The good news ... is that Massistant leaves evidence of its compromise on the seized device, meaning users can potentially identify and delete the malware, either because the hacking tool appears as an app, or can be found and deleted using more sophisticated tools such as the Android Debug Bridge, a command line tool that lets a user connect to a device through their computer. The bad news is that at the time of installing Massistant, the damage is done, and authorities already have the person's data. "It's a big concern. I think anybody who's traveling in the region needs to be aware that the device that they bring into the country could very well be confiscated and anything that's on it could be collected," said Kristina Balaam, a researcher at Lookout who analyzed the malware. "I think it's something everybody should be aware of if they're traveling in the region."

Read more of this story at Slashdot.

Steam has begun banning games that violate the payment rules of banks and card networks, targeting adult content in particular -- especially titles with extreme or controversial themes. Engadget reports: The new clause states that "content that may violate the rules and standards set forth by Steam's payment processors and related card networks and banks, or internet network providers" is not allowed and could result in removal from the platform. In other words, if credit card companies get mad about something, they could actually have the power to ban a game. The clause goes on to say that this will affect "certain kinds of adult-only content." This has likely already resulted in many games being pulled off the platform. SteamDB doesn't give a reason for these removals, but the timing does match up.

Read more of this story at Slashdot.

OpenAI has added Google Cloud as a provider for ChatGPT and its API, expanding beyond Microsoft to address growing demand for computing power. CNBC reports: OpenAI has added Google to a list of suppliers, specifying that ChatGPT and its application programming interface will use the Google Cloud Platform, as well as Microsoft, CoreWeave and Oracle. The announcement amounts to a win for Google, whose cloud unit is younger and smaller than Amazon's and Microsoft's. Google also has cloud business with Anthropic, which was established by former OpenAI executives. The Google infrastructure will run in the U.S., Japan, the Netherlands, Norway and the United Kingdom.

Read more of this story at Slashdot.

An anonymous reader quotes a report from Android Authority: Italian YouTuber Once Were Nerd covers a variety of retro gaming topics, but his reviews of ANBERNIC devices appear to be the straw that broke the camel's back. According to the video [here], customs enforcement officers from the Guardia di Finanza showed up at his home and office on April 15 with a search warrant to investigate promotion of pirated copyrighted materials. They seized a variety of ANBERNIC, Powkiddy, and TrimUI gaming handhelds from his collection. In total, more than 30 consoles were taken. The creator, assuming he didn't do anything wrong, complied with demands, providing full transcripts of his conversations and chats with gaming handheld manufacturers. The officers also took his phone, promising to return it in a few days. It was returned two months later, on June 15. According to the video, officials are not required to disclose what exactly the charges are or who has brought them until the initial investigation is complete under Italian law. At that point, the case is either dismissed or goes to trial. The complaint specifically mentions reproduction of copyrighted material from Nintendo and Sony, but the case may originate from the agency itself. However, in the meantime officials have the option to shut down his channel, even before proving any wrongdoing. This is a scary prospect for any creator who has spent years building a channel, and unlike YouTube copyright strikes, there's likely no remedy. Currently, officials contest that his reviews of ANBERNIC devices like the RG Slide, which often, but not always, ship with microSD cards filled with copyrighted ROMs, are punishable under Article 171 ter of the Italian Copyright Law. This law, which was originally written in 1941, allows for a maximum punishment of 15,000 euros (or 30 million Italian Lira, since the law pre-dates the Euro) and three years of jail time.

Read more of this story at Slashdot.

The abstract of a paper featured on NBER: Most U.S. innovation output originates from firms that operate R&D facilities across multiple local markets. We study how this geographic structure influences aggregate innovation and growth, and whether it is socially optimal. First, we develop an endogenous growth model featuring multi-market innovative firms that generate knowledge spillovers to geographically proximate firms. In equilibrium, firms may operate in too few or too many local markets, depending on how sensitive are the local spillovers they generate to their local size. Second, to quantify these effects, we link the model to data on firms' R&D locations, patents, and citation networks. Using an event-study design, we show that firms' spatial expansion increases spillovers to other firms and estimate how these spillovers depend on a firm's local footprint. Our estimates imply that U.S. innovative firms operate in too few markets relative to the social optimum. Third, using quantitative counterfactuals, we find that policies promoting broader spatial scope yield larger welfare gains than standard R&D subsidies. Moreover, unlike R&D subsidies, such policies can also reduce regional inequality.

Read more of this story at Slashdot.

VMware has notified partners that its current channel program will end, replacing it with an invitation-only system that significantly reduces the number of authorized partners. Partners not invited to the new VMware Cloud Service Provider program would have received non-renewal notices on July 15, 2025, and can continue transactions only until October 31, 2025, after which they may service existing contracts through their current terms. The company is also ending its White Label program on October 31, 2025. The changes mark the second major partner program overhaul in 18 months, following Broadcom's January 2024 decision to terminate partners operating VMware-powered clouds with fewer than 3,500 processor cores.

Read more of this story at Slashdot.

BrianFagioli writes: Meta has partnered with Amrize and the University of Illinois to develop an "AI-optimized" concrete mix that cuts carbon by 35% for its new data center.

Read more of this story at Slashdot.

An anonymous reader shares a report: Google will now let everyone in the US call local businesses using AI. The feature, which is now available in Search, allows you to use AI for pricing or availability information without having to talk on the phone. Google first started testing this feature in January, and it's still only available for certain kinds of businesses, like pet groomers, dry cleaners, and auto shops. When you search for one of these services, like a pet groomer, Google will display a new "have AI check pricing" prompt beneath the business listing.

Read more of this story at Slashdot.

Amazon.com marked its 30th anniversary Wednesday, three decades after Jeff Bezos launched the company as an online bookstore promising "one million titles" from Seattle. The e-commerce giant began in 1995 with Bezos, his then-wife MacKenzie Scott, and seven employees. The company now employs 1.5 million people and carries a market capitalization exceeding $2 trillion. Amazon has expanded from books into groceries through its $13.7 billion Whole Foods acquisition, cloud computing via Amazon Web Services, and entertainment with Prime Video.

Read more of this story at Slashdot.

WeTransfer has reversed controversial terms of service changes after users protested language suggesting uploaded files could be used to "improve machine learning models." The file-sharing service, popular among creative professionals and used by 80 million users across 190 countries, clarified that user content had never been used to train AI models and removed all references to machine learning from its updated terms. Creative users including voice actors, filmmakers, and journalists had threatened to cancel subscriptions over the changes.

Read more of this story at Slashdot.

Digital tokens designed to track popular stocks have suffered extreme price deviations since launching two weeks ago, with an Amazon-tracking token briefly spiking to more than 100 times the underlying stock's closing price. The token AMZNX hit $23,781.22 on crypto trading platform Jupiter on July 3, while Amazon shares had closed the previous day around $200. A similar Apple-tracking token jumped to $236.72 on July 3, representing a 12% premium to the actual stock price. Companies including Robinhood, Kraken, Gemini and Bybit launched these blockchain-based versions of U.S. stocks in late June for non-U.S. customers. Robinhood is facing scrutiny from Lithuania's central bank after launching tokens tied to OpenAI and SpaceX without permission from either company, prompting OpenAI to disavow the tokens on social media.

Read more of this story at Slashdot.

Seagate has released its first heat-assisted magnetic recording hard drives for individual buyers, marking the commercial debut of technology the company has developed for more than two decades. The 30TB IronWolf Pro and Exos M drives cost $600, while 28TB models are priced at $570. The drives use HAMR technology, which uses tiny lasers to heat and expand drive platter sections within nanoseconds to write data at higher densities. Seagate announced delivery of HAMR drives up to 36TB to datacenter customers in late 2024. The consumer models use conventional magnetic recording technology and are built on Seagate's Mosaic 3+ platform, achieving areal densities of 3TB per disk. Western Digital plans to release its first HAMR drives in 2027, though it has reached 32TB capacity using shingled magnetic recording. Toshiba will sample HAMR drives for testing in 2025 but has not announced public availability dates.

Read more of this story at Slashdot.

Airbus's Silicon Valley innovation center Acubed and Google spinout SandboxAQ have successfully tested a quantum-sensing navigation device as an alternative to GPS during 150 hours of flights across the continental United States. The toaster-sized MagNav device uses quantum physics to measure unique magnetic signatures in Earth's crust [non-paywalled, syndicated link], with an AI algorithm matching those signatures to exact locations. The technology achieved Federal Aviation Administration requirements by pinpointing aircraft location within two nautical miles 100% of the time and within 550 meters 64% of the time. SandboxAQ CEO Jack Hidary called it "the first novel absolute navigation system to our knowledge in the last 50 years." The analog system cannot be jammed or spoofed like GPS, which faces increasing tampering in the Middle East and around Ukraine and Russia.

Read more of this story at Slashdot.

An anonymous reader quotes a report from Ars Technica: Chinese firms have begun rushing to order Nvidia's H20 AI chips as the company plans to resume sales to mainland China, Reuters reports. The chip giant expects to receive US government licenses soon so that it can restart shipments of the restricted processors just days after CEO Jensen Huang met with President Donald Trump, potentially generating $15 billion to $20 billion in additional revenue this year. Nvidia said in a statement that it is filing applications with the US government to resume H20 sales and that "the US government has assured Nvidia that licenses will be granted, and Nvidia hopes to start deliveries soon." [...] The H20 chips represent Nvidia's most capable AI processors legally available in China, though they contain less computing power than versions sold elsewhere due to export restrictions imposed in 2022. Nvidia is currently banned from selling its most powerful GPUs in China. Despite these limitations, Chinese tech giants, including ByteDance and Tencent, are reportedly scrambling to place orders for the lesser chip through what sources describe as an approved list managed by Nvidia. "The Chinese market is massive, dynamic, and highly innovative, and it's also home to many AI researchers," Reuters reports Huang telling Chinese state broadcaster CCTV during his visit to Beijing, where he is scheduled to speak at a supply chain expo on Wednesday. "Therefore, it is indeed crucial for American companies to establish roots in the Chinese market." The resumption of H20 sales marks a shift in US-China technology relations after the chips were effectively banned in April with an onerous export license requirement, forcing Nvidia to take a $4.5 billion write-off for excess inventory and purchase obligations. According to Reuters, Chinese sales generated $17 billion in revenue for Nvidia in the fiscal year ending January 26, representing 13 percent of total sales. Nvidia also announced it will introduce a new "RTX Pro" chip model specifically tailored to meet regulatory rules in the Chinese market, though the company provided no details about its specifications or capabilities.

Read more of this story at Slashdot.