Skip to main content

Blog Archive

Every post on Dewiride Developer Blogs, newest first. Pick a year or a month to narrow it down, or page through them all.

Posts
1,085
Topics
132
Reading time
130 h
First post
Jun 2025

Posts 361–390 of 1,085 · November 6–7, 2026

Page 13 of 37

November 2026

802 posts

Saturday, November 7, 2026

16 of 94 posts

  1. 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.

  2. How 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. How 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.

  4. How 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.

  5. How 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.

  6. How 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.

  7. How 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.

  8. How 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.

  9. How 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.

  10. How 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.

  11. Fixed: 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.

  12. Fixed: 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.

  13. Fixed: 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.

  14. Fixed: 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.

  15. Fixed: 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.

  16. Fixed: "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.

Friday, November 6, 2026

14 of 99 posts

  1. 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.

  2. How 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.

  3. How 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.

  4. How 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. How 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.

  6. How 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.

  7. How 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.

  8. How 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.

  9. How 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.

  10. How 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.

  11. How 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.

  12. How 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.

  13. How 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.

  14. How 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.