November 2026
Every post published in November 2026, newest first. Pick a day to jump straight to it.
- Posts
- 802
- Topics
- 75
- Reading time
- 91 h
- Active days
- 15
Posts 361–390 of 802 · November 6–7, 2026
Page 13 of 27
Saturday, November 7, 2026
16 of 94 posts
How to Change the Regional Format in Excel for the Web (UK Dates)
Make Excel for the web read 02/10/2026 as 2 October: File → Options → Regional Settings → English (United Kingdom) → Change. Do it before you type or paste any dates.
4 min readHow to Rename an Excel Workbook in Excel for the Web
Rename a workbook without leaving Excel for the web: select its name in the title bar, type the new one and press Enter. OneDrive shows the new name straight away.
3 min readHow to Create a New Excel Workbook in OneDrive
Create a blank Excel workbook straight from OneDrive in the browser: Create or upload → Excel workbook opens it in Excel for the web, already saved in the folder you were in.
3 min readHow to Turn Dark Mode On or Off in OneDrive
Switch OneDrive for the web between dark and light mode from the Settings gear: one switch in the Settings pane, saved for your account and nobody else's.
3 min readHow to Create a Folder in OneDrive
Create a folder in OneDrive for work or school in the browser: Create or upload → Folder, name it, pick a colour, and open it, ready for your files.
3 min readHow to See How Many Licenses Are Available in Microsoft 365
Check how many licenses your organization has left in the Microsoft 365 admin center: Billing → Licenses lists every product with its available and assigned counts, before you add anyone.
4 min readHow to Unblock Sign-In for a User in Microsoft 365
Let a blocked user sign in again from the Microsoft 365 admin center: open the person, select Unblock sign-in, clear Block this user from signing in, save, and know how long it takes.
5 min readHow to Change a User's Manager in Microsoft Entra
Replace someone's manager in the Microsoft Entra admin center: Edit properties → Job Information → Manager → Edit, remove the current manager, pick the new one, then Save and check the result.
5 min readHow to Change a User's Department in Microsoft Entra
Change someone's department, and their job title with it, in the Microsoft Entra admin center: Edit properties → Job Information → Department → Save, then check the saved value.
5 min readHow to Show Job Title, Department and Account Enabled Columns in Microsoft Entra
Add Job title, Department and Account enabled to the All users list in the Microsoft Entra admin center with Manage view → Edit columns, so you can check everyone's role and sign-in status at a glance.
5 min readFixed: Excel Shows Only the Date After Adding a Time to a Date
=B6+TIME(1,0,0) should have shown 29/03/2026 01:00, but Excel showed only 29/03/2026. The time was there; the cell's Date format hid it. Here's how I checked, and the custom format that shows both.
7 min readFixed: Excel Total of Times Wraps Around After 24 Hours
SUM of my timesheet's time worked showed 12:15 instead of 60:15. The hh:mm format shows a time of day, so every 24 hours vanished. Here's what I checked and the [h]:mm format that fixed it.
7 min readFixed: Excel Shows Hours as 12:00 or 00:00 After Multiplying by 24
Multiplying a time by 24 should turn 3:30 into 3.5 hours, but Excel showed 12:00 and 00:00. The formula was right; the cell had inherited a time format. Here's how I found it and fixed it.
6 min readFixed: Excel Shows ######## (Hash Signs) for Overnight Shift Hours
Finish minus Start worked for every shift except the ones past midnight, which showed ########. The result was a negative time. Here's what I checked and the MOD formula that fixed it.
7 min readFixed: Excel Shows ######## (Hash Signs) Instead of Dates After Pasting
I pasted overtime rows into Excel for the web and every date turned into ########, while the formula bar showed 02/10/2026. Here's why Excel does that, what I checked, and the one-click fix.
6 min readFixed: "Only 1 item can be selected" When Changing a User's Manager in Microsoft Entra
Changing someone's manager in the Microsoft Entra admin center, I ticked the new manager and got Only 1 item can be selected, with Select greyed out. The old manager was still selected. Here's the fix.
6 min read
Friday, November 6, 2026
14 of 99 posts
How to Connect a .NET C# Web API to a MySQL Database — Part 5: Production Checklist for the MySQL Connection
Get a .NET C# Web API and MySQL 9.7 ready for production: verify the server's certificate with VerifyFull, give the app an account that can't drop tables, stop a burst of requests from crashing the process, size the connection pool, and finish with a checklist.
57 min readHow to Set Up and Run the Inventory and Orders API for .NET C# and MySQL
You've downloaded the Inventory and Orders API source code. Here's what to do next: unzip it, create the passwords, start MySQL in Docker, create the tables, run the API on your computer and place your first order, with what each step should print.
21 min readHow to Log the Database Settings When an ASP.NET Core App Starts
Log the server, the database, the TLS mode and the pool size at startup, without ever including the password, and warn if the server's identity isn't checked. A small LoggerMessage class, with real output from .NET 10 and MySql.Data.
5 min readHow to Raise the Minimum Threads of the .NET Thread Pool
The .NET thread pool adds threads slowly past its minimum, so blocking code can starve it. Raise the minimum with an MSBuild property, an environment variable or code. It stopped a real crash, and here's what it costs. Real numbers from .NET 10.
5 min readHow to See Thread Pool Starvation with dotnet-counters
When blocked requests starve the .NET thread pool, threads grow by about two a second and work queues up. dotnet-counters shows both, live or in a file. A real run against an API with MySql.Data, up to the moment it crashed.
5 min readHow to Put a Timeout on an ASP.NET Core Health Check
Health checks have no timeout by default, so /health/ready took 64 seconds against an unreachable MySQL server. Set one with AddCheck or, for AddDbContextCheck, through HealthCheckServiceOptions. Real output from .NET 10.
5 min readHow to Use AddDbContextPool with MySQL in EF Core
AddDbContextPool reuses DbContext objects, which is a different thing from the connection pool. I swapped it in on a real API with Oracle's provider and measured no difference. Here's how to do it, when it helps, and what to watch for. Real numbers.
4 min readHow to Run EF Core Migrations with a Different Database Account
Your app's account shouldn't be able to change tables, so dotnet ef needs another. Give it one with an environment variable or --connection, in bash and PowerShell. A real migration, refused and then applied. Real output from EF Core 10 and MySQL 9.7.
6 min readHow to Run an ASP.NET Core App as Production on Your Machine
dotnet run --no-launch-profile starts an ASP.NET Core app as Production, with no user-secrets and no developer pages. See what changes, what to check, and why setting ASPNETCORE_ENVIRONMENT alone may not work. Real output from .NET 10.
5 min readHow to Pass a Connection String with an Environment Variable in .NET C#
ConnectionStrings__Inventory in the environment overrides appsettings.json and user-secrets, with no code changes. Set it in bash, zsh and PowerShell, see which value wins, and keep it out of your shell history. Real output from .NET 10.
5 min readHow to Write JSON Logs in ASP.NET Core
AddJsonConsole makes ASP.NET Core write one JSON object per log entry, which log tools can search by field. Turn it on outside Development and keep plain text for yourself. Real output from .NET 10.
4 min readHow to Limit the Request Body Size in ASP.NET Core
ASP.NET Core accepts a request body up to about 28.6 MB by default, which is far more than most APIs need. Lower it in code, and test it with a body that's too big. appsettings.json doesn't work for this. Real output from .NET 10.
4 min readHow to Rate Limit an ASP.NET Core API by Client IP Address
Give each client address its own limit in ASP.NET Core, answer 429 with a Retry-After header, and keep health checks out. Includes the trap behind a reverse proxy. Real output from .NET 10.
5 min readHow to Limit Concurrent Requests in ASP.NET Core
ASP.NET Core's concurrency limiter lets a set number of requests run at once, queues some more, and refuses the rest, without holding a thread for those waiting. A small example, then the real use: protecting a database connection pool. Real output from .NET 10.
5 min read