Just want to make sure you understand that this is a "core" count and not a true cpu count.

You can also download this code at http://softwarecommunity.intel.com/articles/eng/2728.htm

Since MS licenses on actual CPU (and not cores) I needed to find out the actual cpu for our servers. Our sysadmin provided me an executable (attached) that is...

To recover your DTS packages you'll have to restore the MSDB database. See books online for System database recovery.

To move DTS packages from one system to another, I use...

Idera has a free download of their product called SQL Permissions. I've used it several times and it works great.

Just a little side note: A rebuild index is a bulk-logged operation. I had a situation where I was rebuilding a massive index over the weekend and the...

I just did a recent evaluation on the 3rd party log reader tools. We had a situation where data was mysteriously being deleted and wanted to read the log...

I can't see my previous post, so I'll post again.

Some thought on this issue:

A full backup after the fact will not contain the deleted data. You cannot take a...

Some thoughts on this; A full backup after the fact will not include the deleted data. A tran backup cannot be taken until a full backup is taken....

You may also want to consider that you don't have to license a passive node. If you put an instance on the passive node, you'll have to license it.

I had a similar problem that ended up being a DNS entry problem. As a test, you can change the server name the endpoint is pointing to and use...