I actually found that you can find the SPID of the of a linked server call using master..sysprocesses on the local server under the waitresource field, INVENTORY is the alias...

You don't treat the concepts replication/mirroring any differently with a virtual environment. The most important aspect with virtualization is making sure you configure the physical host(s), hypervisor, and VMs to...

Raid 6 is just like Raid 5 with the addition of another parity bit. From a disk perspective there is no penalty for reads but you do generate overhead when...

S. Kusen, thank you for this helpful script!

pdanes (10/17/2012)

I do. It's the...

After reading the posts on this thread I'm sensing you already kinda know the acceptable thresholds of data loss based on experience in the company. That being said confirm them...

Hmm, as for not being able to see remote instances or the local instance is the SQL Server Browser service running on this troubled machine? Firewall settings good? SQL Server...

Based on the information provided its likely you have UAC enabled on this server. Running SSMS as administrator, aka elevated privileges allows you to connect locally using a member of...

I'd start with asking your VMware Admin to check the memory usage statistics for the physical host of your VM. The reason I'd start here is because its very quick...

What is the exact error SSMS is throwing? Do you see anything corresponding to these failed login attempts in Event Viewer?

Hi All,

My personal favorite reference for SQL Server builds of all versions is at SQLSecurity.com

Check it out, left hand side has the versions:

SQLSecurity.com

Best,

AmarettoSlim

Great, thank you Gail. I will look it over today!

Sorry Henrico 🙁

It looks like there's an update to a row on the publisher that is failing as the appropriate row cannot be found on the subscriber...

Your options are:

a) Skip these kinds...

In this case since it's all coming from the same array, same HBA, then you won't see a performance increase. However from a manageability standpoint it's nice to have these...