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

455 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

292 reads

Blogs

Ethics in Modern Data at Music City Tech 2021

By

  On Sept 16, Christine and I presented our joint presentation on Ethics in Modern Data at...

Slides and Video from Building a Regret-free Foundation for your Data Factory Now Available

By

Last week, Kerry and I delivered a webinar with tips on how to set...

Daily Coping 16 Sep 2021

By

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

Read the latest Blogs

Forums

There is insufficient sys memory in resource pool 'internal' to run this query

By WhiteLotus

Hi All, I have an issue with production server , from SQL error log...

Getting the JSON Index

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Getting the JSON Index

A Great Use for AI

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Great Use for AI

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers