wordpress : get all category names with the number of post in each category

a sql query to print all category names with the number of post in
each category for each month

"SELECT count(*), wp_terms.name FROM wp_term_taxonomy AS
wp_term_taxonomy INNER JOIN wp_terms ON wp_term_taxonomy.term_id =
wp_terms.term_id INNER JOIN wp_term_relationships ON
wp_term_taxonomy.term_taxonomy_id =
wp_term_relationships.term_taxonomy_id INNER JOIN wp_posts ON
wp_term_relationships.object_id = wp_posts.ID WHERE
wp_posts.post_status = 'publish' AND wp_posts.post_type = 'post' AND
wp_term_taxonomy.taxonomy = 'category' and wp_posts.post_date like
'2011-11' GROUP BY wp_terms.name

Anti-spam techniques

http://en.wikipedia.org/wiki/Anti-spam_techniques

nice perl scipts by akadia

http://www.akadia.com/services/perl_important.html

unix/shell scripting programming

 experience on Unix and Linux with expert knowledge of shell scripting, preferably ksh, sound knowledge of databases. Should be knowledgeable in Java. Java development experience would be desirable.
• Experience in architecting and designing solutions for batch processing using shell scripting is required. Hands-on experience in writing and debugging shell scripts that invoke j2SE or J2EE modules for at least .
• Expert knowledge of utilities like SFTP, MAIL, SORT , etc in Linux environment.
• Demonstrate ability in reverse engineering existing scripts and redesign it for better performance
• Experience with version control tool like subversion, etc.
• Good knowledge of Oracle and DB2 database from an application perspective. This includes but not limited to SQLs, PL/SQL, Stored Procedures and application performance impacted by database access 
 -------------
C++ with Linux/Unix as a platform, SQL as a database and some sort of scripting knowledge i.e Perl/Shell/Python. 

 

popup jquery

http://tutorialpot.com/2011/08/jquery-popup-2/

perl based application

https://www.socialtext.net/perl5/applications

linux stuff to do

http://www.thegeekstuff.com/

archive centos iso repository

http://vault.centos.org

good site for php ajax jquery javascript

http://roshanbh.com.np/

things to learn in linux

  

Advance administrative tasks on OS linux
  Linux Server, Installation and configuration of Apache, FTP, DNS, DHCP, SAMBA Server,       networking, RAID configuration on LINUX platforms
  Troubleshooting issues of linux Operating System.
  Snapshot based backup technology.
  Build and support complex linux systems of physical and virtual(XEN based).
  experience on another Open Source Hypervisor such as VBox, KVM with experience on P2V,  V2P, BMR
  Backup solutions Veritas / Arc serve / NTBackup.

  large server cluster
  systems automation
  Amazon EC2, SQS, S3
  tools like Puppet, MemCached, Varnish, TokyoCabinet, HAProxy, Nagios, Cacti, Ganglia, and MySQL
  C and Kernel programming, multithreading and synchronization
  Linux kernel, driver development and troubleshooting
  OS concepts, multiprocessing, File Systems, Virtual Memory
  processor architecture, SMP systems, memory hierarchy
  high availability database driven environments.
  Apache HA, High Availability, SAN, DRBD, Load balancing, TCP/IP, database driven environment
  Load Balancing, DRBD, Apache HA,  IP tables,  Web application
  VMWare ESX / vSphere
  RedHat Cluster
  Sun Cluster
  EMC and Hitachi SAN storage and zoning
  Fault Tolerant networking, High Availability
  VMware : Clustering, High Availablity, Dynamic Resource Scheduling
           Storage distribution
           Switches, physical networking
           VMWare Certified Professional
           FibreChannel storage

  Loadbalancers, Packet Filtering, IPFilter, Security, Penetration testing, Break/Fix  
  install, tune, troubleshoot, apply patches and support Web servers and integrate third party applications Responsible for uptime of the Web severs and improving performance

  knowledge in conducting VAPT and providing solutions
  knowledge of source control management.
  Knowledge in ethical hacking and information security management systems
  implementation and maintenance of web analytics
  Apache, Tomcat and IIS web servers administration
  nmap, snmpwalk, nessus, dnswalk, libwhisker, strace
  HP Openview, Nagios, ZenOSS
  Automated Web Application Stress Testing
  Tomcat, and Bea Weblogic java application servers
  openldap, slurpd to syncrepl migration, ldapsearch

  Advanced usage of sniffers for network troubleshooing and optimization
  tcpdump, ethereal, and ngrep all covered indepth
  Linux and Unix proactive system hardening
  tcpdump, ntop, ethereal / wireshark
  Apache Web Server, Bind DNS,

  Vulnerability scanning and network penetration testing of customer facing applications
  Customized and branded Perl open source web metrics reporting software for intranet usage statistics