search

serilog-mssql / serilog-sinks-mssqlserver

A Serilog sink that writes events to Microsoft SQL Server and Azure SQL
Apache License 2.0
278 stars 148 forks source link

MSSQLSink LogEvent column to be varbinary(max) #477

Open asiridissa opened 1 year ago

asiridissa commented 1 year ago

It is nice if MSSQLSink can support compressed LogEvent column. Their could be a configuration to turn the compression on and off.

MSSqlServer supports Compress function to GZip data in SQL level. https://learn.microsoft.com/en-us/sql/t-sql/functions/compress-transact-sql?view=sql-server-ver16. Currently Binary columns a re not supported as a data type. image

ckadluba commented 1 year ago

Hi @asiridissa!

Thanks for getting in touch. We currently have no resources to implement this but we are always open for useful contributions.

Generally new features can be discussed in the discussions section. But i'll leave this issue open with type enhancement.

Best regards, Christian