Publications


ARTICLES
Encrypted Columns in ASE
Database Encryption Design Considerations and
Best Practices for ASE 15
Mining the Meta Data
Talent
BOOKS
Systems Administrator’s Guide to Sybase
ASE 15,” Wordware
“Sybase ASE 12.5 Performance and Tuning,”
Wordware
“Sybase ASE 12.5 High Availability
Server,” Wordware
“Systems Administrator’s Guide
to Sybase ASE 12.5,”
“Learn to Administer Microsoft
SQL Server 2000,” Wordware
“Learn to Administer Microsoft
SQL Server 7,” Wordware
“MCSE Database Design on SQL Server
7 Exam Cram,” Coriolis Press
“MCSE System Administration of
SQL Server 7 Exam Cram,”
Coriolis Press
“Optimizing SQL Server 7: Planning and Building a High
Performance Database,”
Prentice-Hall, January 1999
“Microsoft 6.5 Unleashed,”
SAMS (Macmillan), March 1997
“Microsoft 6.0 Unleashed,”
SAMS (Macmillan), March 1996
“Sybase System 11 Unleashed,”
SAMS (Macmillan), April 1996
“Sybase System 11 DBA Survival
Guide, ” SAMS (Macmillan),
May 1995
“Sybase
DBA Survival Guide,” SAMS
(Macmillan), April, 1995
Periodicals
“Using
autogrow and autoshrink on tempdb”,
Reviewnet Author Newsletter
Question / Article on SQL Server Administration,
March 2003
“Understanding Join vs.
Union”,
Reviewnet Author
Newsletter Question / Article on SQL Server
Administration, February 2003
“Views and Performance”,
Reviewnet Author Newsletter
Question / Article on SQL Server Administration,
December 2002
“Recommended Backup
Frequencies”,
Reviewnet Author Newsletter Question / Article on
SQL Server Administration, October 2002
“Clustered vs.
Nonclustered Indexes”,
Reviewnet Author Newsletter Question / Article on
SQL Server Administration, August 2002
“Mining Sybase
Metadata,”
The Embarcadero, Issue #3,
September, 1999
“Lock Configuration for
Sybase System 11,”
Sybase Developer’s Journal, April 1997
“Preventive Maintenance
for Sybase System 11,”
2-part article, Sybase Magazine, 1997
Columnist, Managing the
Client / Server World,
DM Review, 1994-1996 (Monthly),
management issues in Client / Server environments.
“Tools for Very Large
Sybase Databases,”
PowerBuilder Developer’s Journal, Sybase Corner,
November 1995.
“The Client Server
Trend,”
European Business
Report, Spring 1995 (German magazine published
in English).
“VLDB Design Issues in a
Sybase Environment,”
SQL Forum Journal, March / April 1994.
“Care and Feeding of the
Sybase Production Server, a Preventive Maintenance
Regimen” SQL Forum
Journal, September / October 1993.
“Lessons Learned the
Hard Way: Common Performance and Tuning Gaffes in
the Sybase Pilot Application,”
SQL Forum Journal, July / August 1993.
“Rightsizing the
Mainframe Application,”
Boxes and Arrows Magazine, January 1994.
“Bring out Your Dead,”
a treatise on managing technology changes among DP
Professionals, Boxes and Arrows magazine,
March 1993.
“Implementing the
Cooperative Processing Application,”
Boxes and Arrows magazine, January 1991.
“Cooperative Processing
in the IDMS Environment,”
a series of three articles appearing in the June,
July, and August 1990 issues of Boxes and
Arrows magazine. |
|
Some
old favorites



.jpg)
Jeff's
BLOGS

I've been consulting on
and performing technical training for MS SQL Server since
1989, Version 4, on OS/2, and Sybase ASE since release 4.0.1.
Since then, I've worked extensively with each release of the
product, specializing in performance and tuning, from concept
through legacy system, on systems of all sizes, from small
start-up company applications to multi-terabyte data
warehouses. I have been working on large-scale systems for
most of that time, having tuned a 100-gig/week throughput
application on MS SQL Server 6, and created one of the first
ASE data warehouses. My background includes work experience
from PC's to Mainframes and back again, in all aspects of IT,
from developer, to DBA Manager, to IT Executive. My specialty
is performance and tuning with a special emphasis on
large-scale projects with very large databases.
|