You can mirror multiple databases. If you have them in high availability mode, they'll stay in sync. Why won't this work for you?

No idea, and while you can ask the vendor, I think you'd have to test this exhaustively. There are some new technologies that might make this work.

One note is that...

That link is a good start, but you really ought to pick up a book on database design. It's one of those things that if you don't know how to...

The idea of a system to uniquely identify people is both scary and comforting. I get mistaken for other people regularly, so I'd like to differentiate. However, I also like...

Roy,

Send me an announcement and I'll run it.(sjones at sqlservercentral)

One thing that I think helps is for you to get to know people, know what they're good at, and...

I don't think either cache is cleared. The procedure cache, because that will likely be cleared as space is needed. Same for execution plans.

For the data cache, that's data, not...

I'd say that the answer to the editorial is "it depends".

I think that Brad has made good general observations that apply to most DBAs, especially successful ones. I feel that...

I'd suggest that you try shorter presentations. The Orlando and Denver groups will do a 30 minute "opening" for new presentations or speakers. Give them a chance to talk about...

I saw this in my notifications, thinking, great, another fun complaint for Monday.

And apparently you folks are getting ready for lunch. Enjoy!

are you talking the built in external stored procedures, or ones you've added?

Technically it creates the row, updates the identity, then removes it. The identity update is outside the scope of the transaction (in case other connections need the values), so it...

The question was for database snapshots, not snapshot replication, but I can see where the confusion would lie. I have never heard a replication snapshot called a "snapshot of xxx...

You may be right, and it is better to have more than less. Given the cost, it might make sense just to go with 8GB.

However I've had plenty of corporate...

I think you'll have to have the SAN team dig in. A SAN network error, disk error, any number of things could have caused it. I'd have ignored it, but...

I think 8GB might not be a min, 4, or even 2 could work. It depends on what load you'll experience. What are the database sizes you expect, the workload,...