Nice memory

I tend to agree that you don't want your SQL Server exposed directly. Can you explain a little more on your setup?

Nope, everything is written to the transaction log. Even index rebuilds. This is so if they fail in the middle, they can be rolled back and maintain an intact index.

The above answer is correct. Shrink is not part of backup, and you should not shrink to a point below that which you need for maintenance operations.

How much data do...

Excellent. Don't get too technical, don't use too much T-SQL/BOL style of explanation. Think junior DBA, secretary trained to handle basics, and explain in a simple way what to do...

cold

254K this morning

Koen (da-zero) (1/10/2011)

---

Brandie Tarvin (1/6/2011)

---

Jack Corbett (1/6/2011)

---

I also want to encourage all you who are PASS members to opt-in to the session voting for SQLRally. See my this post...

Doh!, can't believe I didn't catch that. Fixed.

Excellent explanation, Ed. This would actually make a great article if you wanted to write it. I wasn't aware of the UAC issue for local administrators on W2K8.

A few things.

First, your code is copyrighted automatically, so users can't re-use it legally. That's the best way to handle this.

Second, the "with encryption" hides the code, but a short...

Doing the upgrades one by one is fine. I would ask about 64bit and push a bit to get them to agree or give you concrete reasons. There were some...

That is strange. I might run a trace while this is running, look for some clue about how long each step takes. Might help you determine what is broken. I...

The dates are not set right now, but we will do an announcement once SQLskills finalizes the date/location.

Then it doesn't make sense if there is a duplicate entry. Are there trigger or some other dependency on the subscriber?

Have you snagged the snapshot file on the subscriber and...

ApexSQL makes a log reader as well. As Gail mentioned, however, there isn't a lot of value for most people in looking at the log. It can help in DR...