In SQL Server 2005, you can easily change the default location for log and data files. Open SSMS and connect to the instance you want to configure. Right-click on the instance and choose properties. Then select the Database Settings page and change the Database default locations.

Clickity-click-done. (I know, being a DBA can be tough sometimes.) Continue Reading…

The DBA’s Desk

September 24, 2010 — Leave a comment

It is Friday and thankfully I’m knee-deep in SQL Server work today (instead of, say, sitting in meetings). It seemed like the perfect opportunity to open the kimono a bit and show you what the DBA’s desk looks like.

The DBA's Desk

This was only partially staged. I got rid of the dust bunnies.

This shot showcases the non-computer tools required by the proficient DBA. Each item was carefully selected and is ABSOLUTELY ESSENTIAL to accomplishing the DBA’s job. I’ll explain. Continue Reading…

Like it or not, office politics is an inescapable part of working in a corporate environment. It may not always be visible but it is always there. It is a kind of game. Those that understand it and aren’t personally offended by it often get along well. Those that don’t understand it or are personally offended by it? Not so much. Continue Reading…

A while back, I spent about a month working through several SQL Server performance issues after upgrading three systems from SQL Server 2000 to SQL Server 2005. During that time I would realize that my knowledge of how SQL actually manages data at a low level was sketchy. In the process of resolving said sketchiness, I came across a few resources that proved helpful. Continue Reading…

This is a quick PSA on naming conventions for servers. I’m going to give you a quick “don’t ever do it like this” example to start. Continue Reading…

Quick Clarification

August 5, 2010 — Leave a comment

I was reviewing some of the stuff I wrote on this blog over the past few weeks and it almost seemed to me like the writing was trying to make a pitch. That’s not what I wanted to convey at all. Hopefully this post will clear that up. Continue Reading…

If you are technical minded, the The Twitter Engineering Blog is a fascinating read. I love seeing how others have handled tough technical problems. Twitter has had to solve a lot of them and I’m sure there are plenty more on the road that lies ahead, so the blog should be interesting.

Somebody on Twitter asked about Toastmasters recently. I went for few months last year and it wasn’t right for me. But maybe my thoughts on Toastmasters can help somebody decide if it is right for them. It comes down to what you’re looking to get out of it. Continue Reading…

In 2007 I did a one year stint providing technical support to our clients. During that time I put together a one page guide on support and troubleshooting to help other people. A little later that year, I spent time training in Kepner-Tregoe’s KT Resolve process. KT Resolve was a lot more in depth than what I came up with but similar in a couple of ways. I found KT Resolve to be a thorough process but too formal and heavy for most situations I encountered. Continue Reading…

I wrote the other day about some of the reasons why small teams of outstanding people might be more effective than larger teams of average people.

Maybe in a perfect world we could all agree. The rub though is that in practice, finding outstanding people and getting them to work for you can be tricky. Continue Reading…