James Travis

I currently work for a major US Bank in their internal support service area.

I develop tools and applications used by the call center, division, and corporate employees for various tasks.

I work with the following development platforms:
ASP
Visual Basic
ActiveX
COM/DCOM
.NET
Crystal Reports
VBScript
JavaScript
XML/XSL
HTML
DHTML
VBA with Office 97/2000/XP
SQL Server
Oracle
Informix
Visual C++
Photoshop

I am admin over several severs. Platforms include:
SQL 7 & 2000
IIS 4 & 5
Windows NT 4 & 2000

Currently I have developed or am developing applications for:
Project and employee time tracking
Financial Center/ATM information
Web based password resets for various systems
Call center scheduling and adherence
Inventory
  • Interests: My Family, Programming (Go Figure), Movies, Guitar

PASS Summit 2004 - Another Look

Our longtime member and author, James Travis went with the SQLServerCentral.com crew to the 2004 PASS Summit in Orlando last month. For those of you that don't recognize the name, he goes by Antares686 in the forums and has been generous enough to post over 6,000 times, giving lots of his time and knowledge to helping others. He jotted down a few notes on the conference for those of you that weren't there and are considering going next year.

2004-10-14

3,468 reads

Hidden Dangers!

How many of you register a server in Enterprise Manager? Now how many of you click the "save password" box? Probably most of you. Are you aware of the security risks associated with this? James Travis looks at one of potential problems here and other security issues relating to SQL-DMO.

2004-05-04

7,570 reads

UDF to get first date or trim time for Datepart.

Not long ago I was in a forum discussion when someone presented another way to get the date with time value of midnight by doing similar to thisDATEADD(dd,DATEDIFF(dd,0,@DATE),0)Which I find is much cleaner than any other option I have seen or tried myself. Seeing this I realized there are many other dates that can be […]

4 (1)

2003-05-02

452 reads

Remove old DTS Package versions

This Procedure is what I use to clean out all the old DTS package version on my server periodically. You just place it in the msdb database and run it as you need to.Note: Although I have never had an issue with it, I do suggest backup msdb database beforehand, just in case you wack […]

5 (1)

2002-11-30

289 reads

Blogs

WIT Mental Health and Wellness Videos Posted

By

I was honored to speak at the WIT Mental Health and Wellness day last...

Daily Coping 13 May 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

#PowershellBasics: Comments and comment based help

By

I’ve talked about SQL Server comments before and how important they are. In PowerShell...

Read the latest Blogs

Forums

Limit database restores to specific drive locations

By DrJogalog

As there isn't an option to use a DDL trigger on a RESTORE query,...

VLOOKUP Equivalent in SQL

By Sarah1997

Hi there I have two tables, one with an ID and Amount (Table 1)...

The Gift of Asking Stupid Questions

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Gift of Asking Stupid...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Container Logs

See possible answers