If all computers authenticating with each other are Windows 2000 or greater, and in an Active Directory domain (Windows 2000 Native or higher), then Kerberos will be used by default.

You...

Encryption within a database is probably something I should do, but I don't for the simple reason that any client application that queries the data must (by definition) be able...

AFAIK, for a server-level Principal (i.e. a login to the MSSQL Server, not a database): if it is a Windows-level Principal, then the SID of the login will be the...

I agree. I would also say that all the "new" or "innovative" IT projects have gone to external companies (with varying degrees of failure). When you are employed by the...

Completely agree. Let's just hope that it is not "too late" by the time it becomes too expensive to drive a personal car. I do think future generations will look...

Can we stop linking an electric car with saving energy? Think carefully about where the energy to generate the electricity comes from. Yes, there are more options of how to...

"More and more of us generalize on the platform and then specialize in one or two areas. There's nothing wrong with that and I'd encourage most of you to follow...

I agree that Jim Gray was a fascinating speaker, very enthusiastic, whilst being completely engrossed in technical thoughts and ideas. Unfortunately, I have to say "was a great speaker" as...

Steve, surely you would want to move to Cambridge (that's in England, by the way). There your employers could keep a close eye on you 🙂

Not sure about horses...

Are you trying to restore the backup to the same MSSQL instance? Are you sure the logical names of the Data and Log files are correct? Are you sure the...

To my mind, it does not matter who asks for the information - CIO, senior VP, Queen of England or anyone else you can think of. With confidential data, you...

I agree, it looks like you have the right version of Management Studio, but check you are connecting to the right database engine. On the left, in Object Explorer, check...

What version of MSSQL 2005 do you think you have installed? If the Express version, have you downloaded and installed the Express edition of Management Studio? You cannot administer a...

If this was possible, I think a lot of people on this forum would be out of a job.

The really basic stuff can be taken care of in Maintenance...

The addition of the include first level sub-folders option after SP1 (I think that's when it appeared) clearly shows that this function of the Maintenance Plan was a big let...