Data processing can be easier with function list.

A complex use case of string replacement with advanced RegEx.

A smarter cleanup process on a working directory.

The firing timing of Immediately Invoked Function Expression (IIFE).

Array is one of the fundamental types that appears in all programming languages which every programmer should master in its usage.

Some secret features in JavaScript function parameter

Finding ways to improve the Array.sort() performance.

The cost and performance for adding async keyword to a function

String operation is very common in any program especially those requires in processing user input.

Calling 7z for compressing files

Adding new website to Nginx

Automating the data backup with rdiff-backup.

Javascript setTimeout with async callback

Let's analyse the script file loading sequence for require().

Error handling for async and Promise

Async/await is not a solution for everything and the Promise() is still having a reason to exist.

It will be good to see the performance comparison between worker thread and child process fork before deciding which route to go.

Learn how to analyze the data with SELECT statement

Install private Node.js package and make it accessible in the console

The public facing server has a higher risk of being hacked or attacked. So, you may want to minimize the risk by following the steps mentioned in this article.

Design an iOS app for managing project earning and payout

Regex is one of the most mysterious and complex stuffs to understand.

Implementing discount process in MSSQL

When you need more space.. try this out

Running a web server is the minimum thing in your big enterprise.

Developing web applications using Node.js and making it running fulltime using pm2.

Developing websites, especially business applications with PHP is fun.

This installation checklist will guide you on how to set up a web server or file server for office use.

It is best if all our favorite functions are ready when Powershell starts.

Failed to download file from a web server.

Converting Powershell objects to JSON with ease.

Powershell is able to handle XML structure easily.

The best part of Powershell to us is the capability of managing an IIS web server.

Get the list of websites hosted in the IIS.

Creating scheduled tasks with Powershell command line part 3.

curl without waiting for the result.

Here's how to run a third party script.

Do not forget the old DOS command is still useful.

Restarting IIS appPool with a script file.

Install Powershell.

Creating scheduled tasks with Powershell command line part 2.

Declaring your custom class structure in Powershell.

Parsing DOS commands results into a Powershell class structure.

Matching a string in a string list is easy.

Creating scheduled tasks with Powershell command line.

The script to disable auto close the database in MSSQL

You need a place to keep your setting.

Compressing files is part of the automation process which is important for creating backup before rolling out the updates.

Triggering external programs to copy files.

Setting up an IIS web server using Powershell.

Another task has been simplified and standardized.

Automating new server setup - installing DNS server.

Updating the execution policy before starting your Powershell script for the first time.

Loop through the records without using cursor in MSSQL

Looking for missing index in MSSQL

Change the database state back to normal

The script to disable auto close the database in MSSQL

Happiness in life with less unnecessary stuffs

Printing HTML is easy and fun

Replacing backend services with ease by decoupling the front end from back end.

Confusion with 'this' keyword

Simulating resource locking with waitfor in MSSQL

null

Recovering storage space after upgrade.

Installing 7z program to compress and password protect your backup.

Firewall is crucial for a server especially if it is a public facing server.

As long as your server has the need to access the network, you will need to assign an IP address and configure the DNS.

Be familiar with chown and chmod which is going to be helpful in running a web server or office server.

Here are the frequently used commands for you.

There are 3 frequently used directories: 'etc', 'var' and 'home'.

fail2ban is an automated defend daemon that safeguards your server.

FTP allows the user to upload files to the server without the need of physical access.

Accessing the server remotely with SSH feels magical. No other feeling better than this.

Doing more work with lesser manpower and achieving higher efficiency.

User accounts in Linux are free of charge. You can add as many as you want.

Here is my collection of the basic ideas on how to install and maintain an Ubuntu server throughout the years.

Dynamic query allows you to prepare the query at runtime and executes it

It is slow if you are concatenating all records with a loop in MSSQL

Reminding user with notification in MSSQL

Want to find out how we use the stored procedure in MSSQL

Here is the correct and better way to generate a series of number or date with CTE in MSSQL

Load the system settings in MSSQL

Allow to run the process again in MSSQL.

Design a better and manageable reporting process in MSSQL.

An application log for your systems

You need a custom mail process

How to design a stoppable long running process?

Troubleshooting a long run process is no longer a nightmare.

Database stored procedure development guide

Implementing primary key with uniqueidentifier in MSSQL

Throw an error in MSSQL and catch by C#

You have a huge table and you do not want to return all records to the browser in one go

Rebuilding indexes to maintain the query performance in MSSQL