MSSQL

How To Improve Database Performance Without Changing Code

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 server, and [...]

Review of DBA Survivor by Mike Fal

Saw this review today and wanted to share it with everyone here:
http://www.mikefal.net/2012/01/03/dba-survivor-learning-how-to-rock-out-with-databases/
I’m touched that Mike would take the time to write such a wonderful (and unsolicited) review of “that little book” I wrote almost two years ago now. I’d like for you to read his entire review, but I am going to share his last [...]

Do You Make These 5 Database Design Mistakes?

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 space, [...]