SQL Server Blog

What about questions to ask the company?

June 24, 2009

Lately there have been a lot of great blog articles with active discussions talking about questions to ask potential SQL Server DBA or Developer candidates. Off the top of my head (and by means no offense implied to the many others, check out my blog roll for some of the blogs I try and keep … Read more

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

June 19, 2009

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

June 18, 2009

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?

June 4, 2009

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…

June 1, 2009

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

National Day of Prayer – Conviction

May 8, 2009

As I said when I posted tetelestai, I will be blogging about my faith from time to time. Well maybe I’ll be doing more of that, maybe I’ll be making a separate blog for that but for now, this is one of those posts. Today’s post may turn more folks away but it’s on my … Read more

SQL Quiz 4 – Leadership

April 20, 2009

Chris Shaw (Blog, Twitter) has started SQL Quiz #4 which asks for you to talk about a great example of leadership or a great leader. Many people have been tagged and  responded, including Jeremiah Peschka (Blog, Twitter) who jokingly offered to tag me in a twitter conversation. I told him not to bother but I … Read more

Embrace the Mundane, Appreciate the Simple

April 16, 2009

I just finished doing a simple deployment on a busy day during a busy week of a busy month of a busy career. I had to run a few SQL Scripts that were reviewed (I also reviewed them quickly), had to run them in order based on a simple note checked in with the scripts. … Read more

Manage Your Transactions (So They Don’t Manage You – Part 2)

April 16, 2009

This is the final in a series on shrinking and transactions. You can see them all in the Shrinking & Transactions category. In part 1, we talked about factors that affect transaction log growth. We talked about what a SQL Server transaction is and the various modes SQL interacts with a transaction (Autocommit, Implicit Transactions and … Read more

Previous Next