Category: New Technology

Common Mysql commands, queries, and administrative functions 0

Common Mysql commands, queries, and administrative functions

Gotta love the mysql database.  Here is a list of common mysql commands and syntax that you will use most often. To login (from unix shell) use -h only if needed. # [mysql dir]/bin/mysql...


Detecting and blocking click fraud on sites

Google policies dictate prevention of click fraud falls on the shoulders of the site owner and bans AdSense accounts for invalid clicks with practically no chance of getting that account back in good standing. Here’s how to detect and prevent invalid clicks on your sites AdSense advertisements.


Add delete confirmation to ListView control

The ASP.Net ListView control is a godsend for developers. Drop the control on the form, hook in a datasource, and you have complete, out-of-the-box view, edit, insert, and delete functionality. One thing missing though is a delete confirmation if the user clicks the delete button. The Delete button is right next to the Edit button so it’s fairly easy to mistakenly click it and with an accidental click, the record is permanently deleted with no prompt or warning issued to the user.

WordPress .htaccess Tips and Tricks 0

WordPress .htaccess Tips and Tricks

.htaccess files (or “distributed configuration files”) provide a way to make configuration changes on your Wordpress site on a per-directory basis. A .htaccess file, containing one or more configuration directives, is placed in a particular document directory on your Wordpress site, and the directives apply to that directory, and all subdirectories thereof. Using directives in .htaccess, you can block spam, secure your website, and control other website actions.


Hardening WordPress Security

Wordpress out of the box is fairly secure but there are still some pretty big holes. In addition, hosting environments and installation requirements often introduce gaping security holes in the Wordpress framework. Below are a few best practices to help secure your Wordpress framework.


Port WordPress from DreamHost to 1and1 VPS

I recently moved several WordPress blogs from DreamHost to a new 1and1 Virtual Private Server installation. Here are directions and screenshots of the move along with notes on problems that I ran across (and the resolution I found). I moved from a DreamHost shared host plan that killed scripts when memory consumption exceeded 100MB to a 1and1 VPS solution that provides 4,000MB of burst RAM.

Oracle DBA Notes 0

Oracle DBA Notes

Useful Oracle DBMS Tips and Tricks CHECKING WORKSPACE ALLOCATION On DW’s NT box, click on the svmgr button on the toolbar. Log in as SYSTEM. Click Storage and the Tablespace tab. The percentages are...