All Posts

All Posts (562)

• 

  Published on

  2020-09-16 1:55 p.m.

  Authors

  koskila

  Tags

  AzureADVisualStudio

  How to leave an Azure AD tenant?

  This article explains how to fix your account, whenever it gets completely FUBAR due to your account being added as a guest in another AAD organization. And this might happen in multiple different situations - my most typical woe is Visual Studio's Cloud Explorer, which stops showing me my subscriptions due to authentication against the other organizations failing.

  Read more →
• 

  Published on

  2020-09-10 2:38 a.m.

  Authors

  koskila

  Tags

  LicensingScamSpotifyOpinion

  Is Lifetime Spotify Premium legit?

  This article describes another fishy online offering I ran into, Spotify Premium Lifetime subscription . Long story short, it's shady, but not necessarily a scam, per se. I definitely wouldn't call it legit either, though. Depending on the calibration of your moral compass, it might even be worth it, although definitely not recommended. Let's take a closer look at what's going on with this one. I tested multiple real offers, so this is not just theory.

  Read more →
• 

  Published on

  2020-09-03 8:11 p.m.

  Authors

  koskila

  Tags

  AADAzureAD

  AADSTS50011 - The resource principal named was not found in the tenant | An easy fix!

  Another day, another variant of AADSTS50011! With a lot of apps and web services using Azure Active Directory for authentication, you're bound to run into issues, right? Ah well, one would hope to avoid them. But at least this one is usually easy to fix! Let's first take a closer look at the different versions of the error you might face, and then see how we can fix or avoid them altogether! AI-powered summary: AADSTS50011 - How to resolve the resource principal not found error in Azure AD ...

  Read more →
• 

  Published on

  2020-09-01 8:05 p.m.

  Authors

  koskila

  Tags

  MicrosoftMSDN

  How to fix an AADSTS50196 error on Microsoft web properties?

  This article explains how to fix error with error code AADSTS50196. This issue usually comes up with an error message somewhat like "The server terminated an operation because it encountered a client request loop." The error seems to be popping up more and more often. No worries - it wasn't caused by you! It is, in fact, an unintended side effect of a security hardening feature in some browsers, and some outdated configuration on Microsoft's end.

  Read more →
• 

  Published on

  2020-08-26 7:41 p.m.

  Authors

  koskila

  Tags

  MicrosoftMSDN

  The MSDN Downloads / Subscriber links

  This article serves as a simple glossary of important MSDN Subscriber links that I always forget - links that Microsoft keeps updating, that is! I'll be updating the post as need be :) And yes, I do feel a little bit ridiculous about creating an actual article about something as simple as a list of links to stuff that should be easily discoverable by any search engine. But I suppose it is what it is.

  Read more →
• 

  Published on

  2020-08-17 5:50 a.m.

  Authors

  koskila

  Tags

  HtaccessPHPWordPress

  Fixing WordPress "Post-processing of the image failed likely because the server is busy or does not have enough resources. Uploading a smaller image may help. Suggested maximum size is 2500 pixels." error

  This article will go through different solutions for fixing issues with uploading pictures to your WordPress Media Library. There are plenty of reasons that could cause this issue - and a couple of different ways to run into it. But fear not! I'll be proposing a few different ways to fix the issue in your installation. And by "a few" I mean 10. Or more, if I have updated the list after writing this paragraph!

  Read more →
• 

  Published on

  2020-08-13 2:16 a.m.

  Authors

  koskila

  Tags

  VisualStudio2019VisualStudio

  How to restore lost windows in Visual Studio?

  This article explains how to restore any hidden windows in Visual Studio without resetting your whole window layout, by using a common keyboard shortcut. Problem We've all been there - you're opening a new window in Visual Studio, but your keyboard shortcut or clicking the item in the menu simply seems to do nothing. The window doesn't show up anywhere. Reason The reason for this (most of the time) is simple: you have the window popped-up and located outside your screen.

  Read more →
• 

  Published on

  2020-08-03 9:26 a.m.

  Authors

  koskila

  Tags

  GadgetWorxlandroid

  Worx Landroid L2000 (WR155E) - an honest review

  In this article, I will be sharing my perspective and experiences with Worx Landroid L2000 - an autonomous lawn mower that I've had for about 2 summers now. Hopefully, I'll be able to help someone else make an informed decision about getting a puppy like this. Anyway - a step back, the 10k-feet view first, as usual. Robot lawn mowers are slowly becoming a commodity, but choosing the right one is still tough.

  Read more →
