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 … Read more
Why would anyone hire a DBA? Isn’t SQL Set-It-And-Forget-It?
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 … Read more
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 … Read more
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 … Read more
Interesting Issue Today/Yesterday – A query was using a linked server to grab data from DB2 via an ODBC connection. Normal execution time is about 15 minutes. This had run on for at least 7 hours when it was decided to kill it, appeared to be doing nothing but causing blocks (due to Intent Shared … Read more
What is a troubleshooting methodology? A lot of the technical problems I encounter with clients or in various roles are not really the fault of the technology at hand. They are either the result of rushed work, apathetic work or botched troubleshooting. Before talking about what troubleshooting is, let’s talk about what it is not. … Read more