Category Archives: SQL

View Usage Advice

One of the most fertile grounds for disagreement between database professionals is the appropriate usage of views. Some analysts promote the liberal creation and usage of views, whereas others preach a more conservative approach. When properly implemented and managed, views … Continue reading

Posted in database design, SQL, views | 4 Comments

The 7 Types of Database Design Reviews

A little more than two years ago I wrote about The Importance of Database Design Reviews here on this blog. The general idea of that post is that reviewing the scope and content of a database implementation before it moves … Continue reading

Posted in database design, indexing, normalization, performance, SQL | 13 Comments

DBA: Development Versus Production

There are many different ways to look at database administration. It can be done by task, by discipline, by DBMS, by server, and so on. But one useful way to look at DBA is in terms of the type of … Continue reading

Posted in availability, backup & recovery, change management, database design, DBA, SQL | 3 Comments

Top Ten Steps to Building the Right Indexes

One of the more vexing problems with relational database development is designing appropriate indexes. Perhaps the most important thing you can do to assure optimal application performance when accessing data in a relational/SQL database is to create correct indexes for … Continue reading

Posted in data, database design, indexing, SQL | Tagged | 2 Comments

Top Ten Application Programmer Excuses

Today’s blog post is a followup to the last post (Top Ten Things to do Before You Visit the DBA)…  This is the top ten excuses that DBAs hear all the time…  “There’s something wrong with the database!” “But I … Continue reading

Posted in DBA, SQL | 5 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

Application Design and the DBA

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 | 4 Comments

Removing Superfluous Spaces

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

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

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