PHP MySQL : Paging Tutorial

Excel : Speed Up Calculation

Case : You want to delete bulk of rows (more than 50.000 rows) on excel
Solution : Use VBA
Script :

Sub delete_rows_zero()

Application.ScreenUpdating = False

Dim nMaxRow As Long, nrow As Long
nMaxRow = ActiveSheet.UsedRange.Rows.Count
For nrow = nMaxRow To 1 Step -1
      If Range("A" & nrow).Value = "delete" Then
      Range("A" & nrow).EntireRow.Delete
      End If
Next nrow

Application.ScreenUpdating = True

End Sub

Source : http://www.databison.com/index.php/how-to-speed-up-calculation-and-improve-performance-of-excel-and-vba/

Install Ubuntu Perfect Server

This tutorial shows how to prepare an Ubuntu 10.04 (Lucid Lynx) server for the installation of ISPConfig 3, and how to install ISPConfig 3. ISPConfig 3 is a webhosting control panel that allows you to configure the following services through a web browser: Apache web server, Postfix mail server, MySQL, BIND or MyDNS nameserver, PureFTPd, SpamAssassin, ClamAV, and many more. 

Mass User Creation in WordPress

Case : you want to add mass user in your wordpress
Script :

require( '/wp-load.php' );
wp_create_user('otto', 'password', 'otto@ottodestruct.com');
wp_create_user('fake', 'fakepass', 'fake@example.com');
...

Source : http://wordpress.org/support/topic/mass-user-creation-in-wordpress-30

20 Things You Must Have on Your Blog

20 things you must have on your blog :

1. SEO Design
2. Page : Home
3. Page : About
4. Page : Disclaimer
5. Page : Contact
6. Addthis
7. Searchbox
8. Shoutbox
9. Follower
10. Popular Post
11. Recent Post
12. Blog Archive
13. Blogroll
14. Feedjit
15. Tagcloud / Wp-Cumulus like
16. Backlink
17. Paging
18. Linkwithin
19. Share Facebook button
20. Google Adsense

Source : http://www.google.com