Archive | Learn From Mistakes RSS feed for this section

Don’t Splint Your Database Server To Death

A trauma patient can be “splinted to death.” So can a database server. It happens during at least one ambulance call each year and I’m sure it happens in many more data or network operation centers each year, too.
This post is my attempt to start back up with my “Lessons From Disasters” series I promised [...]

Oops!

If You See Something, Say Something

I get to tell you an embarrassing story and I get to kick off a series of posts I’ve wanted to do for awhile now. Why? Because it’s “meme Monday” Check out Tom LaRock‘s post about the topic and the idea he came up with a couple months back.
This week Tom asked us to [...]

Best Practices: Explain and Understand Them!

Stop expecting people to blindly follow your advice. Stop blindly following the advice of others.

I’m borrowing a lesson from the man who proclaimed he knew exactly when the world would end (last weekend October 21st now). If you only have a minute, my point is simple and I’ve hit it before here -
For Those [...]

Avoid Using Those Troubleshooting Skills

When I re-read yesterday’s blog post on troubleshooting steps, I felt guilty. Instantly. Why? Because I had failed to mention something to you in that post and failed to follow advice I just gave in my SQL Rally presentation. *In my own defense, I did mention that one of the bullets I used in that [...]

You Keep Using That Word – T-SQL Tuesday Entry

You Keep Using That Word – T-SQL Tuesday Entry

Steve Jones is in the control room for this month’s T-SQL Tuesday challenge. His topic is a good one. I won’t repeat it here, just look at his post announcing this month’s topic. His topic is discussing challenges we’ve faced when dealing with “customers” (I use that to include clients, managers, colleagues, the business, etc.). [...]

Free SQL Training Online – Wednesday 10/21/09

Where?
Quest Connect is an online series of webcasts on various topics. Some are pre-recorded (like the session that I did.. more on that later…). They have web casts on a variety of topics, not just SQL. You can look at the on demand topic listing here to see all the chats that will be available [...]

disk-fragmentation

A Picture That Says, “Don’t Shrink!” (and other things…)

So I wrote a lot of posts around shrinking (Here, here, here). Some of my posts were turned into a wiki article on SQLServerPedia. I thought I was done posting about this but one more.
I talked about why we shouldn’t do it on a regular basis. Why it should really be reserved for use in [...]