Shawn,

I like it all but "anti-patterns". I've seen the term, but it's not one I use, and I suspect the people at a beginning level might not know.

I do like...

I wouldn't mind having my SQL Servers send out messages to a group. SMS doesn't handle that, email does, but email doesn't necessarily integrate easily/quickly into messaging a group on...

Versioning is hard, especially when you combine with VS.

For this specific config, it's just hard to say. So many things, unfortunately, can update some of those shared components, and it...

All kinds of marketing...

You should not upgrade past what the server is. If you have dev edition, keep that in sync with the server by applying the same SPs and CUs.

Congrats, Grant.

Somehow I'm not sure this will get me out of UK trips.

The log can still grow if you have one large transaction. Without knowing what the process is, it's hard to tell, but log backups do not function in simple mode....

You calculate a checksum across the page. When you read the page, you recalculate the checksum. If it doesn't match the value stored in the page header, than you have...

Do you already have MS products? There is Small Business Server, but that feels like a large load for one system.

I might look at Standard edition unless you really think...

SanDroid (1/24/2011)

---

Steve Jones - SSC Editor (1/24/2011)

---

Corruption usually occurs from some hardware issue. A voltage fluctuation, a bad driver, some anomaly that cases the bits written to disk to be...

The overhead is listed at 1-2% overhead from what I saw in a presentation by Paul Randal.

If you can't spare that, you have capacity issues.

Kevin, very true. I think this one is mostly a 100 level, sometimes going to a 200 level of stuff. It probably needs to be separated out to Dev and...

If you are set to simple mode, transaction log backups do not work or matter. Each checkpoint (every few minutes) results in a clearing of committed transactions from the log.

2GB...

Good suggestions. I'll add some of these, as well as clean up the abstract a bit.

Interesting comments. I've never had anyone mention the title, but those are good points. I'll see if I can come up with something else that might better describe this session.