Sounds like good advice. I will expand the Performance Counters I'm collecting, and let Performance Monitor run for some days. Hopefully I can link an MSSQL-memory-paging event with a specific...

Hi,

I did mention the current, production server is a VM. However, the new server - not yet in production and the subject of this post - is a physical box...

Yes, sorry about that. The initial date needed to be changed, and the press release was not updated correctly.

To confirm, the event will occur on Tuesday 17th January 2012, starting...

I agree with everyone here - good question, thanks!

Thanks for the question - a subject area I had no idea about, until reading the linked MSDN article (after getting the answer wrong, of course!). Exactly what QotD...

I think there are huge differences in the server market. Head over to Dell's website, and you can find a tower "server" for under 300 pounds! Alternatively, you can spend...

Great link, thank you beargle. I have hit this problem before, when installing Developer Edition - which, I believe, is an approved version for an XP machine 😛

Andy

Can I suggest you read up a little on DNS? As per my suggestion (above), if you had replaced the Server Name with the IP Address, you would have...

Interesting scenarios, thanks. I do agree with what you say, with our current RDBMSs. But I was postulating whether an RDBMS could be designed slightly differently. For example, we don't...

I am genuinely surprised that companies such as Microsoft don't take this problem more seriously. The issue of SysAdmins having full access to all data in all databases is huge....

Yes, abolutely. With a Synchronous Mirror, the logs have to be applied to the Mirror before they can be committed on the Principal.

You could try using "Database Mirroring Monitor"...

The event you are configuring uses the WMI Provider. You cannot, unfortunately, just run the WQL statement (which is written for the WMI Namespace) directly against MSDB. The object DATABASE_MIRRORING_STATE_CHANGE...

There is also the factor of "company loyalty" to consider. If an exec has been poached from another company, doesn't that suggest the exec is less loyal? The exec is...

I think the question is slightly more interesting than you think, although the answer is probably still "not possible"!

If you are interested in running a fast database, then you want...

I certainly agree that revenue is a major factor. Most legislation is designed to protect the rights of the author/publisher, which ultimately just ensures that people must buy their own...