Category: Technology

  • Rename sa

    With SQL Server 2005, you can rename your logins, including sa. To me, this is a HUGE security enhancement. For mixed security environments, many Sql Server attacks take advantage of the sa account, either by brute-force or dictionary attacks. I highly recommend you to rename sa to something that is discreet to minimize attack surface […]

  • Failed nbsmtp compile and some Linux and RPM tips

    Earlier, I talked about my failed attempt to comiple and install msmtp. I tried to install and compile nbsmtp, and got similar results. Googling revealed that many people would suggest install things from an RPM package. So I searched around and found a msmtp package for Suse, but my web host is on RedHat. I […]

  • Generate Oracle objects DDL using dbms_metadata.get_ddl

    Since Oracle 9i, Oracle added a new utility called dbms_metadata.get_ddl. This utility provides you with object DDL generated out of Oracle Data Dictionary. It is extremely handy and useful. For example, you can use: set long 500000 select dbms_metadata.get_ddl(‘TABLESPACE’,’TablespaceName’) from dual; to get a particular tablespace’s DDL. You can also use it for users, role, […]

  • msmtp compile and install

    This is kind of my own Linux admin study notes. Like most of my other posts, it can be dry and boring;) In an earlier post, I talked about my desire to compile Mutt and use it as my primary email client. Note there is a little more information on the comment section. Things have […]

  • Use USB Flash Drive on Linux

    In Linux, any disk drive has to be mounted first before you can use it. That actually is true for Windows also. But Windows shields a lot of that away from a regular user. Unlike Windows, there is no A: or D: drives for you to go directly in Linux, although I’ve heard that some […]