Blog

CIYSYS blog

Total blog posts

108

[ System design ]

CIYSYS - we can provide a better and expandible customized software

Jan 1, 2026

[ Node.js ]

Node.js - Why do we need a home made current date and time function?

Oct 9, 2025

[ Node.js ]

The basic function of npm and problem that you might face during upgrade

Aug 13, 2025

[ Node.js ]

Fork a long live child process without affected by main process

Jul 31, 2025

[ Node.js ]

Node.js - retry on error is a must for important process

Jun 23, 2025

[ Node.js ]

Node.js - executing a shell command with execSync() OR exec()

May 27, 2025

[ Node.js ]

Node.js logging part 3 - log destination

Apr 25, 2025

[ JavaScript ]

JavaScript - the rules for writing readable code

Jan 6, 2025

[ News ]

Venturing into CRM market

Jan 1, 2025

[ Node.js ]

Node.js logging part 2 - log down the runtime performance

Dec 7, 2024

[ Node.js ]

Node.js logging part 1 - log down the process ID and thread ID

Nov 23, 2024

[ JavaScript ]

JavaScript - running a list of function with plug-n-play concept

Sep 21, 2024

[ JavaScript ]

JavaScript - the advanced use case for RegEx on complex text processing

Jul 28, 2024

[ Node.js ]

Node.js - a smarter cleanup process on a working directory

Jul 5, 2024

[ JavaScript ]

JavaScript - immediately Invoked Function Expression (IIFE) firing timing

Apr 15, 2024

[ JavaScript ]

Javascript - learn the powerful and flexibility of Array type

Apr 1, 2024

[ News ]

Migrated 2 iOS apps to web based app

Jan 18, 2024

[ JavaScript ]

JavaScript - more ways in declaring the function parameter

Aug 25, 2023

[ Node.js ]

Nodej.js - the Array.sort() performance and how to use custom sorting

Jul 25, 2023

[ JavaScript ]

JavaScript - the Async performance and memory usage on recursive call

Apr 13, 2023

[ JavaScript ]

JavaScript - the basic of RegEx and its' use cases

Mar 16, 2023

[ Powershell ]

Powershell - using 7z in password protecting the output

Mar 2, 2023

[ Ubuntu ]

Ubuntu - the configuration steps to add a new website in Nginx

Jan 12, 2023

[ News ]

Migrated 3 iOS apps to web based app

Dec 7, 2022

[ News ]

Migrated 3 iOS apps to web based app

Oct 31, 2022

[ Ubuntu ]

Ubuntu -incremental backup for directory using rdiff-backup

Oct 14, 2022

[ JavaScript ]

Javascript setTimeout with async callback

Sep 6, 2022

[ News ]

Delisted iOS apps from the Apple App Store

Aug 19, 2022

[ Node.js ]

The loading sequence for require() in Node.js

Jun 18, 2022

[ JavaScript ]

JavaScript - error handling in async/await and Promise

Apr 30, 2022

[ JavaScript ]

JavaScript - async/await vs Promise and its side effects

Mar 14, 2022

[ Node.js ]

Performance between Worker thread vs child process fork in Node.js

Jun 7, 2021

[ MSSQL ]

MSSQL - the first step into data analysis using SELECT statement

May 31, 2021

[ Node.js ]

Node.js - develop a private package and make it available in the console

May 13, 2021

[ Ubuntu ]

Ubuntu - the basic checklist to harden your server

Feb 4, 2021

[ App DEV ]

Design an iOS app for managing project earning and payout

Jan 22, 2021

[ Node.js ]

Node.js - parsing CREATE TABLE statement with Regex

Jan 18, 2021

[ MSSQL ]

MSSQL - implementing a discount formula in an ordering process

Jan 12, 2021

[ Ubuntu ]

Ubuntu - add a new hard disk/partition to your server

Dec 5, 2020

[ Ubuntu ]

Ubuntu - install Nginx to host website with free SSL certificate

Dec 5, 2020

[ Ubuntu ]

Ubuntu - hosting Node.js programs and PM2 to manage the processes

Dec 5, 2020

[ Ubuntu ]

Ubuntu - install php-fpm to host PHP websites

Dec 5, 2020

[ Ubuntu ]

Ubuntu - the installation checklist to setup a secure web server

Dec 5, 2020

[ Powershell ]

PowerShell - preload your favorite scripts upon starting a new console

May 14, 2020

[ Powershell ]

Failed to download from Internet using Powershell

May 12, 2020

[ Powershell ]

Tricks in using Powershell ConvertTo-Json

May 11, 2020

[ Powershell ]

Powershell - extracting data and writing new data in an XML file

May 4, 2020

[ Powershell ]

View the binding for the website in IIS with Powershell

Feb 10, 2020

[ Powershell ]

Get all website entries in IIS using Powershell

Feb 6, 2020

[ Powershell ]

Powershell - create scheduled task in Windows Task Scheduler - part 3

Dec 27, 2019

[ Powershell ]

Powershell - trigger an URL without waiting for its result

Dec 23, 2019

[ Powershell ]

Executing another Powershell script file

Dec 16, 2019

[ Powershell ]

Run DOS command or CMD in Powershell

Dec 16, 2019

[ Powershell ]

Restart IIS appPool with Powershell

Dec 16, 2019

[ Powershell ]

Install PowerShell WMF 5.1

Dec 12, 2019

[ Powershell ]

Powershell - create scheduled task in Windows Task Scheduler - part 2

Dec 9, 2019

[ Powershell ]

Powershell - declaring a C# like class type instead of dynamic object

