Yes, I’m too busy for SQL scripting job these recent weeks. I have a union select query that needed to be sorted per union but since it is not allowed […]
Category: Database
SQL Server Import/Export to CSV
There are tools that will help you in importing or exporting CSV files to and from SQL Server databases. However, using them will slow you down for a factor of […]
SQL Server – Select Nth Row
Seems like I’m now stuck with .NET development and the current tasks where developing SQL scripts. One of the spec was to return the first record, second record and third […]
SQL Server – Dynamic Where Clause
Things can be neatly done in application level by concatenating where clause however, there are times when you are out of that application and all you can do is SQL […]
PHP and PostgreSQL on Windows
PostgreSQL is now easy to install on Windows using its installer. However, integrating it with PHP in Windows usually has problems. No matter how you configure PHP and the DLL […]
Changing URL – WordPress and Moving to a new domain
If you have a blog that is up for few years already and suddenly you decided to move to a new domain / url, you end up changing all the […]
Updating Multiple Rows in MySQL
There comes a time when you need to update multiple rows with different values. You can update multiple rows with the same value, but when dealing with different values for […]
Making MySQL 5.1 Dump Compatible with MySQL 5.0
While posting this, the process of restoring a MySQL dump is still running. When all you have is a MySQL 5.1 dump and you need to restore it to a […]
MySQL Backup Strategy
The Story A few months ago, while at home, my supervisor called me. The incident was that our client’s QR System stops working on a certain module. I learn that […]
MySQL Query – No Quote For String Fields
One of the module in our project, it is experiencing a slow performance. The module will let the user scan the PCB barcode of an item and updated a record […]