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

SQLServerCentral Article

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,470 reads

SQLServerCentral Article

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,579 reads

Technical Article

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

462 reads

Technical Article

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

295 reads

Blogs

Daily Coping 20 May 2020

By

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

Daily Coping 19 May 2022

By

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

Running dynamic SQL in a different database

By

This is one of those things that on hindsight was a stupid problem, but...

Read the latest Blogs

Forums

Running Trace - Error: Login timeout expired

By ramana3327

Hi All, We have Project server 2019 (Sharepoint). The database server (Only Database services...

query perf issue

By siri_28

Hi Everyone, Good morning. I am new to Sql administration.Have one question. We work...

Looking for some guidance on avoiding Scalar UDFs for DB lookups

By SteveOC

Hello. I am not a SQL Developer - just an IT generalist (if that)...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers