The Well-Dressed DBA

You may not be aware of this fact but DBAs (database administrators) are actually world renowned for their impeccable display of sartorial savvy. What the average man knows about fashion would fit nicely within a CHAR(4) field. What the DBA knows about fashion requires a VARCHAR(MAX) field. At least.

By the way, the author would have you know that he can speak with total and complete authority on female DBA fashion as well as male. But he will let a female DBA tackle her own sex. Today he will tackle only the male.

We will begin at the bottom and work our way to the top. [Read more...]

SQL Server 2005 How to Change Default Backup Location

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.) [Read more...]

The DBA’s Desk

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

Secrets to Winning at Office Politics – by Marie G. McIntyre

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

Resources for Learning More About SQL Server Internals

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

Hiring Contract Programmers

Derek Sivers is the founder of CDBaby. He is a musician that learned to program and build websites in his quest to promote his music. He sold  CDBaby (sort of) for $22 million in 2008 and has a blog that touches on music, programming, business and some broader aspects of life. These are some of my favorite topics and I like the fact that he is able to weave all of those topics together so skillfully. His blog is worth sticking in your RSS reader and I wanted to bring your attention to one post in particular: How to hire a programmer to make your ideas happen. [Read more...]