contact
blog
portfolio
services
Blog
Total blog posts
101
Writing readable code
6th Jan 2025
Writing readable code
[ JavaScript ]
[ read more ]
Venturing into CRM market
1st Jan 2025
Venturing into CRM market.
[ News ]
[ read more ]
Logging part 2 - runtime performance
7th Dec 2024
Logging part 2 - runtime performance
[ Node.js ]
[ read more ]
Logging part 1 - down the process ID (pid) and thread ID (threadId)
23th Nov 2024
Log down the process ID (pid) and thread ID (threadId)
[ Node.js ]
[ read more ]
Running a list of function
21st Sep 2024
Data processing can be easier with function list.
[ JavaScript ]
[ read more ]
Advanced use case of RegEx in JavaScript
28th Jul 2024
A complex use case of string replacement with advanced RegEx.
[ JavaScript ]
[ read more ]
A smarter cleanup process on a working directory
5th July 2024
A smarter cleanup process on a working directory.
[ Node.js ]
[ read more ]
Javascript - Immediately Invoked Function Expression (IIFE) firing timing
15th Apr 2024
The firing timing of Immediately Invoked Function Expression (IIFE).
[ JavaScript ]
[ read more ]
Javascript Array use case
1st Apr 2024
Array is one of the fundamental types that appears in all programming languages which every programmer should master in its usage.
[ JavaScript ]
[ read more ]
Migrated 2 iOS apps to web based app
18th Jan 2024
We have migrated 2 iOS apps (PMS and Roster) to web based app.
[ News ]
[ read more ]
JavaScript function parameter
25th Aug 2023
Some secret features in JavaScript function parameter
[ JavaScript ]
[ read more ]
Array.sort() performance
25th July 2023
Finding ways to improve the Array.sort() performance.
[ Node.js ]
[ read more ]
Async performance
13th April 2023
The cost and performance for adding async keyword to a function
[ JavaScript ]
[ read more ]
Use case of RegEx in JavaScript
16th Mar 2023
String operation is very common in any program especially those requires in processing user input.
[ JavaScript ]
[ read more ]
Using 7z in Powershell
2nd Mar 2023
Calling 7z for compressing files
[ Powershell ]
[ read more ]
Adding new website to Nginx
12th Jan 2023
Adding new website to Nginx
[ Ubuntu ]
[ read more ]
Migrated 3 iOS apps to web based app
7th Dec 2022
We have migrated 3 iOS apps (Inventory, Wait list for restaurant and Catering) to web based app.
[ News ]
[ read more ]
Migrated 3 iOS apps to web based app
31st Oct 2022
We have migrated 3 iOS apps (Profit & loss, Project cost and Expenses tracker) to web based app.
[ News ]
[ read more ]
Incremental backup for directory using rdiff-backup
14th Oct 2022
Automating the data backup with rdiff-backup.
[ Ubuntu ]
[ read more ]
Javascript setTimeout with async callback
6th Sep 2022
Javascript setTimeout with async callback
[ JavaScript ]
[ read more ]
Delisted iOS apps from the Apple App Store
19th Aug 2022
All iOS apps that we were offering has been delisted from the Apple App Store.
[ News ]
[ read more ]
The loading sequence for require() in Node.js
18th Jun 2022
Let's analyse the script file loading sequence for require().
[ Node.js ]
[ read more ]
Error handling for async/await and Promise
30th Apr 2022
Error handling for async and Promise
[ JavaScript ]
[ read more ]
Async/await vs Promise and its side effects
14th Mar 2022
Async/await is not a solution for everything and the Promise() is still having a reason to exist.
[ JavaScript ]
[ read more ]
Worker thread vs child process fork in Node.js
7th Jun 2021
It will be good to see the performance comparison between worker thread and child process fork before deciding which route to go.
[ Node.js ]
[ read more ]
Analyze data with MSSQL SELECT statement
31th May 2021
Learn how to analyze the data with SELECT statement
[ MSSQL ]
[ read more ]
Install private Node.js package
13th May 2021
Install private Node.js package and make it accessible in the console
[ Node.js ]
[ read more ]
Hardening your server
4th Feb 2021
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.
[ Ubuntu ]
[ read more ]
Design an iOS app for managing project earning and payout
22nd Jan 2021
Design an iOS app for managing project earning and payout
[ App DEV ]
[ read more ]
Parsing CREATE TABLE statement with Regex in Node.js
18th Jan 2021
Regex is one of the most mysterious and complex stuffs to understand.
[ Node.js ]
[ read more ]
Implementing discount process in MSSQL
12th Jan 2021
Implementing discount process in MSSQL
[ MSSQL ]
[ read more ]
Add a new hard disk/partition
5th Dec 2020
When you need more space.. try this out
[ Ubuntu ]
[ read more ]
Install Nginx
5th Dec 2020
Running a web server is the minimum thing in your big enterprise.
[ Ubuntu ]
[ read more ]
Install Node.js and PM2
5th Dec 2020
Developing web applications using Node.js and making it running fulltime using pm2.
[ Ubuntu ]
[ read more ]
Install php-fpm
5th Dec 2020
Developing websites, especially business applications with PHP is fun.
[ Ubuntu ]
[ read more ]
Ubuntu installation checklist
5th Dec 2020
This installation checklist will guide you on how to set up a web server or file server for office use.
[ Ubuntu ]
[ read more ]
Preload your favorite scripts in PowerShell
14th May 2020
It is best if all our favorite functions are ready when Powershell starts.
[ Powershell ]
[ read more ]
Failed to download from Internet
12th May 2020
Failed to download file from a web server.
[ Powershell ]
[ read more ]
Tricky ConvertTo-Json in Powershell
11th May 2020
Converting Powershell objects to JSON with ease.
[ Powershell ]
[ read more ]
Handling XML in Powershell
4th May 2020
Powershell is able to handle XML structure easily.
[ Powershell ]
[ read more ]
View the binding for the website in IIS
10th Feb 2020
The best part of Powershell to us is the capability of managing an IIS web server.
[ Powershell ]
[ read more ]
Get all website entries in IIS
6th Feb 2020
Get the list of websites hosted in the IIS.
[ Powershell ]
[ read more ]
Create scheduled task in Windows Task Scheduler - part 3
27th Dec 2019
Creating scheduled tasks with Powershell command line part 3.
[ Powershell ]
[ read more ]
Trigger an URL without waiting for its result
23th Dec 2019
curl without waiting for the result.
[ Powershell ]
[ read more ]
Executing another Powershell script
16th Dec 2019
Here's how to run a third party script.
[ Powershell ]
[ read more ]
Executing DOS command with Powershell
16th Dec 2019
Do not forget the old DOS command is still useful.
[ Powershell ]
[ read more ]
Restart IIS appPool
16th Dec 2019
Restarting IIS appPool with a script file.
[ Powershell ]
[ read more ]
Install PowerShell WMF 5.1
12th Dec 2019
Install Powershell.
[ Powershell ]
[ read more ]
Create scheduled task in Windows Task Scheduler - part 2
9th Dec 2019
Creating scheduled tasks with Powershell command line part 2.
[ Powershell ]
[ read more ]
Declaring C# like Class type
5th Dec 2019
Declaring your custom class structure in Powershell.
[ Powershell ]
[ read more ]
Parsing text into object
5th Dec 2019
Parsing DOS commands results into a Powershell class structure.
[ Powershell ]
[ read more ]
Matching a string against a list of predefined strings
4th Dec 2019
Matching a string in a string list is easy.
[ Powershell ]
[ read more ]
Create scheduled task in Windows Task Scheduler
2nd Dec 2019
Creating scheduled tasks with Powershell command line.
[ Powershell ]
[ read more ]
Disable the auto-close feature for the database
28th Nov 2019
The script to disable auto close the database in MSSQL
[ MSSQL ]
[ read more ]
The Powershell way to keep configuration in file
27th Nov 2019
You need a place to keep your setting.
[ Powershell ]
[ read more ]
Compress and decompress file
25th Nov 2019
Compressing files is part of the automation process which is important for creating backup before rolling out the updates.
[ Powershell ]
[ read more ]
Copying files with Robocopy
25th Nov 2019
Triggering external programs to copy files.
[ Powershell ]
[ read more ]
Setting up IIS server
18th Nov 2019
Setting up an IIS web server using Powershell.
[ Powershell ]
[ read more ]
Installing MSSQL server with Powershell
11th Nov 2019
Another task has been simplified and standardized.
[ Powershell ]
[ read more ]
Installing DNS server
4th Nov 2019
Automating new server setup - installing DNS server.
[ Powershell ]
[ read more ]
Changing the execution policy
2nd Nov 2019
Updating the execution policy before starting your Powershell script for the first time.
[ Powershell ]
[ read more ]
Loop all records
18th Oct 2019
Loop through the records without using cursor in MSSQL
[ MSSQL ]
[ read more ]
How to find out which index is missing
19th Sep 2019
Looking for missing index in MSSQL
[ MSSQL ]
[ read more ]
Fix the database state in MSSQL
14th Sep 2019
Change the database state back to normal
[ MSSQL ]
[ read more ]
Running the same stored procedure sequentially
26th Oct 2018
The script to disable auto close the database in MSSQL
[ MSSQL ]
[ read more ]
Happiness in life with less unnecessary stuffs
24th April 2018
Happiness in life with less unnecessary stuffs
[ App DEV ]
[ read more ]
Printing HTML with JavaScript
2nd Nov 2017
Printing HTML is easy and fun
[ JavaScript ]
[ read more ]
Decoupling the front end from back end
26th Sep 2017
Replacing backend services with ease by decoupling the front end from back end.
[ System design ]
[ read more ]
Avoiding uncertainty with "this" keyword
12th July 2017
Confusion with 'this' keyword
[ JavaScript ]
[ read more ]
Wait for a while
22nd Dec 2016
Simulating resource locking with waitfor in MSSQL
[ MSSQL ]
[ read more ]
Javascript object and class
20th July 2016
null
[ JavaScript ]
[ read more ]
Cleanup
22nd Apr 2014
Recovering storage space after upgrade.
[ Ubuntu ]
[ read more ]
Compression Tool
22nd Apr 2014
Installing 7z program to compress and password protect your backup.
[ Ubuntu ]
[ read more ]
Configure firewall
22nd Apr 2014
Firewall is crucial for a server especially if it is a public facing server.
[ Ubuntu ]
[ read more ]
Configure server IP address & DNS
22nd Apr 2014
As long as your server has the need to access the network, you will need to assign an IP address and configure the DNS.
[ Ubuntu ]
[ read more ]
File & Directory
22nd Apr 2014
Be familiar with chown and chmod which is going to be helpful in running a web server or office server.
[ Ubuntu ]
[ read more ]
Frequently used commands
22nd Apr 2014
Here are the frequently used commands for you.
[ Ubuntu ]
[ read more ]
Frequently used directories
22nd Apr 2014
There are 3 frequently used directories: 'etc', 'var' and 'home'.
[ Ubuntu ]
[ read more ]
Install fail2ban
22nd Apr 2014
fail2ban is an automated defend daemon that safeguards your server.
[ Ubuntu ]
[ read more ]
Install FTP
22nd Apr 2014
FTP allows the user to upload files to the server without the need of physical access.
[ Ubuntu ]
[ read more ]
Install OpenSSH
22nd Apr 2014
Accessing the server remotely with SSH feels magical. No other feeling better than this.
[ Ubuntu ]
[ read more ]
Scheduled a task
22nd Apr 2014
Doing more work with lesser manpower and achieving higher efficiency.
[ Ubuntu ]
[ read more ]
User & Groups Security
22nd Apr 2014
User accounts in Linux are free of charge. You can add as many as you want.
[ Ubuntu ]
[ read more ]
Ubuntu Linux Server
20th Apr 2014
Here is my collection of the basic ideas on how to install and maintain an Ubuntu server throughout the years.
[ Ubuntu ]
[ read more ]
Dynamic query
15th Oct 2013
Dynamic query allows you to prepare the query at runtime and executes it
[ MSSQL ]
[ read more ]
Concatenate all records into one line text
21st Feb 2013
It is slow if you are concatenating all records with a loop in MSSQL
[ MSSQL ]
[ read more ]
Create user reminder
8th Oct 2012
Reminding user with notification in MSSQL
[ MSSQL ]
[ read more ]
Benefits of using stored procedure
1st Oct 2012
Want to find out how we use the stored procedure in MSSQL
[ MSSQL ]
[ read more ]
Generate a series of records with CTE
27th Sep 2012
Here is the correct and better way to generate a series of number or date with CTE in MSSQL
[ MSSQL ]
[ read more ]
Load the system settings using SQL stored procedure or SQL function
20th Sep 2012
Load the system settings in MSSQL
[ MSSQL ]
[ read more ]
Process re-entrant
28th Aug 2012
Allow to run the process again in MSSQL.
[ MSSQL ]
[ read more ]
How to design a better reporting process
7th Aug 2012
Design a better and manageable reporting process in MSSQL.
[ MSSQL ]
[ read more ]
You need an application log for your systems
24th Jul 2012
An application log for your systems
[ MSSQL ]
[ read more ]
Design a custom mail process
17th Jul 2012
You need a custom mail process
[ MSSQL ]
[ read more ]
Design a stoppable long running process
10th Jul 2012
How to design a stoppable long running process?
[ MSSQL ]
[ read more ]
Tracking the progress of a long run process
3rd Jul 2012
Troubleshooting a long run process is no longer a nightmare.
[ MSSQL ]
[ read more ]
Database stored procedure development guide
26th Jun 2012
Database stored procedure development guide
[ MSSQL ]
[ read more ]
Primary key in uniqueidentifier
20th Jun 2012
Implementing primary key with uniqueidentifier in MSSQL
[ MSSQL ]
[ read more ]
Throw an error in MSSQL and catch by C#
5th Jun 2012
Throw an error in MSSQL and catch by C#
[ MSSQL ]
[ read more ]
Returning paginated records in MSSQL
22nd Dec 2011
You have a huge table and you do not want to return all records to the browser in one go
[ MSSQL ]
[ read more ]
Rebuilding indexes to maintain the query performance
24th May 2010
Rebuilding indexes to maintain the query performance in MSSQL
[ MSSQL ]
[ read more ]
[ 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 ]