NetAdmin Newsletter
CPTTM Network Admin newsletter issue #27, Kent Tong, Editor in Chief

Dear Network Administrators,

This CPTTM NetAdmin newsletter is to bring useful news to you, Network Administrators in Macau, for references without obligations, so that you can do your jobs easier and better! Hope you like it. if you'd like to unsubscribe or recommend your friends to subscribe, just email me at kent@cpttm.org.mo. Old issues are available here. Also printable version for this newsletter.

Topics in this issue:

SQL tuning can dramatically improve the DB performanceoracle

What is SQL tuning? Suppose you have a table like below in your DB:

product_id name price Description
p1 Pen 1.2 ...
p2 Eraser 2.5 ...

If you have an application that looks up products using product names, using a SQL like "select * from products where name=?", because the name is not the primary key, each such query will force the DB server to scan the whole table and will slow it down a lot. An easy way to fix it is to create an index on the product name. This will make a huge improvement in performance. I know, because I did it some time ago.

Of course, this is a simple fix.  In practice, you need to follow a proven methodology, e.g., how to identify the queries generating the most total load in a certain period (i.e., most frequently used and each taking up a lot of time).  There are also useful tools to help you in the process. To learn all these issues, please join our upcoming Oracle 10g SQL Tuning Workshop (Official course), delivered by Oracle instructor from HK.

If you plan to take the OCP certification, you must take an official Oracle course such as this one.

Host-based intrusion detection system (HIDS)OSSEC

If you care about security, you should consider monitoring the logs and any changes to system files on your servers. Obviously it would be cool if you can just sit in front of a centralized web-based management console and see everything happening, no matter the servers are running Windows, Linux or Solaris. Now, you can do it without spending a dime! Check out the open source OSSEC system.

It was rated as the number two intrusion detection system (IDS), following Snort which is a popular network-based IDS that inspects network traffic instead of host logs and files. It means that OSSEC is considered the best host-based IDS around.

Much better way than sharing administrator passwords sudowin

You and your colleagues may login as the administrator to perform administrative work. So you all know the same password. This is really a poor practice. Why? If one of you leaves the company, for security you will have to change the password. If you have 30 such administrator accounts (e.g., OS,  routers, DBMS, ...), then you'll have a lot of work to do and a lot of new passwords to memorize!

A much better way is to use a program called "sudo" (available for Linux and Windows). It works like this: You disable the administrator account and each of you will use a separate ordinary user account. No one knows the administrator password. You configure sudo to recognize these ordinary user accounts. When any of you needs to perform administrative work, you can ask sudo to launch a command prompt or an EXE as the administrator (e.g., "sudo su"). Recognizing the user accuont, sudo will do as told without you entering any password. To trade convenience for better security, you can configure sudo to prompt you for your ordinary account's password. This way, any of you can become the administrator without sharing any common password. If someone leaves, simply delete his ordinary user account and remove it from sudo.

How is sudo different from the runas command in Windows? With runas, you have to enter the administrator account password. With sudo, you only enter your ordinary user account password.

In addition, you can configure sudo to only allow a user to execute a specific command as root. This is useful to delegate simple tasks to junior administrators or power users. For example, at Cyber-Lab, we configure it to allow our part-time technicans to restart our DHCP server using "sudo /etc/init.d/dhcpd restart". 

Last chance to learn Cisco PIX and ASA Cisco

The Cisco Networking Academy Program is moving toward the associate level CCNA Security certification (router IOS security). The stuff regarding PIX and ASA will remain in the professional level CCSP certification. As a regional academy in Macau, we will be focusing our training on  the CCNA security certification too in 2009. If you'd like to learn PIX and ASA, here is your last chance: Cisco Networking Academy Program (Fundamentals of Network Security) to be started on Nov 20. Please hurry.

Upcoming courses for network administrators

Course code Title Start date Duration (hours) Fee (MOP) Remarks
CM206-11-2008-C Cisco Networking Academy Program (Fundamentals of Network Security) 2008/11/20 54 5800
CM232.2-11-2008-C CCNP 2 - Building Cisco Multilayer Switched Networks (BCMSN) 2008/11/15 45 5200
CM232.3-02-2009-C CCNP 3 - Building Scalable Cisco Internetworks (BSCI) 2009/02/14 69 6150
CM232.4-06-2009-C CCNP 4 - Optimizing Converged Cisco Networks (ONT) 2009/06/06 36 4180
CM261.3-03-2009-C LPI-Linux Network and Security Administration 2009/03/30 69 2500
  • Only a few seats left
  • Up to 50% course fee reimbursement
CM298.3-11-2008-C Network+ Certification 2008/11/13 49.5 1600 Up to 75% course fee reimbursement
CM323-12-2008-C Microsoft official course: MCITP Server Administrator Program 2008/12/3 108 6500 Official Microsoft course on Windows Server 2008

In addition, there are some interesting IT courses for your kids:

Course code Title Start date Duration (hours) Fee (MOP) Remarks
CM275-11-2008-C Computer games DIY for the youth 2008/11/29 32 980
  • Let your kids learn how to program by creating games!
  • Up to 75% course fee reimbursement
CM328-11-2008-C Interactive animation course for Primary and Secondary students 2008/11/23 12 450
  • The best way for kids to learn programming concepts by animating  sprites!
  • Up to 75% course fee reimbursement
CM345-11-2008-C 3D interior Design for Brilliant Kids 2008/11/30 10 380
  • Let your kids design their own dream houses in a 3D scene!
  • Up to 75% course fee reimbursement

Feedbacks

Any questions, ideas or experiences to share? Contact me at 88980601 or kent@cpttm.org.moWe also have 3 more newsletters: CIO newsletterSoftware developer newsletter and E-flow newsletter.

Until next time, 

Kent Tong

footer