Category Archives: tools

Managing Database Application Performance

A database application requires constant interaction between various disparate computing resources to operate efficiently and according to specifications. Realistically, the tuning of a database application can be broken down into three components: system tuning, database tuning, and application tuning. All … Continue reading

Posted in DBA, performance, SQL, tools | Leave a comment

Transforming Mainframe Data Management

Just a quick post today to let my readers — specifically those in the US Midwest — that I will be presenting at an executive briefing at the River Forest Country Club in Elmhurst, IL  (Chicago suburb) on August 23, 2016. The … Continue reading

Posted in data, DB2, mainframe, tools | 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

The Lifecycle of Data

Most data is not static. No, data has a life in which it changes, is used for perhaps multiple purposes, and gets moved all over the place. So it makes sense to think about the lifecycle of your data at … Continue reading

Posted in archive, compliance, data, database design, information, operational, reference data, tools | 1 Comment

On DBA Tools, Utilities, Suites and Solutions

“Vendor speak” can be a difficult thing to decipher. And that is particularly true within the realm of DBA tools vendors. It would be easier if every vendor followed the same terminology… but, of course, they do not. And there is … Continue reading

Posted in backup & recovery, change management, data modeling, performance, tools | 1 Comment

Inside the Data Reading Room – Memorial Day 2014 Edition

Welcome to another edition of Inside the Data Reading Room, a regular feature of the blog in which I review the latest and greatest database- and data-related books. The first book up for review today is Microsoft Access 2013 Programming … Continue reading

Posted in analytics, book review, books, data, Microsoft Access, tools | 1 Comment

Auditing Mainframe Database Data Access and Modification

Tracking who did what to which piece of data, and when they did it, is important because there are many threats to data security. External agents trying to compromise security and access company data are rightly viewed as a threat … Continue reading

Posted in auditing, compliance, data, Database security, tools | 2 Comments

FileMaker 13 Launches Today

FileMaker, Inc. today (December 3, 2013) unveiled the next-generation platform for business productivity: FileMaker 13. The new software makes it even faster and easier than ever for teams to create tailored business solutions for iPad, iPhone, Windows, Mac and the … Continue reading

Posted in data, FileMaker, tools | 4 Comments

Inside the Data Reading Room – Thanksgiving 2013 Edition

Welcome faithful reader to the latest edition of Inside the Data Reading Room. Long-time readers of this blog know that Inside the Data Reading Room is a semi-regular feature of this blog with the goal of introducing and reviewing new and classic books on … Continue reading

Posted in analytics, Big Data, book review, books, data, Data Quality, Linux, tools | 2 Comments

Defining Database Performance

(Note: I have published this definition before, but it was a couple years ago and I think it is important for professionals to speak from well-thought-out definitions, so I’m publishing it again… here in my blog this time…) As you … Continue reading

Posted in DBA, performance, SQL, tools | 3 Comments