Share on Facebook Share on Twitter Share on Digg Share on Stumble Upon Share via e-mail Print

For latest articles click here

2013

> Earlier articles

Share on Facebook Share on Twitter Share on Digg Share on Stumble Upon Share via e-mail Print

DSNZPARMs: DB2 Systems Configuration Parameters.
Toad World, December 18, 2013.

DB2 Performance Fundamentals.
SSWUG, December 9, 2013.

Thinking About Migrating to Version 11 of DB2 for z/OS?
Database Trends and Applications, December 2013.

A Primer on the Basics of NoSQL Databases.
Database Trends and Applications, November 2013.

Using Check Constraints To Simulate Domains.
Toad World, November 20, 2013.

Webinar: Building a Performance Centric Organization.
Datavail Blog, November 12, 2013.

Dynamic SQL Performance (for DB2).
Toad World, October 23, 2013.

How to ORDER BY an Expression in DB2.
SSWUG, October 22, 2013.

Understanding the Rolling Four Hour (R4H) Average to Control DB2 Costs.
Information on Demand 2013, October 21, 2013.

Metadata Matters.
Insurance Day, October 16, 2013.

Selecting Every Other Row.
SSWUG, October 15, 2013.

The Database Report: 3Q2013.
The Data Administration Newsletter, October 2013.

The DBA’s Guide to Application Development.
Database Trends and Applications, October 2013.

What Does a DBA Do?
Information on Demand 2013, October 1, 2013.

Agility in the Data Center: An Interview With CA Technologies’ Troy Coleman.
Enterprise Executive, September/October 2013.

Database Recovery is a Compliance Issue.
SSWUG, September 26, 2013.

DB2 Developer’s Guide: Helping DB2 Professionals for More Than 20 Years.
Information on Demand 2013, September 25, 2013.

Successful Database Change Management Requires Planning.
Database Trends and Applications, September 2013.

Hunting Down Unused DB2 for z/OS Programs and Indexes.
Toad World, September 20, 2013.

Managing DB2 for z/OS Application Performance.
SSWUG, September 10, 2013.

What’s In a Name? On Database Naming Standards.
SSWUG, September 3, 2013.

High-Level Tips & Techniques for DB2 SQL Performance.
Toad World, August 27, 2013.

DBA Proverbs – More Words to Live By.
Enterprise Tech Journal, August / September 2013.

Bad Database Standards Can Cause Performance Problems.
Database Trends and Applications, August 2013.

Coding DB2 SQL for Performance.
Toad World, July 29, 2013.

How to Become a DBA.
Database Trends and Applications, July 2013.

Issuing SQL Statements in DB2 Utilities.
SSWUG, July 2, 2013.

The Database Report: 2Q2013.
The Data Administration Newsletter, July 2013.

The Ever-Changing Role of the DBA.
The Data Administration Newsletter, July 2013.

First, You Must Define Data Integrity.
SSWUG, June 13, 2013.

Database Administration and Storage Management.
Database Trends and Applications, June 2013.

Managing Database Storage.
SSWUG, May 23, 2013.

DB2 News from IDUG NA 2013.
Toad World, May 20, 2013.

Preparing for Database Application Design Reviews.
SSWUG, May 16, 2013.

SELECT from INSERT, DELETE, UPDATE and MERGE.
SSWUG, May 9, 2013.

General Guidelines for LOAD, REORG and REBUILD Utilities.
Enterprise Tech Journal, May 2013.

Data on the Move: Techniques and Tips to Maintain Control.
Database Trends and Applications, May 2013.

Database Administration in an Increasingly Complex World.
SSWUG, May 2, 2013.

Should Traditional Data Management Concepts
Apply in the Age of Big Data?

Database Trends and Applications, April 2013.

The Database Report: 1Q2013.
The Data Administration Newsletter, April 2013.

Curbing the Curmudgeons in the Corner.
SSWUG, April 1, 2013.

Safeguarding Financial Data.
SSWUG, March 4, 2013.

DBA Rules of Thumb.
The Data Administration Newsletter, March 1, 2013.

Working with Variable Length Data.
SSWUG, February 25, 2013.

Database Recovery Is a Compliance Issue.
Database Trends and Applications, March 2013.

Developing Cross-Platform Database Apps with FileMaker Pro 12.
Database Trends and Applications, February 2013.

Database Capacity Planning.
SSWUG, February 11, 2013.

Recoverability Trumps Performance.
SSWUG, February 4, 2013.

DB2 SQL: Stages 3 and 4.
SSWUG, January 28, 2013.

A Data-Tinged Look Back at 2012.
Database Trends and Applications, January 2013.

The Database Report: 4Q2012.
The Data Administration Newsletter, January 2013.





New Year’s Resolutions for DBAs.
SSWUG, December 2012.

The Scoop on “Dirty Read”
Enterprise Tech Journal, December 2012 / January 2013.

Database Design Traps.
Database Trends and Applications, December 2012.

Data Administration versus Database Administration.
SSWUG, November 2012.

Database Design: From Logical to Physical.
SSWUG, November 2012.

Reading Things That Aren’t There…
and Missing Things That Are!

SSWUG, November 2012.

A DBA By Any Other Name...
Database Trends and Applications, November 2012.

Materialized Query Tables…and the Death of Denormalization?
SSWUG, November 2012.

What Can You Do to Avoid DB2 Locking Problems?
Enterprise Tech Journal, October / November 2012.

The Ever-Changing Role of the DBA.
SSWUG, October 2012.

Denormalization Techniques for Relational Databases.
SSWUG, October 2012.

Performance Management Must Evolve to
Meet Changing Data Warehouse Demands
.
Database Trends and Applications, October 2012.

