The Linked Server makes the login do a double-hop. If the kerberos configuration is not in place you will get an error similar to what you get. Usually the Database...

If you want to comply with the principle of Least Privilege, then you should start by talking with business.

I usually take the time to talk with business about their business...

We are looking into EMC Data Domain, but I am a bit worried about backup performance.

Brent Ozar has written a blot entry about "Dedupe[/url]", and I do share his opinion.

The main problem with HT is that the physical core shares registers and processor cache with the "hyper" (virtual) core. This often gives a full context shift with flush when...

I do agree that PowerShell should be on the list, and I would like to point out that SQL Server PowerShell (sqlps) should be on the list.

I tend to use...

Very good and highly relevant article!

This issue I have been working on in each organization I been in.

The approaches has been multiple...

Right now I'm working on getting the information from...

Thank you - all of you.

I will look into SQLRecon ASAP.

BTW - Our SQL Server are spread over several AD forests. And yes - UDP 1434 is mostly blocked...

Right now...

The servers are not broadcasting - and are on several networks; the most are on a primary network, but some are on more or less isolated networks. This is due...

That's right - when I know my servers.

I have too many servers and instances to know them by heart.

So I guess, that what I'm looking for is a inventory of...

"Programming C#" from O'Reilly has been my first encounter with .NET.

As a DBA I was happy to find chapters about ADO.NET, web services and integration with COM.

I haven't read the...

I can easy follow Al.

It's my responsibility as a DBA to secure the data, and the security issues handled in SP4 are too grave to allow a roolback to SP3a.

Management...

Still after cycling the errorlog I sometimes have a large errorlog - specielly when audit level is full - and the I use UltraEdit, but any other editor will do...

Quest Foglight.

Remember - you also have to install SP's seperately on every instance.

I'm using "Microsoft SQL Server 2000 DTS" by Timothy Peterson (2001, SAMS - ISBN 0-672-32011-8).

It's been enough for me...