SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Guest Columnist: James Travis

SQLServerCentral.com profile

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

   Items 1 to 7 of 7   

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.   Read more...
By James Travis 2004/10/14 | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 3,465 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.   Read more...
By James Travis 2004/05/04 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 7,565 reads

Review of Guru's Guide to SQL Server Architecture and Internals

If you are (or want to be) a power user, this book should be on your shelf. How many books have you read that have you using a debugger to step into the sql server process? James gives it a thumbs up!   Read more...
By James Travis 2004/04/07 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 6,467 reads

Review of Programming Microsoft SQL Server 2000 with Microsoft Visual

We get books in occasionally for review and have started making them available to our existing authors. Jim was interested in this one - turns out he didn't find much to like. If you're a beginner it might be a better fit. Or maybe you've read the book and disagree?   Read more...
By James Travis 2004/03/16 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 4,858 reads

Understanding the difference between IS NULL and = NULL

This article by James Travis details the differences between IS NULL and = NULL. He also discusses the ANSI_NULLS setting.   Read more...
By James Travis 2008/02/22 (first published: 2003/06/17) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 129,071 reads

What is the search order for Procedures prefixed sp_?

In this article, James Travis covers a common performance topic of prefixing stored procedures sp_. Does it really slow down performance?   Read more...
By James Travis 2002/11/14 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 6,744 reads

How to Fix Inconsistent Metadata Errors

Why does changing a table on a SQL Server 7.0 server cause "OLE DB provider 'SQLOLEDB' supplied inconsistent metadata. An extra column was supplied during execution that was not found at compile time." to occur when query the table from a SQL Server 2000 server via link to other. In this article by James Travis, he shows you what the problem is and how to fix it.   Read more...
By James Travis 2002/02/28 | Source: SQLServerCentral.com | Category: bugs
Rating: |  Discuss |   Briefcase | 12,337 reads
   Items 1 to 7 of 7