Category Archives: SQL

Application Design and the DBA

Posted on May 24, 2013 by

Application design is more than just writing efficient database requests in application programs. Of course, application design includes database concerns such as interfacing SQL with traditional programming languages and the type of SQL to use. But every aspect of the … Continue reading →

Posted in DBA, performance, SQL | Leave a comment

Removing Superfluous Spaces

Posted on March 20, 2013 by

We all can relate to dealing with systems that have data integrity problems. But some data integrity problems can be cleaned up using a touch of SQL. Consider the common data entry problem of extraneous spaces (or blanks) inserted into … Continue reading →

Posted in SQL | 1 Comment

My Favorite SQL Books

Posted on July 21, 2011 by

Every professional programmer (and DBA) should have a good book (or four) on SQL. There are many to choose from, and a lot of them are very good. Today’s blog post will outline four SQL books that I find myself … Continue reading →

Posted in book review, books, SQL | 2 Comments

Dealing with DBMS Complexity

Posted on May 15, 2011 by

The Database Management Systems we use are becoming more complex – there can be no denying this basic fact of life. Each and every new version of your favorite DBMS adds new features, functions, and options that further complicate database … Continue reading →

Posted in DBA, SQL, standards | Tagged , | Leave a comment

Some Great New Information Technology Books

Posted on November 15, 2010 by

I have been working my way through a stack of computer books the past couple of weeks and would like to take this opportunity to share my thoughts with you regarding some of them. I always seem to have stacks … Continue reading →

Posted in book review, Data Quality, SQL | Tagged , , | 3 Comments

What Does a DBA Do?

Posted on July 28, 2010 by

There are many tasks that database administration (DBA) must perform to keep databases — and the applications that rely upon them — available and efficient. Continue reading →

Posted in change management, DBA, SQL, standards | 11 Comments

Book Review: SQL Antipatterns (2010, Pragmatic Bookshelf)

Posted on July 13, 2010 by

SQL Antipatterns helps you to avoid the pitfalls of database programming. Continue reading →

Posted in book review, SQL, standards | 8 Comments

Bad Database Standards, Part 3

Posted on May 10, 2010 by

Limiting The Number of Tables in “Online” Joins Today’s entry continues our on-going series on “bad” database standards. And the “bad” standard we’ll discuss tonight is a particularly nasty one. Although the general idea behind this standard might seem to … Continue reading →

Posted in SQL, standards | 3 Comments

Bad Database Standards, Part 2

Posted on May 7, 2010 by

Too Many Columns! Today’s entry, the second in a continuing series on bad database standards, attacks the misguided notion of putting too many columns in the SELECT-list of your SQL statements. Database application performance can be impacted by many factors … Continue reading →

Posted in DBA, SQL, standards | 1 Comment

DBAs Must Understand Application Development

Posted on May 6, 2010 by

DBAs need some level of application development skills to be effective at their job. Continue reading →

Posted in DBA, SQL | Tagged , | 11 Comments