A good tutorial

http://sqlblog.com/blogs/andy_leonard/archive/2009/01/30/an-introduction-to-the-ssis-expression-language.aspx

If you run the SELECT, does it return each db once?

I'd add some logging, or SELECT the backup statement instead of running it to see what happens. It looks fine,...

You are welcome, and happy to help. If you have more questions, or just want to run something by us, feel free.

The client software shouldn't know, or care, about if they're on the primary or mirror. If you are using updated ADO or SNAC clients, then you put in the mirror...

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...