Best Practices

What Service Pack Are Your Client Tools At?

So you have a plan to apply service packs to your SQL instances. You test them out and try to keep a regular schedule to ensure they are up to date. That is great. What About SQL Server Management Studio? What about the copy of SSMS that a developer is using to create scripts? This … Read more

Day Job Lessons From The Garden

It’s spring and in addition to our usual vegetable garden and some existing fruit crops, we are putting in a row of 15 blueberry bushes. Well the past two nights I’ve been outside for 3-4 hours digging a trench (about 40′ long by 2.5′ wide and 1′ deep. right, I said feet.) by hand and … Read more

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

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

How do -you- install SQL Server (Part 1)

No, this is not an installation guide There is documentation for that found in many places. First good place to look is Books Online (2005/2008) but there are plenty of other community resources found at sites like SQL Server Central and SQLServerPedia as well as blogs. What I mean by this post is to ask, … Read more