Category Archives: DBA

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

Happy Holidays 2015

Just a short post to end the year wishing all of my readers everywhere a very happy holiday season – no matter which holidays you celebrate, I hope they bring you joy, contentment, and let you recharge for an even … Continue reading

Posted in DBA | 1 Comment

Using SQL to Count Characters

If you write SQL on a regular basis, it is very important to know the functions that are supported by your DBMS. In general, there are three types of built-in functions that can be used to transform data in your … Continue reading

Posted in DBA, functions, SQL | 1 Comment