All Posts

All Posts (536)

• 

  Published on

  2020-03-10 10:58 a.m.

  Authors

  koskila

  Tags

  remoteworkingwaysofworkingwfhworkingfromhome

  Top Tips To Survive Working From Home!

  Due to the outbreak of the Coronavirus, there's a sudden influx of people working remotely. As someone, who has only recently gone through the transformation from a regular office worker (with an assigned desk and all that classic stuff) to a full-time remote worker, I thought I could share some of my experiences on how to survive WFH (that's Working From Home for those of you who're even newer to this stuff than I am!) Introduction Up until recently, I used to work at Valo's Montreal office.

  Read more →
• 

  Published on

  2020-03-05 12:01 p.m.

  Authors

  koskila

  Tags

  aspnetcorerazor

  Adding new MVC/Razor items fails throwing an error about hostpolicy.dll

  This article describes how to fix the error " There was an error running the selected code generator: 'Failed to load the dll from \bin\Debug\netcoreapp\win-x86\hostpolicy.dll, HRESULT: 0x800700C1 An error occurred while loading required library hostpolicy.dll'" when you're adding a new scaffolded item (such as a Razor page or ASP.NET Core MVC Controller) in Visual Studio. Description Imagine this: You're developing your run-of-the-mill, basic, everyday ASP.NET Core web application.

  Read more →
• 

  Published on

  2020-02-27 11:26 a.m.

  Authors

  koskila

  Tags

  aspnetcoreauthenticationcnetcorenetcore3

  How to disable "Register" action in ASP.NET Core?

  Sometimes you'll need the default identity for your ASP.NET Core application, but want to disable the registration of new users. Sounds pretty basic, right? However, there's actually no easy switch you can just flip to enable or disable said functionality. I went through a lot of different articles and ideas by other people. Most of them involved fiddling with IdentityController, creating new scaffolded pages, adding new Actions with redirection code, and who knows what else...

  Read more →
• 

  Published on

  2020-02-26 11:48 a.m.

  Authors

  koskila

  Tags

  azureazuredevopsdevopsnuget

  Fun with Azure DevOps NuGet package versioning!

  This article will briefly explain the different NuGet package versioning schemes - both automatic and manual - available. Then we'll take a look at how to implement a nifty, and quite frankly, downright elegant automatic versioning scheme for your NuGet packages. Okay - returning from quite a trip down another rabbit hole, I think it's a good time to document some of my findings in regards to Azure DevOps NuGet package versioning !

  Read more →
• 

  Published on

  2020-02-26 11:40 a.m.

  Authors

  koskila

  Tags

  loggingnetcorenetcore3

  Adding Debug listeners to your console application fails in .NET Core

  Every now and then comes the need to write your console output to a log file. There's a simple way to do this in .NET Framework, and quite a few online articles detailing a borderline one-liner on how to do achieve it: Adding a log file listener(s) by calling Debug.Listeners - something like this: var tr1 = new TextWriterTraceListener(System.Console.Out); Debug.Listeners.Add(tr1); var tr2 = new TextWriterTraceListener(System.IO.File.CreateText("log.txt")); Debug.Listeners.

  Read more →
• 

  Published on

  2020-02-18 7:43 a.m.

  Authors

  koskila

  Tags

  microsoftexceloffice

  How to change Excel CSV delimiter?

  This article will explain how you can change the Excel list delimiter for your CSV (or other) file exports. Because it isn't always a comma. And setting the delimiter won't escape or strip the same characters in the values, so it'll mess up your data quite easily. Recently, I needed to find a way to import data from an old Excel file to a custom-coded system that could import CSV files. However, the data was fairly non-sanitized - containing commas, semicolons, and other weird characters.

  Read more →
• 

  Published on

  2020-02-11 9:14 a.m.

  Authors

  koskila

  Tags

  ms-sql-serversqlservermanagementstudio

  How to connect to your local MSSQL server using SSMS?

  Every now and then you run into a situation, where you really need to run some SQL against your local development database. That database, at least in my case, is hosted on your local SQL Server Express. Connecting to a local SQL Server should be a walk in a park, right? Eh, well... While using a connection string to connect to said DB is easy, you can't do that with the SQL Server Management Studio. I wish you could, but hey - it is what it is. There's a couple of ways to connect, though!

  Read more →
• 

  Published on

  2020-02-05 12:12 p.m.

  Authors

  koskila

  Tags

  microsoftstreamoffice365video

  Office 365 video migration to Office Stream imminent - Get Ready!

  While this post will mostly be about the highly topical migration from Office 365 Video to Microsoft Stream, there's also a fair amount of rambling about Microsoft's partner strategy and a bit of history included. I'm starting with the main stuff and then proceeding to the ranty parts, so just skip the last 75% of the post if you don't care about that kind of stuff! On to the content, then !

  Read more →
