Jan 17, 2022

Host Blazor on ECS Part 2 —Configure Load Balancer with SSL

What we need to follow this article Container app in ECS FARGATE Your Domain for SSL What we will achieve Accessing containerized web app in ECS Fargate using SSL Domain through Load Balancer In the previous article, we covered how to containerize your app and run it in ECS Fargate…

5 min read

Host Blazor on ECS Part 2 —Configure Load Balancer with SSL

5 min read

Jan 17, 2022

How to host Blazor on ECS Part 1

With Blazor, we can develop web apps using C# only and Visual Studio has Docker option now. Docker and ECS Fargate makes running web apps really easy and we do not have to worry about servers and infrastructure! Developing web apps by C# are getting more and more interesting these…

6 min read

6 min read

Apr 11, 2021

How to securely use AWS access key in C# — SQS Polling Worker Service Example

AWS has ton of useful managed services such as SQS, DynamoDB, Kinesis Stream, etc which help us developers focus on our codes. In order to use AWS services, we will need to use Access Key and Secret Key for an account our program uses. It is simple and easy to…

Aws Access Keys

4 min read

How to securely use AWS access key in C# — SQS Polling Worker Service Example

Aws Access Keys

4 min read

Apr 9, 2021

Alarm system from application logs by CloudWatch Metrics [Step 2]

In the last article, we went over how to write logs from C# application to CloudWatch without installing an agent. Now, the goal of this article is to create an alarm system out of applications logs so that we can proactively fix issues before users notice them. Logs -> Metrics-> Alarms Since we have…

Logging

4 min read

Alarm system from application logs by CloudWatch Metrics [Step 2]

Logging

4 min read

Apr 5, 2021

Make SQL Bulk Insert/Update Faster— Speed Benchmark : Temp Table vs Table-Valued Parameters

In this article, I would like to share three ways of bulk insert/update for 100,000 records data, 50,000 insert and 50,000 update. Either way, bulk insert/update can be completed within a few seconds. We can implement bulk insert/update using Entity Framework easily by calling SaveChanges() at the end. However, since…

Sql

2 min read

Speed Benchmark for SQL Bulk Insert/Update — Temp Table vs Table-Valued Parameters

Sql

2 min read

Mar 31, 2021

Alarm system from application logs by CloudWatch Metrics [Step1]

In the past, I did not used to care much about loggings. When I released a new application for production, I checked the server and making sure that new application was running fine. After production release was completed, new app was working fine for a while. However, every now and…

Cloudwatch

6 min read

Cloudwatch

6 min read

Mar 25, 2021

Blazor End to End Test with Cypress

.Net Core Blazor is a great way to create a front-end app for C# developers since we can code using C# only. However, JavaScript ecosystem is huge and there is an awesome test tool which we can take advantage of for Blazor app. This article is an introduction of the…

Blazor

5 min read

Blazor

5 min read

Oct 20, 2020

2 ways to run BULK INSERT

When there are lots of data to insert, we cannot insert one by one. There are several ways to bulk insert, and here are 3 examples for that! SqlBulkCopy from DataTable Create a DataTable and specify which database table to insert. We can specify BatchSize so that we do not push too much…

C Sharp Programming

2 min read

C Sharp Programming

2 min read

2 ways to run BULK INSERT

When there are lots of data to insert, we cannot insert one by one. There are several ways to bulk insert, and here are 3 examples for that!

SqlBulkCopy from DataTable

Create a DataTable and specify which database table to insert.

We can specify BatchSize so that we do not push too much…

Sep 21, 2020

Roadmap to be a Web Developer

When starting to learn how to develop a web application, it is so hard to decide where to start. This is because there are so many programming languages and frameworks which we can choose, and the new ones keep coming up. Even experienced developers can be overwhelmed, and it is…

Web Developer

3 min read

Web Developer

3 min read

Sep 14, 2020

Speed Benchmark — Table Valued Parameter

In the previous article below, I covered the performance benchmark between Dapper and Entity Framework Core. Dapper was much faster to insert records, and now I am curious if I can make it even faster using Microsoft SQL’s Table Valued Parameter. …

Table Valued Parameter

2 min read