Privacy Policy kokchoon.com built the Malaysia Calendar app as an Ad Supported app. This SERVICE is provided by kokchoon.com at no cost and is intended for use as is. This page isRead More…
Privacy Policy – JB Traffic
Privacy Policy kokchoon.com built the JB Traffic app as an Ad Supported app. This SERVICE is provided by kokchoon.com at no cost and is intended for use as is. This page isRead More…
C# DateTime Format
Date and Time in C# are handled by DateTime class in C# that provides properties and methods to format dates in different datetime formats. This article blog explains how to work withRead More…
SQL delete statement where date is greater than 30 days
replace {TABLE} with the target table name replace {DATE} with the date field.
Executing set of SQL queries using batch file?
Save the commands in a .SQL file, ex: ClearTables.sql, say in your C:\temp folder. Contents of C:\Temp\ClearTables.sql Then use sqlcmd to execute it as follows. Since you said the database is remote, use the following syntax (after updating for yourRead More…
How to Move Database Files to Another Drive
ObjectiveTo move the SQL database .mdf and .ldf files to another drive on the server. EnvironmentPrimary Product OS : Windows 2012 ServerPrimary Product Module : Microsoft SQL 2012 Procedure Launch Microsoft’s SQL Server ManagementRead More…
How to search large files in Windows 10
Open File Explorer 2. At the search box, type “size:Gigantic” to search all the files with size greater than 128 MB. 3. You can use other key words to search difference fileRead More…
How to CTRL+ALT+Delete in Remote Desktop
You may want to use CTRL + ALT + Delete on a remote server or PC using RDP to change password or other logout. To perform CTRL + ALT + Delete onRead More…
Hide Side Menu of Sharepoint List and Change List Column Width
In the post, we will show you how to hide the side menu in Sharepoint list and how to change the width of list column. In the list view, click on “EditRead More…
How to show hidden files in MacOS
To show hidden files in MacOS, please follow the following steps: Open Terminal Enter the following command and press enter key defaults write com.apple.finder AppleShowAllFiles YES Press and hold Alt /Read More…