• 

  Published on

  2020-01-29 5:45 a.m.

  Authors

  koskila

  Tags

  androidcustomromlenovolineageos

  How to use TWRP to flash an Android device that refuses to boot to TWRP?

  Last Christmas holiday I was tasked by older relatives to fix an Android tablet they had bought. One of those absolutely useless, 100€ devices that can't really run any apps, and struggle to even start. My first proposition was to return the device - but it was already past the return window. Lenovo 's bloated nightmare version of an Android was likely the biggest reason for slowness.

  Read more →
• 

  Published on

  2020-01-22 8:01 a.m.

  Authors

  koskila

  Tags

  azureazurefunctions

  Azure Functions host quits with "The system cannot find the file specified"

  So, another interesting issue I ran into when developing Azure Functions locally. What an endless bag of funsies! 😁 This time, the issue was simple but infuriating - my Azure Functions host would just silently close when debugging: none of the breakpoints would be hit, and no information would be logged anywhere. Azure Functions Core Tools (2.4.432 Commit hash: 3371a87e0fce2aa35986c0de8e77d5d618163b91) Function Runtime Version: 2.0.12332.

  Read more →
• 

  Published on

  2020-01-22 5:38 a.m.

  Authors

  koskila

  Tags

  azureazurefunctions

  How to extract more information out of your Azure Functions host failing silently?

  I don't know about you, but it's happened to me a few times: fire up your Azure functions project, hit F5 to start debugging project builds without errors, Azure Functions host starts... And shuts down right away. This article has a few quick and simple tips on how to extract a bit more information from the Azure Functions host (func.exe) , when it's just silently failing. This means by default you won't get any information about what's going wrong.

  Read more →
• 

  Published on

  2020-01-14 9:13 p.m.

  Authors

  koskila

  Tags

  chmodwordpress

  An easy fix for WordPress media uploads failing after a year/month change

  This article explains one possible fix to a situation, where your pictures in WordPress fail to show up. In this particular case, uploading, editing and even selecting pictures for your articles works - just displaying them doesn't work. Alternatively, programmatic access might fail as well: in my case, ShortPixel reported an error "There was an error and your request was not processed: Could not download the file (404 Not Found)".

  Read more →
• 

  Published on

  2020-01-09 3:04 a.m.

  Authors

  koskila

  Tags

  azuretls

  App Service refuses connections with error: "No connection could be made because the target machine actively refused it"

  This blog post describes a very specific fix to a very specific issue. In a software project that consisted of a desktop client application and some APIs hosted on Azure, we ran into an error where some connections to APIs would fail with an error like this: No connection could be made because the target machine actively refused it. What gives?

  Read more →
• 

  Published on

  2019-12-31 7:00 p.m.

  Authors

  koskila

  Tags

  newyearsresolutionyearreview

  2019 - Year Review (200th post on this blog!)

  When I started this blog in 2015 as a place to stash my, eh, thoughtful workarounds , I didn't think I'd ever hit 200 live articles (with another hundred still in draft mode). Or that I'd get half a million people reading them in a year! Man, I didn't know either one of these things when I was writing my 2018 review , which feels like was just a moment ago.

  Read more →
• 

  Published on

  2019-12-30 7:52 a.m.

  Authors

  koskila

  Tags

  obfuscarpowershell

  Obfuscar 2.0 errors with loading types from assembly

  I plugged Obfuscar into my build pipeline (the easiest configuration ever, by the way) because I needed to obfuscate a DLL I was going to push as a NuGet package. The DLL was obfuscated without changing any of the public APIs, Classes or Parameters - only internal stuff was scrambled. Simple stuff. Presumably.

  Read more →
• 

  Published on

  2019-12-26 12:11 p.m.

  Authors

  koskila

  Tags

  cloudflaregutenbergwordpress

  WordPress blog article edit mode: No Tags or Categories visible?

  This post describes a couple of useful solutions or workarounds for an awkward situation, where you can't manage the metadata of your articles on WordPress. This hampers greatly your ability to organize your posts - and if you're using WordPress like I'm using, also lowers the visibility of your new articles (I'm using the tags as hashtags when sharing to social channels)! We don't want that. But what's actually causing it?

  Read more →
• 

  Published on

  2019-12-19 1:30 p.m.

  Authors

  koskila

  Tags

  aspnetcoreauthenticationazure-adoauth

  How to resolve AADSTS90056 - "The endpoint only accepts POST requests. Received a GET request."

  This post details my very simple solution to an extremely unnecessary and kind-of simple error that I encountered when logging into SharePoint. However, you could run into the same error after configuring Azure Active Directory authentication to a custom web application. AI-powered summary: How to resolve AADSTS90056 error for Azure AD apps The AADSTS90056 error means that the resource principal (the app or service you’re trying to access) was not found in the Azure AD tenant.

  Read more →
