I'd be very interested to see any benchmarking you do with this. I'd agree that the write cache is more important on the controller. Read cache is held in memory...

I'm guessing you mean Payroll app has R/W to the payroll db.

The admins can get in to the payroll db. No way around it. You could remove the admins from...

Thanks and we're working on the code fixes.

Steve

Your question is a bit convoluted and so I'm not quite sure what you want from the data.

Querying by week, you could use the datepart() function and use the week...

You can change the login name, but using the properties for that login.

Yep, getting notes here and there.

Please post in the Suggestions or New Site forums and we'll be patching stuff over the next few weeks.

Thanks for the notes and we'll work on correcting issues and responding to feedback. We've changed the notifications, so let us know if they're better now.

Hot fixes are patches released in between service packs.

Networking is definitely something you should do. I spent most of my time talking with people about everything and I'll probably do more of that next year and not hit...

Restore it with a different database name (don't use the defaults) and change the logical names to match this as well.

Paul has the best guess as to what happened, but it doesn't really matter. The logical or Physical names have no impact on users querying the server. They're just administrative...

You can't load balance with Active Active. You're just running two two Active/Passive, which is a great way of putting it. If there's a disaster of some sort, then you...

I've been using the Recent Posts - Since your Last Visit.

Should be fixed.

And I didn't do anything (other than complain to the developers). Steve D and Steve S from Red Gate deserve the credit for this!

Ha! You've been struck down!

Apparently that table wasn't on the migration list. I've corrected them this morning to appropriately show your levels again!

I need to add an SSC Ninja, maybe...