Monthly Archives: October 2012

Software Teams

Posted on October 31, 2012 by

Today’s editorial was originally published on Dec 10, 2007. It is being re-run today as Steve is at DevConnections. I definitely used to not trust developers. At least not with my database code, requiring them to send requests to me … Continue reading →

Posted in Editorial | Tagged

Keeping Your Job

Posted on October 30, 2012 by

This editorial was originally published on Nov 26, 2007. It is being republished as Steve is at DevConnections. These days it seems that the demand for IT workers is still growing, but there is no shortage of companies still looking … Continue reading →

Posted in Editorial | Tagged

TTYL

Posted on October 29, 2012 by

Today’s editorial was originally released on Nov 20, 2007. It is being republished as Steve is at DevConnections. OMG! The DB if FUBAR. The sysop added an HDD and did a RAID rebuild OTF. AFAIK, the Vol with the MDFs … Continue reading →

Posted in Editorial | Tagged

Question what you think

Posted on October 26, 2012 by

Good advice from Jeff Bezos.

Posted in Blog | Tagged ,

DBA Support

Posted on October 26, 2012 by

There was a time when I managed two production databases on SQL Server. Two. I had a development version of one database where we paused development for testing, and only two production databases to manage. Since I had to also … Continue reading →

Posted in Editorial | Tagged , | 1 Comment

Two Steps Ahead

Posted on October 25, 2012 by

  Exceptional DBAs do more than respond to events and issues in their environments. In many cases, I think they even go beyond using metrics that detect problematic activity on their systems before users notify them. I think the best DBAs … Continue reading →

Posted in Uncategorized | Tagged ,

Windows 8 First Impressions

Posted on October 24, 2012 by

I haven’t worked with Window 8 at all. I’m not a big beta tester, and it’s been a busy few months for me, so I haven’t bothered to mess with any of the previews. My Win 7 desktop works well … Continue reading →

Posted in Blog | Tagged , ,

A SQL Server Log Reader

Posted on October 24, 2012 by

One of the regular problems that data professionals have to deal with is the whoops disaster, or some type of data entry error. It could be the DBA running a delete without a WHERE clause, or a user updating a … Continue reading →

Posted in Editorial | Tagged | 2 Comments

Walk on the Wild Side

Posted on October 23, 2012 by

In my career, I’ve worked in a variety of environments and positions. I’ve been a developer, and a production DBA, sometimes at the same time. Many of us aren’t working in environments where we are strictly performing one job. We … Continue reading →

Posted in Editorial | Tagged ,

Trace Flag 2371 and Statistics

Posted on October 22, 2012 by

One of the issues that I see published often on forums like SQLServerCentral is the advice to update statistics on your tables if you have strange performance issues, or sudden changes in performance. Statistics are important for the query optimizer, … Continue reading →

Posted in Blog | Tagged , , | 4 Comments