Articles
Java: Connecting to LDAP/Active Directory using JNDI (Java)
Learn how to connect and search LDAP or Active Directory (Microsoft's LDAP Implementation) using Java's JNDI API. (Read More)


Filed under Articles > Programming > Java
(Posted By: Troy Campano on 2008-09-07)


Agile: Lean Software Development - An Agile Toolkit
Recommended Book: Lean Software Development describes some of the ways you can take the lean principles of the manufacturing world and apply them to the field software development. (Read More)


Filed under Articles > Programming > Agile
(Posted By: Troy Campano on 2008-03-16)


Linux / UNIX: OpenSuse 10.2 Screenshots
Various screenshots from the aesthetically appealing OpenSuse 10.2 Linux Desktop. (Read More)


Filed under Articles > Operating Systems > Linux / UNIX
(Posted By: Troy Campano on 2007-02-19)


Java: Copying and Pasting Java Code in RAD Loses Your Formatting
Have you tried copying your java code from Rational Application Developer (RAD) to another application and found that your code loses its formatting? This article explains why. (Read More)


Filed under Articles > Programming > Java
(Posted By: Troy Campano on 2006-08-30)


Oracle: My Article in SysAdmin Magazine!
I have an article coming up in SysAdmin magazine that focuses on using Oracle Statspack to monitor and report on Oracle database performance. (Read More)


Filed under Articles > Databases > Oracle
(Posted By: Troy Campano on 2006-05-25)


Oracle: Using SQLPLUS, Import, and Export Without a Password
Storing passwords in plain text in your shell scripts can be a bad practice. If you need to run an export or import from a script and do not want to store your password in the script, you can perform the import/export as SYSDBA. As long as you're in the dba/oradba group and can log into Oracle as SYSDBA without a password you can perform your imports and exports without a password as well. (Read More)


Filed under Articles > Databases > Oracle
(Posted By: Troy Campano on 2006-01-10)


Oracle: Dropping Your Default Oracle Temporary Tablespace
Dropping your default oracle temporary tablespace can be tricky. You cannot simply issue a drop tablespace command because oracle does not allow it. This article will cover the steps needed to drop and recreate your default temporary tablespace. (Read More)


Filed under Articles > Databases > Oracle
(Posted By: Troy Campano on 2006-01-04)


Oracle: A Look at Oracle's Project Raptor
Oracle has released a new graphical tool called "Project Raptor". It's like Oracle's Enterpise Manager, but it is geared more towards an application developer than a DBA. WIth this tool you can create objects, select and modify data, and much more. Best of all, it's free! (Read More)


Filed under Articles > Databases > Oracle
(Posted By: Troy Campano on 2006-01-03)


Oracle: Statspack 101: Interpreting Your Statspack Report
In my last article, I discussed how to install Oracle's Statspack Utility; a free tool for monitoring your Oracle database instance. That article also discussed how to generate a Statspack Report. This article will help you interpret a lot of the information you will find in a statspack report. (Read More)


Filed under Articles > Databases > Oracle
(Posted By: Troy Campano on 2005-12-13)


Oracle: Statspack 101: Installing Oracle's Statspack Utility
Oracle's Statspack is a free utility that allows you to monitor and report on performance problems with your Oracle database. In this tutorial we will install Statspack on an Oracle 9i database though it should work similarly with other versions of Oracle. (Read More)


Filed under Articles > Databases > Oracle
(Posted By: Troy Campano on 2005-11-28)


Oracle: How Oracle Searches for Configuration Files
Do you have trouble finding which tnsnames.ora or listener.ora is the one on your computer that Oracle is actually looking at? There's a few places that Oracle looks for its configuration files (tnsnames.ora, sqlnet.ora, listener.ora, and oratab). (Read More)


Filed under Articles > Databases > Oracle
(Posted By: Troy Campano on 2005-06-28)


Linux / UNIX: Searching for Files in UNIX and Linux
This article explains how to use the 'find' command to search for files, files that contain certain strings, large files, files that changed within the last day as well as taking a look at the 'locate' command. (Read More)


Filed under Articles > Operating Systems > Linux / UNIX
(Posted By: Troy Campano on 2005-06-22)


Oracle: Working with XML data in an Oracle Database: Part 1
Is your application using XML to store data? With Oracle 9i and above you can store your XML in the database and query it to pull out the pieces of data that you need. (Read More)


Filed under Articles > Databases > Oracle
(Posted By: Troy Campano on 2005-06-22)


Oracle: Extracting Oracle DDL from a SQL Command Line
Need to extract DDL from a table in an Oracle database but don't have a tool to do so? Don't fret, you can query Oracle's Metadata API to retrieve the DDL or even XML on the given object. This works with oracle 9i and above. (Read More)


Filed under Articles > Databases > Oracle
(Posted By: Troy Campano on 2005-06-12)


MySQL: Importing and Exporting data in MySQL
Have you ever needed to export data from a MySQL database to back it up or recreate a database on a separate computer? The mysqldump utility will allow you export the entire database and the mysql utility will let you load it back in. (Read More)


Filed under Articles > Databases > MySQL
(Posted By: Troy Campano on 2005-01-27)


Article Categories
Databases  
  PostgreSQL 0
  Oracle 10
  MySQL 1
Operating Systems  
  Linux / UNIX 2
  Windows 0
Programming  
  Agile 1
  Java 4
  PHP 0
Web/App Servers  
  Tomcat 1
  Apache 0

Search
 
troygeek.com Web

Blog
Reading The Art of Agile Development
I am currently reading The Art of Agile Development, an O'Reilly book by James Shore & Shane Warden. It's been a great read so far describing tons of different agile processes. Hope to write a review ... (more)
Postgresql 8.1 Released
Postgresql 8.1 was released the other week. Some of the new features include:

  • Introduction of "Roles"
  • Two-Phase Commit
  • Table Partitioning
  • Shared Row Lockin... (more)



  • Donate
    Help us keep this site going. Hosting costs are expensive. Any donation is appreciated.


    Find some of this content useful? Please consider a donation. Any donation is appreciated.