Aside from BMC Remedy, another product that I’ve recently had to learn more about is Microsoft SQL Server. From writing my first stored procedure, to a function, to jobs and alerts. One of the tidbits I came across is a way to list all databases on SQL server. To do this,  try:

Select * From sysdatabases

or

Exec sp_helpdb

To change the default port for SQL Server 2005 follow the steps listed below:

1. Open SQL Server Configuration Manager which is found under Microsoft SQL Server 2005 > Configuration Tools
2. In the SQL Server Configuration Manager window, expand SQL Server 2005 Network Configuration
3. Click on Protocols for
4. Right click on TCP/IP and select Properties
5. In the TCP/IP Properties box, click on the IP Addresses tab
6. If the TCP Dynamic Ports dialog box contains 0, indicating the Database Engine is listening on dynamic ports, delete the 0.
7. In the TCP Port box, type the port number you wish this IP address to listen on, and then click OK
8. Restart the SQL Server instance and the port changes will be applied to the respective instance.

For more information about Configuring a SQL Server to listen on a specific port visit How to: Configure a Server to Listen on a Specific TCP Port (SQL Server Configuration Manager)

To change the default location of SQL 2005 files, follow the instructions below:

1. Open SQL Server Management Studio
2. Right click the server name and choose Properties
3. On the Server Properties page, select Database Settings
4. Under Database default locations type in the path to the respective locations for Data and Logs.

One thing I learned while trying to setup default paths is that SQL expects data files to be found in a child directory named Data. For more information about SQL Server 2005 paths visit File Locations for Default and Named Instances of SQL Server 2005.