SELECT from DELETE, UPDATE, and MERGE.
SSWUG, October 2012.

The Database Report: 3Q2012.
The Data Administration Newsletter, October 2012.

The Dirty Read (AKA Uncommitted Read).
SSWUG, October 2012.

DB2 Buffer Pool Essentials.
SSWUG, September 2012.

Surrogate Keys or Natural Keys?
Database Trends and Applications, September 2012.

The Big Deal About Big Data.
Enterprise Tech Journal, August / September 2012.

Using Nulls in DB2.
SSWUG
, August 2012.

Regulatory Compliance and Database Administration.
Database Trends and Applications
, August 2012.

Building a Database Systems Bookshelf.
SSWUG
, August 2012.

Don't Forget DISPLAY as a Part of Your DB2 Tuning Efforts.
SSWUG, July 2012.

Database Archiving for Long-Term Data Retention.
ILM Solutions, July 2012.

Removing Superfluous Spaces.
Database Trends and Applications, July 2012.

The Database Report: 2Q2012.
The Data Administration Newsletter, July 2012.

pureXML: Using XML in DB2 for z/OS.
InformIT, June 2012.

UNIX for DBAs.
SSWUG, June 2012.

The Myth of Information Overload.
The Data Administration Newsletter, June 2012.

Bachelor Programming Syndrome.
Database Trends and Applications, June 2012.

A Short History of DB2 for z/OS.
SSWUG, May 2012.

What is Large?
Database Trends and Applications, May 2012.

Can Data Quality Be Forced?
zJournal, April / May 2012.

The Database Report: 1Q2012.
The Data Administration Newsletter, April 2012.

Harden Your Applications to Combat SQL Injection.
Database Trends and Applications, April 2012.

Making Static SQL More Dynamic...and Vice Versa.
SSWUG, April 2012.

DB2 Tips.
zJournal, February / March 2012.

There's No Such Thing as Information Overload.
SSWUG, March 2012.

Evaluating a DBA Job Offer.
Database Trends and Applications, March 2012.

Four Non-Technical Steps to Data Security.
SSWUG, February 2012

Supporting Temporal Data in the Database.
Database Trends and Applications, February 2012.

Avoiding Bachelor Programming Syndrome.
SSWUG, January 2012

A Resurgence of Metadata Management.
SSWUG, January 2012

The Database Report: 4Q2011.
The Data Administration Newsletter, January 2012.

A Data-Tinged Look Back at 2011.
Database Trends and Applications, January 2012.

Security Improvements in DB2 10 for z/OS.
zJournal, December 2011 / January 2012.


2012

Minimizing Lock Contention Issues.
datAvail Blog, December 30, 2014

DB2 Compression: z/OS versus LUW.
datAvail Blog, December 16, 2014

Controlling the Rolling Four Hour Average and DB2 Costs.
Toad World, December 10, 2014

The Aging Mainframer.
datAvail Blog, December 4, 2014

What Can You Do to Avoid Database Locking Problems?
Database Trends and Applications, December 2014.

Top 10 Steps to Building Useful Database Indexes.
Database Trends and Applications, November 2014.

A Sample DBA Job Posting.
Toad World, October 24, 2014.

Improving Data Integrity Using Check Constraints.
Database Trends and Applications, October 2014.

How to Assure Data Integrity in DB2 for z/OS.
Toad World, September 26, 2014.

A Short History of DB2 for z/OS.
Database Trends and Applications, September 2014.

The Danger of Dirty Reads.
Database Trends and Applications, August 2014.

DB2 Optimization and Access Paths: Understanding the Basics [Part 2].
SSWUG, July 28, 2014.

DB2 Optimization and Access Paths: Understanding the Basics [Part 1].
SSWUG, July 21, 2014.

The Ten Database Commandments to Ensure an Effective, Accurate, Well-Designed Database.
Database Trends and Applications, July 2014.

Database Auditing on DB2 for z/OS.
Enterprise Tech Journal, June / July 2014.

Database Standards and Procedures.
Toad World, June 24, 2014.

Counting Characters Using Only SQL.
SSWUG, June 16, 2014.

Regulatory Compliance Requires Metadata and Data Quality Programs.
Database Trends and Applications, June 2014.

Using REOPT to Control SQL Dynamism in DB2 for z/OS.
Enterprise Tech Journal, May / June 2014.

Avoid Black Boxes to Optimize DB2 Application Efficiency.
Toad World, May 28, 2014.

A SQL Trick to Eliminate Unwanted Spaces.
SSWUG, May 27, 2014.

Introduction to Recursive SQL.
Database Trends and Applications, May 2014.

Best Practices for Upgrading to a New DBMS Version.
Toad World, April 30, 2014.

Advanced Analytics Projects Offer Value.
Database Trends and Applications, April 2014.

The Database Report: 1Q2014.
The Data Administration Newsletter, April 2014.

Required Types of Performance Monitoring and Tuning for DB2 Applications.
Toad World, March 24, 2014.

Database Contingency Planning - Preparing for Disasters You Hope Won’t Happen.
Database Trends and Applications, March 2014.

Top Ten Steps to Building the Right Indexes.
Toad World, February 28, 2014.

Gaining an Appreciation of Metadata Through Music.
Database Trends and Applications, February 2014.

Compression Improvements Ease Big Data Burdens.
Toad World, January 22, 2014.

A Data-Tinged Look Back at 2013.
Database Trends and Applications, January 2014.

The Database Report: 4Q2013.
The Data Administration Newsletter, January 2014.


2014

For 2013 articles click here

For 2012 articles click here

Best-selling book for DBAs - for learning and reference