• 

  Published on

  2020-07-27 8:49 p.m.

  Authors

  koskila

  Tags

  AzureFunctionsEntityFrameworkCore

  How to resolve "Microsoft.Data.SqlClient is not supported on this platform." in an Azure Function App?

  Hah - another interesting one. This article describes how to resolve an error along the lines of " Microsoft.Data.SqlClient: Microsoft.Data.SqlClient is not supported on this platform. ", thrown by the Azure Functions host. Apparently, you can run into this issue either on your local development machine or even in Azure. AI-powered summary: Quick Fixes for Azure Function App SQL Errors Encounter the “Microsoft.Data.SqlClient not supported” error in Azure Function Apps?

  Read more →
• 

  Published on

  2020-07-21 6:45 p.m.

  Authors

  koskila

  Tags

  DockerHomeAssistant

  Gotchas when configuring Home Assistant on Docker on Windows

  What a nice headline, right? 😅 One day, I thought I'd give Home Assistant a try! And obviously, I couldn't just make things easy and run it in a Linux virtual machine or my Raspberry Pi - instead, obviously, I decided to run it on Windows 10! And obviously, I'd use Docker for it. And of course, not just Docker, but docker-compose. Whatever that is. I don't know - it's the first time I'm trying out Docker. Or Home Assistant! Another learning experience coming in, am I right?

  Read more →
• 

  Published on

  2020-07-16 1:37 p.m.

  Authors

  koskila

  Tags

  AzureWindowsUpdate

  Enabling local cache for an Azure App Service

  This article explains one easy way for you to improve the performance and uptime of your Azure App Service. I'll explain a simple but kind-of-hidden and surprisingly badly documented feature - Azure App Service Local Cache, that is - which might make a huge difference. It sure did for me! Since it's such a no-brainer, I'm kind of half expecting everyone else to already have known about this, but since nobody told me about it, I'm going to document it for future use.

  Read more →
• 

  Published on

  2020-07-08 6:19 a.m.

  Authors

  koskila

  Tags

  EntityFrameworkCoreSQLEFCoreSqlQuery

  How to verify connection to the database in Entity Framework Core?

  This article explains how to perform a very simple and lightweight database connection test for an existing database context.

  Read more →
• 

  Published on

  2020-06-30 7:23 a.m.

  Authors

  koskila

  How to resolve "Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot insert explicit value for identity column in table when IDENTITY_INSERT is set to OFF"

  Okay, okay - another super simple thing that I messed up, fixed, and decided to document :) This time I messed up a simple operation in Entity Framework Core operation on a simple entity, and hopefully I'll save someone else some trouble! Onwards to the issue, then! Problem So when you're trying to insert stuff into your database - somewhat like shown in the example below: var entity = new MyEntity(){ Id = 1337, Name = "My Entity" }; _ctx.MyEntities.Add(entity); _ctx.

  Read more →
• 

  Published on

  2020-06-24 7:18 p.m.

  Authors

  koskila

  Tags

  EntityFrameworkCoreEFCore

  How to resolve persistent "Build started... Build failed." when trying to run Entity Framework Core commands?

  This time, I'm happy to present you perhaps the simplest way of fixing an annoying and persistent issue with a misleading error message! Wait, does that sound familiar? It's almost like that's what half of my articles are about... Anyway, I was happily going my way about creating a couple of new fields to an entity and then scaffolding my changes to a new migration using Entity Framework Core's Add-Migration, but this happened: Build started... Build failed. "Oh", I thought.

  Read more →

• Published on

  2020-06-16 5:27 a.m.

  Authors

  koskila

  Tags

  ModernSharePointSharePointOpinionSharePointOnline

  SharePoint Home Sites - a Game Changer?

  This topic seems to be on everyone's mind right now: SharePoint Home Sites. They're finally rolling out (again). Or maybe even rolled out, in case this article ends up late in my publishing queue! But what are they? How do you create SharePoint Home sites? How do you best use them in your organization? To take a step back, let's first take a step upwards - to get the 1000-feet view! Getting the big picture - why is Microsoft doing this stuff in the first place?

  Read more →
• 

  Published on

  2020-06-10 11:27 a.m.

  Authors

  koskila

  Tags

  EntityFrameworkCoreEFCore

  How to resolve another "An error occurred while updating the entries" exception in Entity Framework Core

  This article offers yet another possible fix to an issue, where trying to call SaveChanges() in Entity Framework Core throws a pretty generic "An error occurred while updating the entries"-exception, and you're left wondering what in tarnation is wrong this time. And admittedly, that's a really generic error, so it could pretty much be whatever. But in this article, I'll go through one possibility - hopefully, it helps!

  Read more →
• 

  Published on

  2020-05-28 2:08 p.m.

  Authors

  koskila

  Tags

  AzurePortalAzureAD

  How to find out the ID of your Azure AD tenant?

  This article explains in extremely short way, how to fetch your Azure Active Directory tenant's Directory ID (also known as Tenant ID). Let's make it short and sweet, because quite frankly, it is really simple! Solution Option 1: Use whatismytenantid.com for finding your tenant/directory id: Quick solution - works (at least) for all standard tenants: Navigate to https://www.whatismytenantid.com/ Enter the domain associated with your Azure AD instance (often like contoso.onmicrosoft.

  Read more →
