One year ago I wrote a series of posts about RabbitMQ and how to implement a publisher and a consumer. Now we'll see how to enable the TLS protocol on RabbitMQ, that is high recommended when the server is published on internet and the communication between the server and the clients must be encrypted. The... Continue Reading →
Dinamically grouping in T-SQL
Extracting, manipulating and presenting data from a SQL database could be a complicated operation, expecially if we talk about business intelligence, reports and graphics for the final users. If we couldn't use a BI tool and we need to write extraction queries manually, we could have some problem to write complex queries. Writing a query... Continue Reading →
Local functions in C# 7
The release of C# 7 brought a lot of useful features and constructors and one of that are the local functions. Before of these, when we had to provide a functionality to a class method we had to use a private class method and than call it. This is a common approach but in some... Continue Reading →
Javascript code refactoring with Visual Studio 17
As we have seen in the previous post, Visual Studio 2017 have introduced a lot of code refactoring tools for C# and other languages like javascript. We can customize these options as we prefer and, for some aspects, define the rules for Javascript formatting is most important than with C# because with the first one... Continue Reading →
C# code refactoring with Visual Studio 2017
With the release of Visual Studio 2017 and updates, code refactoring helpers of C# projects are strongly improved and the refactoring activities has become easier. The intellisense has default rules that, normally, are the most used and recommended for the developers, but fortunately we have the ability to change these settings as we prefer. We... Continue Reading →
Logging Entity Framework SQL queries
Often, when we write complex entity framework queries we would want to check how the translated query looks like or simply we would want to monitor the efficiency of it. If we have SQL Server Management Studio, we can leverage SQL Profiler to track all the queries on a specific database: This is not very... Continue Reading →
Configure and analyze Application Insight logs of an ASP.NET Core application
Application insight is an Azure monitoring tool that we can use to inspect the behaviours of .NET application. Based on the logs and the exceptions, it's collect and categorize the datas, that are available for analysis by the developers who want to understand what is the cause of an anomaly or simply know the healty... Continue Reading →
Exposing ML.NET features with a typed C# service
As we have seen in the previous post, in order to use ML.NET we have to configure the pipeline with all the operations that we need to do to transform our dataset and the algorithm that we want to use. In my opinion this syntax is rather verbose and of course has to be repeated... Continue Reading →
Training, prediction and evaluation with ML.NET
Train a ML.NET algorithm is the activity that we need to do when we want to prepare and algorithm to predict some values. As we'll see we have to prepare the pipeline with some operations that will be propedeutic to the training, like load the dataset, convert alphanumeric colums and so on. Now that we... Continue Reading →
Choosing an ML.NET algorithm
A tipical question when we approach a machine learning problem is: what is the algorithm that fits better in my dataset? In the previous post we have seen the possible classifications for the ML.NET algorithms and this is the first step to restrict the possible choices. Now we can make considerations about what are our... Continue Reading →