WordPress Upgrade Failed – message “The service is unavailable.”

Posted in: Coding Tips by Jazz on August 8, 2009 | Comments Off

If you try to upgrade wordpress automatically by clicking on “Please update now”

and it fails, you may be stuck as browser will show a message – The service is unavailable.

If you have ftp access

goto wp-content folder and delete or rename UPGRADE folder upgrade-bak

and your site should be back up

How to select Random records in TSQL

Posted in: SQL by Jazz on July 22, 2009 | Comments Off

SQL Server – TSQL

Problem: I need random 1000 records

Answer: Use order by newid() function

Code:

SELECT TOP 1000 * FROM Customer_table
ORDER BY newid()