Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Posted Mar 11, 2010

Lockwood Lyon

By DatabaseJournal.com Staff

Lockwood Lyon
Lockwood Lyon is a systems and database performance specialist. He has more than 20 years of experience in IT as a database administrator, systems analyst, manager, and consultant. Most recently, he has spent time on DB2 subsystem installation and performance tuning. He is also the author of The MIS Manager's Guide to Performance Appraisal (McGraw-Hill, 1993).

Current Articles

IBM Db2 for z/OS Useful Features
Doing Analytics Against Critical Production Data
The Demise of the DBA
The Demise of Big Data
IBM Improves IT Operations with Artificial Intelligence
Data Masking in the World of GDPR
IBM Db2 Query Optimization Using AI
HTAP - Hybrid Transaction and Analytical Processing
Big Data: Health Checking Your System
IBM Db2 Statistical Functions for Analytics
IBM Offers AI-Assisted SQL Tuning
Db2 Application Performance Enhancements
High-Performance Data Encryption and Db2
Big Data Analytics on Current Data
GDPR for the DBA
5 More Features of IBM Db2 12 for z/OS
5 New Features for Db2 12 for z/OS
Modern Database Disaster Planning
Modern Enterprise Data Integration
Supporting Operational Systems in a Big Data World
Using Real Memory to Enhance Performance in Db2
IBM Db2 for z/OS: Version 12 New Features
Database as a Service: An IT Strategic Direction
Database as a Service: Defining Quality
Database as a Service: Choosing a Provider
Database as a Service: Performance Tuning
Database as a Service: Your First Application
Database as a Service: Outlook Cloudy
Database as a Service: A Practicum
Big Data DBA Support Strategies
DB2 V12 Features Supporting Large Databases
Updating Production Environments to Feed a Big Data Application
DB2 and BigData 2.0
Basic DB2 System Tuning Strategies
Basic DB2 Application Tuning Strategies
Automating Data Warehouse Support
DB2 Data Warehouse Capacity Planning
Is Your DB2 Subsystem Healthy?
Is Your Database Healthy?
The End of Big Data
Big Data Architecture
Analytics Yes; Big Data No!
Big Data Quality Assurance
Load Testing Your Big Data Application
Big Data Performance Tuning
Integrating Big Data Applications into Operational Environments
Big Data: Planning for Peak Season
Ensuring Data Availability in Critical Big Data Applications
Staffing Your IT Organization for Big Data
Prepping Big Data for High Performance
Tricks for Integrating Big Data into Your Data Warehouse
DBA Workloads Change as Big Data Solutions Mature
Disaster Recovery and Big Data
Exploding the Myths of Big Data
Another Look at Tuning Big Data Queries
Managing the Big Data Technical Staff
Big Data Holiday Planning!
IT Budget Planning for Big Data
Preparing Your Enterprise for Big Data
Integrating Big Data into the Enterprise Data Warehouse
Big Data Technologists Transition to Customer-Facing Roles
Managing Big Data DBAs
Do You Really Need to Tune Big Data Applications?
Do We Still Need Database Design in the Era of Big Data?
Big Data Quality Metrics
Load Testing in a Big Data Environment
Big Data: Integration with Little Data
Disaster Recovery and the Big Data Application
The DBA's Big Data Holiday Wish List
Getting Ready for Big Data: Prepping the Data Warehouse
Tuning Distributed Applications to Access Big Data
Database Backup and Recovery in the Age of Big Data
The Database Administrator's Back-to-School Checklist
The Big Data DBA
Performance Tuning in the Age of Big Data
Managing the Transition to Big Data
Application Design: Where the DBA Fits In
The Trouble with SQL Tuning
Managing the Database Administrator
Techniques for Analyzing Historical DB2 Application Performance Data
Tuning an IBM DB2 for z/OS Application: Transaction Times
The DB2 Database Administrator's Christmas Wish List
Database Recovery Options
Big Data Means Big Performance
Strategies for Improved Data Availability in DB2
Reducing Application Contention
Motivating the DBA
Tuning an IBM DB2 for z/OS Application: I/O Constraints
DB2 Application Design for Big Data
Tuning the DB2 on z/OS Data Warehouse
DB2 for z/OS Version Migration - Top 10 Issues
DB2 z/OS Systems Tuning Tactics
Thoughts on Improving DBA Productivity
Managing a Data Warehouse with DB2 on z/OS
Four Strategies That Every DB2 z/OS DBA (or any DBA) Should Know
Tuning Your ERP System for DB2
Monitoring an ERP Application in DB2 for z/OS
DB2 for z/OS Database Recovery - Get it Right
Dynamic SQL Performance Tuning Techniques for IBM DB2 z/OS
Performance Tune IBM DB2 z/OS Applications using Resource Constraint Analysis
Logical and Physical Locking in IBM DB2 for z/OS
The Effect of Function Invocation on SQL Query Performance in IBM DB2
Tuning an IBM DB2 for z/OS Application: CPU Constraints
IT Management's Top 10 List of DBMS Requirements
How DBAs Can Tune Distributed IBM DB2 Applications
Quality and Database Design
IBM DB2 Error Checking
Why IBM DB2 DBAs Love Load Testing
Referential Integrity: Best Practices for IBM DB2