Dec 5, 2019

[ Powershell ]

Powershell - parsing a text from some DOS command into object

Dec 5, 2019

[ Powershell ]

Powershell - matching a string against a list of predefined strings

Dec 4, 2019

[ Powershell ]

Powersell - create scheduled task in Windows Task Scheduler - part 1

Dec 2, 2019

[ MSSQL ]

MSSQL - enable or disable the auto-close feature for all databases

Nov 28, 2019

[ Powershell ]

The Powershell way to keep configuration in file

Nov 27, 2019

[ Powershell ]

Powershell - compress and decompress file with the built-in API

Nov 25, 2019

[ Powershell ]

Powershell - calling Robocopy to copy files

Nov 25, 2019

[ Powershell ]

Setting up IIS server with Powershell

Nov 18, 2019

[ Powershell ]

Installing MSSQL server in a Powershell console

Nov 11, 2019

[ Powershell ]

Installing DNS server in a Powershell console

Nov 4, 2019

[ Powershell ]

Powershell - running scripts is disabled and how to resolve it

Nov 2, 2019

[ MSSQL ]

MSSQL - loop through all records in a temporary working table

Oct 18, 2019

[ MSSQL ]

MSSQL - looking for the missing index

Sep 19, 2019

[ MSSQL ]

MSSQL - fix the recovery database state manually

Sep 14, 2019

[ MSSQL ]

MSSQL - running the same stored procedure sequentially using mutex

Oct 26, 2018

[ App DEV ]

Happiness in life with less unnecessary stuffs

Apr 24, 2018

[ JavaScript ]

JavaScript - print a HTML in an iframe with a specialized CSS

Nov 2, 2017

[ System design ]

Decoupling the front end from back end from a monolithic system

Sep 26, 2017

[ JavaScript ]

JavaScript - 'this' keyword can be very confusing at runtime

Jul 12, 2017

[ MSSQL ]

MSSQL - manually put the request into sleep for x minutes

Dec 22, 2016

[ JavaScript ]

JavaScript - the most flexible object concept and class keyword

Jul 20, 2016

[ Ubuntu ]

Ubuntu - clean up the old updates and recover the storage space

Apr 22, 2014

[ Ubuntu ]

Ubuntu - 7z is a compression utility that supports password feature

Apr 22, 2014

[ Ubuntu ]

Ubuntu - Configure firewall with ufw and iptables

Apr 22, 2014

[ Ubuntu ]

Ubuntu - Configure server IP address & DNS settings

Apr 22, 2014

[ Ubuntu ]

Ubuntu - managing files & directories with appropriate permission

Apr 22, 2014

[ Ubuntu ]

Ubuntu - the list of frequent used commands and build your aliases

Apr 22, 2014

[ Ubuntu ]

Ubuntu - the list of frequent used directories and their purposes

Apr 22, 2014

[ Ubuntu ]

Ubuntu - install fail2ban to automate the blocking of attacker

Apr 22, 2014

[ Ubuntu ]

Ubuntu - install and configure FTP servce on your server

Apr 22, 2014

[ Ubuntu ]

Ubuntu - install and configure OpenSSH and sftp

Apr 22, 2014

[ Ubuntu ]

Ubuntu - scheduled and configure a repetitive task in cron

Apr 22, 2014

[ Ubuntu ]

Ubuntu - manage User & groups security with low level commands

Apr 22, 2014

[ Ubuntu ]

Ubuntu - a Linux server that is free of charge for anyone

Apr 20, 2014

[ MSSQL ]

MSSQL - write dynamic query to avoid unnecessary criteria

Oct 15, 2013

[ MSSQL ]

MSSQL - concatenate all records into one line text

Feb 21, 2013

[ MSSQL ]

MSSQL - create user reminder or notification and keep the record

Oct 8, 2012

[ MSSQL ]

MSSQL - benefits of using stored procedure and function

Oct 1, 2012

[ MSSQL ]

MSSQL - generate a series of records with CTE

Sep 27, 2012

[ MSSQL ]

MSSQL - load the system settings by stored procedure or function

Sep 20, 2012

[ MSSQL ]

MSSQL - ensure that the process is not running more than once

Aug 28, 2012

[ MSSQL ]

A universal way on designing a better reporting process

Aug 7, 2012

[ MSSQL ]

MSSQL - centralize the application log for troubleshooting

Jul 24, 2012

[ MSSQL ]

MSSQL - design a custom mail process

Jul 17, 2012

[ MSSQL ]

A universal way to design a stoppable long running process

Jul 10, 2012

[ MSSQL ]

A universal way to track the progress of a long run process

Jul 3, 2012

[ MSSQL ]

Our universal stored procedure development guideline

Jun 26, 2012

[ MSSQL ]

MSSQL - the choice on using uniqueidentifier for Primary key

Jun 20, 2012

[ MSSQL ]

MSSQL - throw an error in stored procedure and catch by C#

Jun 5, 2012

[ MSSQL ]

MSSQL - Returning paginated records to reduce the network payload

Dec 22, 2011

[ MSSQL ]

MSSQl - rebuilding indexes to maintain the query performance

May 24 2010

[ Find more at App DEV blog ]

[ Find more at JavaScript blog ]

[ Find more at MSSQL blog ]

[ Find more at Node.js blog ]

[ Find more at Powershell blog ]

[ Find more at Ubuntu blog ]

[ Find more at System design blog ]

[ Our recent activity ]

Curious on what we have done?

[ View our portfolio ]

If you are looking for a customized software solution,

[ Get in touch with us ]