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

Understanding SQL Server Security Function HAS_Permis_BY_Name and Its USE Cases

There are multiple instances when we want to check the permission on a securable for a principal. Before going ahead, let’s see what principal, securables, and permissions are.

According to Microsoft Documentation,

  1. Securables in SQL Server context are specific resources to which the SQL Server Database Engine authorization system controls access. They are divided into three categories: Server, Database and Schema. In general, any SQL Server or database objects can be securables.
  2. Permissions are controls using which we assign grant or deny certain level of access to a securable.
  3. Principal is an entity that receives permission to a securable. The most common principals are logins and database users.
CodingSight - Understanding SQL Server Security Function HAS_Permis_BY_Name and Its USE Cases
Read More

SQL OR Statement: The Basics

Now and then, you need to create a complex SQL query using multiple statements together. While these query types can be tedious to create, they make your data better suitable for reporting purposes. To understand these query types, you must first have some knowledge of logical operators.

A logical operator allows you to combine two or more statements into one. Also, it lets you control the results based on certain conditions. It makes your queries incredibly powerful tools for creating customized reports of your data. This post will focus specifically on one type: the OR Operator.

CodingSigtht - SQL OR Statement: The Basics
Read More