I think it's...

My feeling is that government ought to develop a framework for both more efficient energy generation, and energy efficiency in our use. It only makes sense that we try to...

You can have SSMS create a database diagram, but it's not really a full ERD, and depending on how you have setup RI, it might not be completely correct.

The main...

Ron Porter (2/1/2011)

---

... Finally, since these servers are going to be put into full service only when something else is down, planned or otherwise, I would like to see the...

kswartze (2/1/2011)

---

Steve,

I find that after reading "What's a Passive Server?", I still don't know what a passive server is. The only bone you threw us was at the very...

It's cold here. Thankfully not much wind, but the coldest day in my 12 years in CO.

Where in upstate NY? My coldest day ever was the day before spring break...

I learned this and double checked myself as well when writing this. The names are not always obvious, and BOL is a nice check.

We deployed some changes on Monday, and this was broken. My apologies for the issue.

A fix is set to deploy tonight to correct this.

Are you talking about disk partition alignment?

I don't believe this will work. I think all disks need to be aligned. If they are not, you have to backup all data...

AFAIK, you can't capture the stuff on the information table in a table. That is an out of band message sent to the client, and I don't know of a...

We have a series here to help you as well: http://www.sqlservercentral.com/articles/Stairway+Series/70199/

The main problem you will have is moving your data to 2005 from 2008. You can use replication or custom SSIS packages to move the data.

You cannot move snapshots or backups, from 2008 to 2005. You can script out the database and move the data, but you can't make this happen easily. You cannot mirror...

I am not a typist per se, but after years and years, I have muscle memory as to where the keys are, so I can get a lot of the...

AD is a distributed database of sorts. I think it was built by a separate team, and optimized for a different purpose. Just like I'm not sure mail belongs in...