Category Archives: SQL

A Good Start for Your SQL Library

Every professional programmer (and DBA) should have a library of books on SQL fundamentals. There are many SQL titles to choose from, and a lot of them are very good. But you can’t buy them all unless you are independently … Continue reading

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

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

A Dozen SQL Rules of Thumb, Part 3

Today we pick up our three-part series of SQL rules of thumb (ROTs) with the third and final installment… You can think of these rules as general guiding principles you should follow as your write SQL statements… and we start … Continue reading

Posted in DBA, performance, SQL | 1 Comment

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

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

Programmer Makes Excuses, Too!

In our last post (DBA Excuses… and advice to programmers for overcoming them!) we examined some of the bigger excuses used by DBAs to avoid problems and work. But poor excuses are not the exclusive domain of the DBA; far from it! … Continue reading

Posted in DBA, SQL | 1 Comment

Managing Application Performance… from a database perspective.

Applications that access databases are only as good as the performance they achieve. And every user wants their software to run as fast as possible. As such, performance tuning and management is one of the biggest demands on the DBA’s … Continue reading

Posted in performance, SQL | 1 Comment

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