In my life, mySQL database is very touch to use. Because it's very complicated to add or remove data column, rename the table name and inserting demo data without installing phpMyAdmin. That's why I decided to remove mySQL as my project database and to install SQL 2005 server Express version.

So, download both of SQL 2005 Server and also management studio express version. Honestly, installing of SQL 2005 express version is very simple and easy. Because, my before time I've used to develop Coldfusion Project with SQL server. That's why I can say it's simple. Unfortunately, I encountered the following error when I tried to connection SQL 2005 server in Coldfusion Administrator.

[More]

This entry was posted on April 24, 2011 at 1:16 AM and has received 1795 views. There are currently 3 comments. Print this entry.

Today I have to retrieve data from the largest table of my project in Oracle. Approximately, this table has more than 1 million records and need to retrieve data carefully when we need. Now what I need to do is to retrieve negative quantity from this table.

There are two ways to retrieve negative quantity from the table. One is systemically and second is simple way.

[More]

This entry was posted on January 6, 2011 at 8:47 PM and has received 1300 views. There are currently 0 comments. Print this entry.

In Microsoft SQL, we can trace currently which SQL query takes execution time and load of each SQL query in SQL Profiler. In Oracle, what should we do? It's not that simple like Microsoft SQL. Open TOAD and login as SYSTEM authentication. Then type following statement into TOAD SQL.

Run this query. After that, all active query will be displayed and note which query execution time takes so long.

[More]

This entry was posted on January 4, 2011 at 7:35 PM and has received 1786 views. There are currently 0 comments. Print this entry.

My blog was almost dead last weekend because which encountered get 28 error in mysql. That's why I was seeking how come this error occurred in my blog. After a few hours, I found that query cache in mysql exceed the limited amount due to struct function of Coldfusion.

As the outcome of troubleshooting, using Struct in coldfusion may leak database memory and should make clear all value in Struct after using.

In mysql, Coldfusion create the blank temporary table for struct function when we using it. After assigning value into struct by developers, Coldfusion also adding value from struct into the blank temporary table.

For every single request, Coldfusion always create the single blank temporary table for struct. For million requests, Coldfusion will also do like that? :)

This entry was posted on October 31, 2010 at 10:07 PM and has received 1361 views. There are currently 0 comments. Print this entry.

Do you know how to copy two tables in mssql 2000? It's quite simple.

This entry was posted on September 1, 2009 at 9:33 AM and has received 244 views. There are currently 0 comments. Print this entry.

Today, I was kinda disappointed. Because, the project I got hand-over from my colleague have some SQL error. The case is our customer wanted to add new record to this table; and she set ID of this table as Identity OFF and not set identity. That's why our customer cannot add new record to this table. That's why I kept reserching how to add new record to this table. But, I have found one solution.

But it cannot solve my problem. Anyway, I get valuable solution for future.

This entry was posted on June 11, 2009 at 9:32 AM and has received 247 views. There are currently 0 comments. Print this entry.

Some many projects drive me so far to update my blog in these days. So, I want to update my blog when I get free time. In this post, I'll describe how to reduce our storage size by the way of deleting Log File (.ldf) of MsSQL. Sometimes, Log file is bigger than Data File (.mdf) because it save all transaction of whatever we do to our database. That's why I want to delete log file (without having risks) and create new log file without having log records. Yap, here we go. First of all, we need to detach our database. Then, delete .ldf file. (if you're not sure, backup this log file). Then, open Query Analyzer and type following coding.

After that, run it. SQL will create new log file for you. How? Easy. Isn't it?

This entry was posted on June 4, 2009 at 9:32 AM and has received 314 views. There are currently 0 comments. Print this entry.

Hope everybody knows about limit tag MsSql 2005. I feel that's cool and can reduce the load of SQL query just like mySQL. It's kinda simple to use this tag.

If we write so, the sql will return starting from the first record, and plus 10 record in the recordset of myTable.

If we write so, the sql will return starting from the 20th and plus 10 record of myTable. How.? It's easy, isn't it?

This entry was posted on May 21, 2009 at 9:32 AM and has received 342 views. There are currently 0 comments. Print this entry.

Above posts, I've described the figure of SQL ASCII Injections and the solutions of this prevented by asp, asp.net and cfmx. In this post, I'll show how to prevent SQL ASCII Injection attacks by the way of inserting ASCII codes in PHP.

Big Credit to : http://xtian.goelette.info/archives/38-Email-injection-attack.html

This entry was posted on April 21, 2009 at 9:32 AM and has received 364 views. There are currently 0 comments. Print this entry.

In these days, some websites have been attacked by ASCII Encoded/Binary String Automated SQL Injection Attack, by the way of using of using such binary string after query string of your website.