serilog-aspnetcore VS serilog-sinks-mssqlserver

This article really doesn't provide anything the Serilog documentation doesn't cover. Additionally, the log examples are pretty poor. For instance, there's never a good reason to explicitly throw a NullReferenceException.

Just a simple example I found on web https://github.com/serilog/serilog-aspnetcore/blob/dev/samples/Sample/Program.cs Remove line 21-22 and you have a plain usage of serilog without asp.net

What do you mean by "Microsoft Logger"? If this is Microsoft.Extensions.Logging, then you can just plug in Serilog and continue using standard ILogger interface.

Serilog is a structural logging library for.NET applications that can be used for adding some cool diagnostic features to your application. This library provides a huge collection of new logging related features that are not available in the .NET built-in logging framework. It allows developers to log their messages to hundreds of different destinations including files, the console, on-premises, and cloud-based log servers, databases, and message queues. It also has native support of producing log output in plain text and JSON formats. It supports rich integration with .NET Core including ASP.NET Core. You can read the full list of features available here.

You probably want to use a logging framework to configure where you logs end up. I recommend taking a look at serilog.

Logging is built-in and you get access to structured logs from the ASP.NET Core host itself to your application. With tools like Serilog, you can extend your logging easily and save your logs to file, Azure, Amazon or any other output provider. You can configure verbosity and log levels via configuration (appsettings.json by default), and you can configure log levels by different categories.

Serilog.Sinks.MSSqlServer – To write log events to Microsoft SQL Server

To see complete SQL Server sink JSON configuration check out this.