• 

  Published on

  2020-05-19 9:32 a.m.

  Authors

  koskila

  Tags

  AzureAzureFunctionsDevEnvironment

  How to resolve error "Insufficient memory to continue the execution of the program." when debugging Azure Functions locally?

  This article describes a solution to an error "Insufficient memory to continue the execution of the program." I was debugging an Azure Function locally and ran into it - it stopped my Azure Function from starting at all. So, this is what I got: Insufficient memory to continue the execution of the program. Ohh... kay..? My development machines have plenty of RAM, surely enough to run an Azure Function!

  Read more →
• 

  Published on

  2020-05-12 2:43 p.m.

  Authors

  koskila

  Tags

  EntityframeworkEntityFrameworkCoreNetCoreEFCore

  How to implement multiple Connection Strings for one DbContext in EF Core?

  Recently, while building an app service to host a .NET Core API, I had to implement the logic for using both Read-Only and Read-Write Database Contexts for Entity Framework Core. In this particular case, it was the same database - just different contexts, because depending on the location of the app service the app was deployed in, read and write operations might actually go to different database instances, That's really easy, right? Well... Yes and no.

  Read more →
• 

  Published on

  2020-05-07 6:30 p.m.

  Authors

  koskila

  Tags

  SQLSqlServerManagementStudioMsSqlServerSqlQuery

  How to clean up duplicates from MS SQL Database?

  This article explains how to query and remove duplicate entries from a Microsoft SQL database using T-SQL. The same model works both for Azure Databases (in Azure SQL Query Editor) and databases on MS SQL Server (using SSMS - SQL Server Management Studio). I had to do this a while back due to a bug in an API creating multiple entities with the same content - save for the Identity field. Fun! Background Why bother? That's a (somewhat) valid question.

  Read more →
• 

  Published on

  2020-04-30 10:57 a.m.

  Authors

  koskila

  Tags

  ApplicationInsightsAzureAzureMonitor

  How to fix weird "Production Breakpoints" errors in an Azure App Service?

  This article describes a curious fix I found to an issue where Application Insights (seemingly) crashes your Azure App Service, leaving behind interesting, yet non-descriptive errors in the Application Event Logs. The actual symptoms might be your Azure app service just timing out with no errors being surfaced on the front-end. Frustrating. Problem Does your Azure App Service's event log look like this? Full of "Production Breakpoints" with weird errors about named pipes?

  Read more →
• 

  Published on

  2020-04-21 12:16 p.m.

  Authors

  koskila

  Tags

  CSharpEntityframeworkEntityFrameworkCoreEFCore

  How to get the EF Core Connection String?

  This article describes how to access and extract the connection strings from your Entity Framework (Core) database context objects. This is quite convenient if you need to display or log the connection string used for your current DbContext for some reason - or if you somehow form your DbContext objects dynamically, and need to verify which connection string you're using. I'm sure there are other use cases, too. You probably have an interesting one, if you landed on this page!

  Read more →
• 

  Published on

  2020-04-15 10:03 a.m.

  Authors

  koskila

  Tags

  MicrosoftTeams

  Tips on organizing an online conference using Microsoft Teams

  Writing this in a country under lockdown, it feels like every single conference in the world has either been canceled or switched to being online-only. And right now, that's definitely for the best! But it does pose quite a dilemma for those in charge of these events - how do you organize an event for potentially thousands of attendees, online? How do you foster great interaction between the audience and speakers? How do you encourage your attendees to mingle as well?

  Read more →
• 

  Published on

  2020-03-31 8:58 a.m.

  Authors

  koskila

  Tags

  PowerShellMicrosoftTeamsOfficeGroups

  How to fix a Teams team with no Owners?

  As Teams adoption grows (partially driven by the megatrend of digitalization, partially by the massive surge in working from home due to Covid-19), different problems managing Teams also become more obvious. The growth seems to have been largely organic. Teams and organizations are adopting the tools that best help them get their work done with little regard to how the tools are maintained and best used. Teams are often created as needed, and by whoever needs them.

  Read more →
• 

  Published on

  2020-03-25 11:05 a.m.

  Authors

  koskila

  Tags

  AspNetCoreAzureBlazor

  How to fix "HTTP Error 500.32 - ANCM Failed to Load dll"

  Yikes - ever ran into this error after deploying your ASP.NET Core web application to an Azure App Service? Yeah, me too. And when it's a production deployment, and the error didn't happen in test/QA environment, that's even more fun. This article describes a couple of ways to fix it, though. You wouldn't believe these 3 solutions to fix the error "500.32", and what they look like now! Oh heavens, what have I done with that subheading?

  Read more →