The Essence and Configuration of AWS Virtual Private Cloud

Amazon Web Service environment is a fully digital experience of a typical brick-and-mortar data center. All components, such as firewalls or load balancers, are fully digitalized. Likewise, all of the services that AWS offers, such as Elastic Compute servers, databases, or Lambda functions live within that ecosystem.

When running any type of service within Amazon Web Services, it is important to understand the concept of the Virtual Private Cloud (VPC). It tightens security around your services and helps with communication between multiple services.

CodingSight - AWS Virtual Private Cloud: the Essence and Configuration
Read More

ML{.NET} Image Classification

One of the best scenes from Silicon Valley is Jian Yang demoing his “Hotdog, not hotdog” application. In this article, we will build our own “Hotdog, not hotdog” solution using ML.NET. After all, who would not want to determine if that dish is, or is not a hot dog? Just take a picture, upload it to the web or desktop application, and get results with almost 90% certainty in a second.

Although some may say this is not a very useful application, it is a fun way to explore another machine learning concept through ML.NET. I covered installing and getting started with ML.NET in Visual Studio in my previous article, so refer to it if you missed it.

ML{.NET} Image Classification
Read More

Is SQL DISTINCT Good for Removing Duplicates in Results?

Is SQL DISTINCT good (or bad) when you need to remove duplicates in results?

Some say it’s good and add DISTINCT when duplicates appear. Some say it’s bad and suggest using GROUP BY without an aggregate function. Others say DISTINCT and GROUP BY are the same when you need to remove duplicates.

This post will dive into the details to get correct answers. So, eventually, you will use the best keyword based on the need. Let’s begin.

CodingSight - Is SQL DISTINCT Good for Removing Duplicates in Results
Read More