Worked fine in development…

How many times have you heard or uttered those words? You work hard and understand the business requirements, you try and get the logic to work to make the procedure return what was expected or update the data as expected. You do some unit tests in your environment, it may not scream but it comes … Read more

A Picture That Says, “Don’t Shrink!” (and other things…)

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

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 … Read more

SQLServerPedia –> Do you use it?

I was going about my own business today when I got an e-mail from Brent Ozar (twitter, blog) who is the editor-in-chief of SQLServerPedia. Apparently a wiki article that was made from my blog posts on shrinking has received the honor of being the first to receive the “Wiki of the month” recognition. Great honor … Read more

Paranoid? Control Freak? Have I got a career for you…

The above personality traits sound like bad news. In most areas of life they certainly can be. That being said a DBA needs to have a certain aspect of these to best do their jobs. As I blogged about in “Checklists, Recipes and Algorithms“, I describe other careers where a keen eye to detail and … Read more