Archive | Troubleshooting RSS feed for this section

SQL University – Troubleshooting Week

I was about to write another bunch of comments on why I think troubleshooting skills are important. I’ve changed my mind – I’ve done that before. So let’s start SQL University Troubleshooting week off with a couple reminders from past posts that say what I wanted to say this week already.
If You Can’t Troubleshoot – [...]

The Book (And the balding blogger)

Prof. SQL Server 2008 Internals & Troubleshooting

This book needs to be in your library.

Hey Software Vendors – Get a Clue!

Psst. Hey Vendor – DBAs are secretly plotting against you! We hate what your products do to our environments. Sometimes we even work to get you replaced by someone else who makes a product in the same space but is “DBA-Approved”….

What’s that? You want the DBA stamp of approval?
I write this blog to help folks [...]

Absolute Data Destruction

Why Hire A DBA?

Why would anyone hire a DBA? Isn’t SQL Set-It-And-Forget-It?

Got SQL Server Questions?

A Great Idea – #SQLHelp hashtag on Twitter
I was following a conversation today between Brent Ozar, who is @BrentO on twitter and Aaron Nelson, who is @SQLVariant on twitter.
A great idea was discussed: A twitter hashtag that, as Jorge Segarra (or @SQLChicken on twitter) describes it in his blog post, can act like a bat [...]

What’s Your Point?

As a DBA you are getting pinched between developers, project managers, budget conscious managers and server teams. When a critical issue with no one easy answer for those people pops up, what do you do? You can panic or try and point the blame someplace else or you can rise to the situation and help [...]

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