How To Improve Database Performance Without Changing Code

I hear it all the time. It’s a familiar refrain. Most of the time it is innocent enough, and understandable. But there are times when hearing those words are like hearing the screech of fingernails on a chalkboard: “We can’t change the code.” There you are, listening to someone complain to you about the database … Read more

Do You Make These 5 Database Design Mistakes?

Look, everyone makes mistakes. It’s true. But not all of us have the chance to make mistakes that end up costing millions of dollars in hardware and production support costs. Any one of the following five mistakes listed below will add additional costs to your company. It’s guaranteed. The costs could be hardware related (extra disk … Read more

The DBA Plate

It’s Thanksgiving week here in the USA. I have two things I want to mention. First, last Wednesday I did a product demo for Confio Software, you can read more details about that inside my post title Help Me To Feed Others. We raised close to $1,000 for Community Food Share, which will help to … Read more

A Better DBA Job Description For Everyone

Here is a typical job description that you can find online just about anywhere. It lists almost everything possible and imaginable. And it, well…I’ll just let you read it all for yourself and make up your own mind. Enjoy. Position Summary: This is a MS SQL Server DBA role largely responsible for providing operational database … Read more

Refresh Your Views With sp_refreshview

With SQL Server 2008 R2 having been released it seems like a good time to remind people about the sp_refreshview system stored procedure. How are those two things related? Great question. When migrating or upgrading to newer versions (such as R2), you need to be aware that a simple restore is not always enough. First, … Read more