Category Archives: DBA

A Dozen SQL Rules of Thumb, Part 2

Today’s blog post picks up where we left off in our three-part series of rules of thumb (ROTs) that apply generally to SQL development regardless of the underlying DBMS. These are the general guiding principles by which your SQL development should … Continue reading

Posted in DBA, performance, SQL | 3 Comments

A Dozen SQL Rules of Thumb, Part 1

today’s blog post we will examine some rules of thumb that apply generally to SQL development regardless of the underlying DBMS. These are the general guiding principles by which your SQL development should be guided… Rule 1: “It Depends!” The answer … Continue reading

Posted in DBA, Rules of Thumb, SQL | 1 Comment

Designing Applications for Relational Access

Application design is an important component of assuring relational database performance and efficiency. When performance problems persist it may become necessary to revisit application design. But redesigning and re-coding your applications can be time-consuming and costly, so it is better … Continue reading

Posted in DBA, performance | Leave a comment

Evaluating Database Performance Management Tools

I just completed a four part series of articles for TechTarget on database performance management and the different categories of tools are used for managing database performance. The general goal of the series is to bolster organizations’ understanding   of the issues … Continue reading

Posted in DBA, performance, tools | Leave a comment

Data Modeling Concepts

Oftentimes organizations assign the DBA group the responsibility for data modeling, in addition to the more conventional physical database management tasks that are well-known DBA responsibilities. Of course, that does not mean that DBAs are well-trained in data modeling, nor does it … Continue reading

Posted in data, data modeling, DBA | Leave a comment

Data Summit: A Trip Report

Last week I had the pleasure of attending, and speaking at, the annual Data Summit event in New York City. The event, sponsored by Database Trends & Applications, boasted knowledge-packed days of presentations on all things data. Day one started … Continue reading

Posted in Big Data, data, DBA, NoSQL | Leave a comment

What Does the Latest Salary Survey Say About Data Professionals?

In the latest Computerworld IT Salary Survey (2016) 71% of IT workers who took the survey reported that they received a raise in the past year. That is a nice healthy number. For those of us who specialize in data and database … Continue reading

Posted in DBA, salary | 2 Comments

Evaluating Data Warehouse Platforms

I just completed a four part series of articles for TechTarget on data warehousing and the platforms that are used to implement data warehouses. The purpose of the series is to help inform potential data warehouse buyers of the considerations … Continue reading

Posted in data warehouse, DBA | 2 Comments

Building A Basic IT Library

Printed words on dead trees is still my preferred way to read about IT topics. I am a huge fan of technical books and I house a library of hundreds of them in my home office. I believe that there is no … Continue reading

Posted in books, DBA | Tagged | 1 Comment

Data Technology Today – 2015 in review

The WordPress.com stats helper monkeys prepared a 2015 annual report for this blog. Here’s an excerpt: The concert hall at the Sydney Opera House holds 2,700 people. This blog was viewed about 54,000 times in 2015. If it were a … Continue reading

Posted in DBA | 1 Comment