Posts from February 2020

Posts from February 2020 (6)

• 

  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 →