All Posts

All Posts (543)

• 

  Published on

  2020-10-27 7:48 p.m.

  Authors

  koskila

  Tags

  entityframeworkentityframeworkcorems-sql-server

  "Conversion overflow" when reading numeric data from MS SQL database using Entity Framework

  This article explains how to fix a weird situation where your .NET application utilizing EF ( Entity Framework or Entity Framework Core ) simply crashes without any way to recover or catch the Exception. You only get errors somewhere along the lines of "conversion overflow". Ah - what a fun little issue! No way to recover, no fallbacks, unusable callstacks. Oh, speaking of which - what was the error, exactly?

  Read more →
• 

  Published on

  2020-10-21 10:48 a.m.

  Authors

  koskila

  Tags

  azurefunctions

  How to configure Azure Function's startup

  Azure Functions use dependency injection, and that allows us to define all kinds of prebuilt or custom-built services as being available for our functions really easily. This is a really easy way to initialize scoped resources to be used in your different functions... But how do you actually configure them in an Azure Functions App? Problem Okay, a step back - there's a bit of a problem that we need to resolve before we can proceed with the configuration.

  Read more →
• 

  Published on

  2020-10-14 8:25 a.m.

  Authors

  koskila

  Tags

  git

  How to list your git stashes

  Long story short, yes, I really did have to google this, and since top results seemed to give pretty unclear (or even wrong) answers, I decided to document it for myself. Maybe it'll be helpful to someone else too! And just to state the obvious: I'm using GitHub Desktop for most of my mandatory Git stuff, but whenever I have to run any git commands, I run Windows PowerShell (git exe is added to PATH variable). Solution Well, it's actually very, VERY simple.

  Read more →
• 

  Published on

  2020-10-05 12:31 p.m.

  Authors

  koskila

  Tags

  pnppowershellpowershell

  How to fix "System.InvalidOperationException: PowerShell Gallery is currently unavailable."

  This article explains how to fix an issue when updating a module in PowerShell. The error is something along the lines of: " System.InvalidOperationException: PowerShell Gallery is currently unavailable. Please try again later." The whole error looks something like the one below, although you can probably get it for many different commandlets. Failed updating module 'SharePointPnPPowerShellOnline' version 3.19.2003.0. Update the module and then try again.

  Read more →
• 

  Published on

  2020-09-29 10:26 a.m.

  Authors

  koskila

  Tags

  microsoft365microsoftlists

  How to change Microsoft Lists language?

  I recently started playing around with Microsoft Lists. What a fun and friendly tool - makes SharePoint lists far more approachable offering a great editing experience, easy sharing, and hopefully in just a bit, awesome integrations and great mobile app (I mean, there's iOS... But who has an iPhone in this day and age? 😉 However, as is usual in my tech endeavors, I immediately ran into an issue.

  Read more →
• 

  Published on

  2020-09-21 6:50 p.m.

  Authors

  koskila

  Tags

  pnppowershellsharepointsharepoint-online

  App authentication woes on SharePoint (Token request failed. The remote server returned an error: (401) Unauthorized.)

  This article explains how to get rid of sudden and unexplainable 401 Access Denied errors when trying to authenticate against a fairly fresh Microsoft 365 / SharePoint Online tenant. This issue seems to be caused by a long-ish project to finally retire ACS - Azure Access Control service) on SharePoint ( it's retired everywhere else already! ) Note : This might still be an updating story, as the situation with ACS is definitely... Developing. Yeah, let's call it that. It's a developing situation.

  Read more →
• 

  Published on

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

  Authors

  koskila

  Tags

  azure-advisual-studio

  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

  licensingscamspotify

  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. But let's take a closer look at what's going on with this one, then!

  Read more →
• 

  Published on

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

  Authors

  koskila

  Tags

  aadazure-ad

  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

  visual-studiovisualstudio2019

  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

  ef-coreentityframeworkcoresqlsql-query

  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

  ef-coreentityframeworkcore

  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

  modernsharepointsharepointsharepoint-online

  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

  ef-coreentityframeworkcore

  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

  azure-adazureportal

  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

  azureazurefunctions

  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

  ef-coreentityframeworkentityframeworkcorenetcore

  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 →