Archive | DBA RSS feed for this section

One Man’s Trash…

Do you live in a town with a dump? I do (well, transfer station). On any given weekend you can find people looking for treasure in the scrap metal or electronics bins.
I never thought I’d say it, but over the past couple weeks of visiting the dump, I have found an amazing treasure that will [...]

How do -you- (I) use SQL Server?

I was recently tagged in an interesting blog post by A Misplaced New Englander, David Taylor. (dyfhid on twitter). The question sounds simple enough, “How do you use SQL Server where you work?” Of course the answer is not simple. I echo Grant Fritchey’s response in his blog post that it would be easier to [...]

How do -you- install SQL Server? (Part 3)

Welcome to part 3 in this series on a thought process around SQL Server Installation. In Part 1, we started talking about some basic steps and a thought process for a repeatable success story with your SQL Server installations. Part 2 discussed security, playing around before doing a first install and smoke testing afterwards.
Today we’ll [...]

How do -you- install SQL Server? (Part 2)

Welcome to this series on a thought process around SQL Server Installation. In Part 1, we started talking about some basic steps and a thought process for a repeatable success story with your SQL Server installations. Today let’s continue that story and talk some more about installation planning and success. We’ll finish up talking about [...]

How to use SP_CONFIGURE in SQL Server

A Blog Post About Using SP_CONFIGURE
I use SP_Configure a lot. I use it to quickly view server settings or when making a change. It is quicker and, in my mind, safer than using the GUI in SQL Server Management Studio. I recently learned a tip that I had never known from a Kalen Delaney course [...]

Benchmarking… Who Needs It?

All of our SQL Server instances need benchmarks!
So the title is somewhat of a trick question… I hear and sense a lack of priority around taking periodic benchmarks in a system with a lot of folks. How often do you take benchmarks? Do you know what “normal” means for your system? Do you know when [...]

Documentation

Documentation
(…Or how I learned to stop procrastinating and love tolerate a chore necessary task)
Do you document? Do you document well?
As I told Paul Randal (twitter, blog) today on twitter, this blog post was inspired by an observation in the shower and a recent question by Brent Ozar (twitter, blog). You didn’t need to know that [...]