Good post, and you've hit the issues. There are issues either way. In the db I would tend to vertically partition the blob data from other metadata to avoid index...

@david-2, thanks for the update from RG.

@rudy - I think that is nice, but not always practical. There is limited time, and at some point you have to decide what...

The problem is ensuring the data dictionary gets propagated to other people. Comments in table creation scripts are what I've done, since it's easier to maintain there, in a VCS,...

In the past the big reasons I've gone with Enterprise is scalability (larger CPU/RAM limits). Now there is less of that, but other features. If you can take advantage of...

Amazon is absolutely down at times. For some people. I have had it break down, but pick back up in a minute, for me. Likely Ray, in NYC, didn't see...

The differential backup is just the addition of the differential option, as you have listed. More details here: http://msdn.microsoft.com/en-us/library/aa225964%28v=SQL.80%29.aspx

However, you need to still do full backups. Based on what you...

CirquedeSQLeil (8/25/2010)

---

Silverfox (8/25/2010)

---

Didnt realise your a MVP Jeff, Congrats...

Just thought I would stick my nose in the forums, been a very long time.

Kind regards to the rest of the thread...

I definitely like the idea of a cloud like Polyserve. That seemed like a great technology.

Coffee

LightVader,

OneNote can help you with separate notebooks. It makes it fairly easy to bind pages into tabs, and tabs into notebooks. Took me a few weeks to get used to...

I think I follow Tom, though I'm not sure.

I do agree that a qualifier of some sort, different for each domain, may be what is needed. In practicality, the issue...

Paul White NZ (8/24/2010)

---

@steve-2, Jack, Wayne: Getting out to the States is something I would definitely like to do at some stage.

@steve-2: Thanks for the offer to republish on SSC...

A differential backup is an incremental. Please use that terminology or it becomes hard to talk about this. As Jason mentioned, the more changes that occur, the further (in time)...

This is a good place to post. Thanks.

I'd agree with Jorge that it's worth checking out those articles. You're asking for a lot of documentation there, and so much if it might vary depending on your environment...