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

454 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

291 reads

Blogs

Goal Progress for July 2021

By

I set goals at the beginning of the year, and I’m tracking my progress...

Data Modeling at your fingertips

By

(2021-July-30) A picture is worth a thousand words, the same way a visual database schema...

How to put a SQL Server Database into Recovery Pending

By

You might be asking why on earth would you want to get a database...

Read the latest Blogs

Forums

How is Throughput optimized HDD (st 1)

By kratosrules99

Hi Everyone. i am planning to shift my website to AWS   I want...

Alternative to LAG(SUM) - Can a Column Reference The Sum of the Values Above It

By John O'Connor

Hi Everyone, I'm trying to do something that seems pretty simple, but SQL Server...

Transaction log shrink w/ logshipping

By mavelzen

Hello everyone, Again with this question. 🙂 I've got a log-shipped database, and I...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers