SQL Server Performance Improvement Best Practices: ISNULL
Recently, we have started rechecking SQL queries of our one of client’s project. It’s basically performance improvement of SQL queries. While rechecking queries, we…
Troubleshooting Git Fatal Error: Failed to Read Object Xxx: Invalid Argument
Recently, I was facing the git fatal error when I pull new changes from remote repository, This is probably due to my computer was…
Statement Cancelled Due to Timeout or Client Request
I would like to share one of the cfsqltype issue that I face with Lucee CFML Engine. Initially we use Railo as CFML Engine…
MSSQL Table Get Locked and Query Keep Running and Unlock It
Today, we were tuning our long running sql queries and found that the longest query was keep running. We know that sql does some locking…
How to Write Test Case for Handler Using Testbox
A month ago I have posted the testbox example for unit testing and promise to post a example of handler testcase using testbox. Well,…
Task Scheduler Was Not Working Social Engine Video Upload Module – Solved
Recently I started reviewing SocialEngine (Short desc: create your own social networking site), and I face some issue with video uploading process. I am…
Saving with EC2 Reserved Instance: AWS
Recently working with client to move ColdFusion project to AWS which has seasonal traffic. Key points are saving cost and easily upgrade/degrade server whenever…
One More Good Reason to Define Local Variables in Function Instead of Variables Scope
I used to create application variables for my cfc object which usually called many times from my coldfusion pages. This will help you to…
Strange ColdFusion Issue, JRUN Eating Up to 50% of CPU
For one of our project we recently move to Amazon EC2 to make system easily scalable. This is kind of seasonal website which has…
Listing Scheduled Task
I love cfschedule tag to create/update/delete schedule and use one file to create all schedules. This is really help whenever you swich server and…
How to Prevent the Web Pages from Being Index by Search Engine
If you want to hide a page or website from search engines, you can do it in several ways. Since all search engines follow…
Configure ColdFusion with VisualVM
For one of our project we are facing jrun high usage issue. When looking into task manager (Window 2008) I found jRun continously eating…