Posts from May 2020

Blog posts published in May 2020

← Back to all posts

Posts from May 2020 (4)

Published on

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

koskila
Tags

azure-ad azureportal

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

azure azurefunctions

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-core entityframework entityframeworkcore netcore

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

ms-sql-server sql sql-query sqlservermanagementstudio

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 →