Monthly Archives: August 2015

Optimizing Database Performance, part 5: Database Reorganization

Portions of this tip were excerpted from my book Database administration: The complete guide to DBA practices and procedures (2nd edition). The first , second , third, and fourth parts of this series are also available. Today’s topic is reorganization. Relational technology and … Continue reading

Posted in DBA | Tagged , , , | 5 Comments

Optimizing Database Performance, part 4: File Placement and Page Sizing

Portions of this tip were excerpted from my book Database administration: The complete guide to DBA practices and procedures (2nd edition). The first , second , and third parts of this series are also available. Today we start by discussing file placement and data … Continue reading

Posted in database design, DBA, performance | 3 Comments

Optimizing Database Performance, part 3: Free Space and Compression

This tip is excerpted from my book Database administration: The complete guide to DBA practices and procedures. The first and second parts of this series are also available. Today we start by discussing free space. Free Space Free space, sometimes called … Continue reading

Posted in DBA | Tagged , , | 5 Comments

New API Security Survey Highlights Mobile Security Concerns

A new survey on API security titled Global State of API Security Survey 2015, conducted by API management vendor Akana, was released today. This is the first survey conducted by Akana on API Security. The survey offers up a lot of interesting findings for those … Continue reading

Posted in DBA | 1 Comment

Optimizing Database Performance, part 2: Denormalization and Clustering

In Part 1 of our series introducing database performance topics and considerations we tackled the issues of partitioning data and creating indexes. In Part 2, today, we will introduce the topic of denormalization and clustering. Denormalization Another way to optimize the … Continue reading

Posted in DBA | Tagged , , , , | 6 Comments