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 [...]
Tag Archives: SQL Server
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, “How do [...]
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 [...]
How did I get involved with this SQL Server thing?
There is another quiz going around the SQL Server blogosphere. Great question again, “How did you get started with SQL Server?” I was tagged by Denis Gobo (Blog, Twitter) when he answered this question here. You can hit his blog to track the lineage of this one.
I have been working with SQL Server for just [...]
You Could Be Suffering Right Now
Implicit Conversions In SQL Server – A Silent Perf Killer
I recently had the opportunity to work with a developer at the day job. He was using a loop (for what he was doing it actually makes sense ) and he had a query that ran great when he stripped the query out of [...]
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 [...]
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 in [...]
Follow Straight Path
Recent Comments