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 performance
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)
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 
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 
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.