Janne Anttila
LightNews LightNews
banner
janneaa.com
Janne Anttila
@janneaa.com
29 followers 56 following 11 posts
A senior data engineer living in Kuopio, Finland. Loves running, snowboarding and music. My blog: https://janneaa.com
Posts Replies Media Videos
janneaa.com
Kyllä peleihinkin pitäisi lisätä suomenkieliset nimet, kuten leffoissa oli aikoinaan. Sen verran hienoja on esim "Vanhin vierittää online-tilassa", "Detroit: Ryhdy ihmiseksi" ja "Nössöt aallot". support.microsoft.com/fi-fi/topic/...
Parannetut pelit Microsoft Edge -pelituki - Microsoft-tuki
support.microsoft.com
October 27, 2025 at 1:49 PM
Reposted by Janne Anttila
simonwillison.net
An LLM is a lossy encyclopedia simonwillison.net/2025/Aug/29/...
Since I love collecting questionable analogies for LLMs, here's a new one I just came up with: an LLM is a lossy encyclopedia. They have a huge array of facts compressed into them but that compression is lossy (see also Ted Chiang). The key thing is to develop an intuition for questions it can usefully answer vs questions that are at a level of detail where the lossiness matters. This thought sparked by a comment on Hacker News asking why an LLM couldn't "Create a boilerplate Zephyr project skeleton, for Pi Pico with st7789 spi display drivers configured". That's more of an lossless encyclopedia question! My answer: The way to solve this particular problem is to make a correct example available to it. Don't expect it to just know extremely specific facts like that - instead, treat it as a tool that can act on facts presented to it.
August 29, 2025 at 9:32 AM
janneaa.com
#TIL that the CSV settings in Azure Data Factory can be quite random. If the character used as a delimiter is inside a quoted value then it may be treated as a delimiter. Setting the "Escape character" in ADF to double quote fixes this even if nothing is actually escaped in the CSV.
August 21, 2025 at 9:49 AM
janneaa.com
Just posted some tips on the blog on how to list permissions in an Azure SQL Database. janneaa.com/posts/listin...
Listing all the permissions in an Azure SQL Database | Janne Anttila
The most common methods of giving permissions in an Azure SQL Database
janneaa.com
May 12, 2025 at 4:05 PM
janneaa.com
Spring is coming!
Sun shining in a snowy forest.
March 21, 2025 at 6:21 PM
janneaa.com
Emoji reactions are not how email is supposed to work... Receiving an email that contains only this seems like wasted time.
An Outlook emoji reaction
March 20, 2025 at 6:45 AM
janneaa.com
Just posted on the blog: Creating a free Hugo blog that's hosted on Cloudflare. janneaa.com/posts/creati...
Creating a free blog with Hugo and Cloudflare Pages | Janne Anttila
In this guide I'll go through the steps required to create a Hugo blog hosted on Cloudflare.
janneaa.com
March 19, 2025 at 6:20 PM
janneaa.com
DuckDB's local UI extension seems really interesting. It's always good to have some high quality local tools for data exploration. duckdb.org/2025/03/12/d...
The DuckDB Local UI
The DuckDB team and MotherDuck are excited to announce the release of a local UI for DuckDB shipped as part of the ui extension.
duckdb.org
March 13, 2025 at 8:37 AM
janneaa.com
I finally rebuilt my blog. It was high time since the last time was a decade ago 😁 janneaa.com/posts/hello-...
February 24, 2025 at 9:15 PM
janneaa.com
This boot loop also happened on my Garmin Forerunner 255. I got the watch to start with a master reset (2nd link). www.forbes.com/sites/andrew... forums.garmin.com/sports-fitne...
Garmin Issues Warning About Watch Boot Loop Bug
Garmin watch down or bricked? There's a nasty bug going around afflicting Fenix, Epix, Forerunner watches and more. Here's what you need to know.
www.forbes.com
January 28, 2025 at 4:12 PM
janneaa.com
DeepSeek-R1 seems like quite a good AI model. It's also possible to run it locally in the browser.
simonwillison.net Simon Willison @simonwillison.net · Jan 21
If you have a browser that supports WebGPU (like Google Chrome) you try out the DeepSeek-R1 model based on Qwen2.5-Math-1.5B directly in your browser!

It's a 1.28GB page load: huggingface.co/spaces/webml...
Screenshot of Spaces webml-community/deepseek-r1-webgpu" with "Running" status. Prompt is "Solve the equation x^2 - 3x + 2 = 0 A "View reasoning" dropdown shows this: To solve the quadratic equation (x^2 - 3x + 2 = 0), I'll start by factoring the left-hand side. I need two numbers that multiply to 2 and add up to -3. These numbers are -1 and -2. Next, I'll rewrite the equation as (x - 1)(x - 2) = 0. Using the zero product property, I'll set each factor equal to zero: x - 1 = 0 leads to x = 1. x - 2 = 0 leads to x = 2. Therefore, the solutions to the equation are x = 1 and x = 2. Below that a full solution is displayed: "Step 1: Factor the Quadratic We look for two numbers that multiply to +2 and add up to -3. These numbers are -1 and -2. x^2 - 3x + 2 = (x - 1)(x - 2) = 0 Step 2: Apply the Zero Product Property If the product of two factors is zero, at least one of the factors must be zero. x - 1 = 0 or x - 2 = 0 Step 3: Solve for x x = 1 or x = 2 Final Answer: 1 and 2
January 28, 2025 at 10:35 AM
janneaa.com
Let's give this Bluesky thing a try 🙂 Sure hope it stays better than most of the other social media sites these days.
January 26, 2025 at 7:51 PM