• 

  Published on

  2019-12-10 9:45 a.m.

  Authors

  koskila

  Tags

  delveblogsmicrosoftswaysharepointblog

  Classic SharePoint blogs are going away - what next?

  So the interesting news is not over - Microsoft recently announced that their personal blogging platform for Office 365, Delve Blogs, is getting retired. Now it turns out Classic SharePoint blogs are also getting cut. This leaves some organizations in a bit of a tough spot - what to use for blogging from now on? In this article, I'm taking a look at what brought us here, and thinking about our next steps from here on forward. Background Okay, then - what brought us here?

  Read more →
• 

  Published on

  2019-12-04 9:47 a.m.

  Authors

  koskila

  Tags

  azuredevopsyaml

  How to find out which WebDriver version is installed on an Azure DevOps build machine using YAML?

  Uh, okay, well. So this is where you should just RTFM (that's along the lines of "check the documentation" for those uninitiated in the world of unnecessary abbreviations). But as we've found out before, Microsoft's documentation on the agent's installed software isn't always up-to-date . That's why I added this simple snippet on my pipeline to figure out which version of the browser AND the webdriver are installed on the machine.

  Read more →
• 

  Published on

  2019-11-28 5:21 a.m.

  Authors

  koskila

  Tags

  delvedelveblogsoffice-365pnppowershell

  How do you migrate your Delve Blogs content to Modern SharePoint?

  You might've heard the news - Delve Blogs are on the way out, leaving your users without a blogging platform on Office 365, and their data homeless. And by homeless, I mean deleted pretty soon. And by pretty soon I mean really soon. Might be a good time to start thinking about storing it somewhere else instead!

  Read more →
• 

  Published on

  2019-11-27 6:18 a.m.

  Authors

  koskila

  Tags

  delvedelveblogsoffice-365pnppowershell

  How to export your Delve blogs content?

  The news is out - Delve Blogs will be axed, leaving your users without a blogging platform on Office 365, and their data homeless. And by homeless, I mean deleted. Might be a good time to start thinking about storing it somewhere else instead! This post is the second post in my impromptu, Delve Blogs -themed blog series: Part 1: Delve Blogs getting deprecated – what do? Part 2: How to export your Delve blogs content?

  Read more →
• 

  Published on

  2019-11-26 8:29 a.m.

  Authors

  koskila

  Tags

  delvedelveblogsmicrosoftoffice-365

  Delve Blogs getting deprecated - what do?

  Last week, Microsoft sent a surprise email to a number of customers. Delve blogs - the hated & loved self-serve internal blogging platform on Office 365 is getting axed. It doesn't really come as a surprise at this point - the service was first announced in 2014, and launched to some hype and appreciation (especially due to the new CMS - authoring canvas - which was a lot of fun compared to Classic SharePoint!) but has pretty much faded away after that.

  Read more →
• 

  Published on

  2019-11-26 4:07 a.m.

  Authors

  koskila

  Tags

  azure-admsdn

  "Unable to service request" when trying to log into a Microsoft website

  Okay - so this one is going to be a simple blog post. I'll be explaining an apparent fan favorite! Namely, MSDN forums , MSDN subscriber downloads or other Microsoft web properties are not letting you sign in, but rather throw the following error: Unable to service request Why do you get an error like this? How to resolve it? Background

  Read more →
• 

  Published on

  2019-11-25 1:06 p.m.

  Authors

  koskila

  Tags

  mvpawardmvpbuzz

  Awarded MVP for Office Development

  Late Friday night a couple of weeks ago, I got an interesting and a bit surprising email from Microsoft. Flabbergasted, I tweeted this right after: Wait, WHAT? First of all, when did #Microsoft learn to write proper Finnish, second of all, HOW DID THIS HAPPEN? :D I'm genuinely at a loss of words. Just... Thanks everyone for sparring and pushing me - I'll do my best to be worthy of y'alls trust! 🤩 #MVPBuzz #MVP pic.twitter.com/wn3EMKfrvA — Antti K.

  Read more →
• 

  Published on

  2019-11-21 8:48 p.m.

  Authors

  koskila

  Tags

  cnetcorenetcore3nuget

  How to solve 'DbContextOptionsBuilder' does not contain a definition for 'UseSqlServer' error in .NET Core?

  This is another, kind of a classic and simple solution to a fairly simple problem: How to fix it, when your DbContextOptionsBuilder fails to take in your connection string and complains about UseSqlServer missing or whatever? AI-powered summary: Efficiently Solve ‘DbContextOptionsBuilder’ Error in .NET Core The ‘DbContextOptionsBuilder’ error in .NET Core arises when setting up DbContext. The ‘UseSqlServer’ method is not found during the build. The solution is to add the ‘Microsoft.

  Read more →