SQL Server Blog

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

Tetelestai – It is Finished

April 11, 2009

I recently read a post by Michael Deputy that talked about his Blog Direction. He brought a good point up: Focus on what’s important. Well today I am doing just that. I am a Christian as I say plainly in many locations and in my about us page. I am thinking I may periodically post … Read more

Manage Your Transactions (So they don’t manage you – Part 1)

April 9, 2009

This is part 3 in a series on shrinking and transaction management. Click here for part 4. You can see them all in the Shrinking & Transactions category. If you are one of the people who have been reading this blog, you know where I stand on shrinking databases/log files. I don’t like the practice (Post 1, … Read more

Previous Next