At first I was a little annoyed with the graphics since I have to type it in to test 😛

However I agree with Hugo. I think it encourages more learning....

As Gail mentioned, without logging hard to know what happened.

One thing I'd check is if you have triggers or cascading deletes enabled to see if this was someone trying to...

Looking good. I didn't see him, but like LeBron James, he has come in and started to show that he was worth the $$.

Now they need to get a few...

As much as I didn't like the MMC move from Enterprise Manager, I think SSMS was a mistake. It's got too much built in, with hidden non-modal windows getting lost,...

If you haven't seen Leverage, it's set in today's world, and they have amazing computers. Face recognition in a minute from a db scan, cloning cell phones, remote access to...

We do republish on Fridays and holidays. Perhaps we should do it more as plenty of people don't see every article, or are new to the site.

If the discussion brings...

I didn't even notice the graphic, and apologies. I'll clean that up and reshoot an image.

Hugo, we have had numerous complaints on profanity at times, so we've set a few...

Service accounts are used when you install SQL Server. There are also Windows groups created, with these accounts in these groups. Rights are assigned to the group NOT the user.

The...

My kids are already asking for it, so I'm sure we'll get one for Christmas.

I tend to agree with blandry on this one. I think some of the things writers...

My guess is something broke with the upgrade and there is some dll didn't upgrade correctly. At this point, I'm not sure what you can do, or what I'd suggest....

I somewhat fail to see what's insecure about the Agent XPs. If the auditor's don't like that, did they pass Windows Scheduled Tasks? Is that more secure somehow?

I'd ask them...

The key is for your backup drives to be a clustered resource. They should be visible from both nodes, just like the data files. However the physical drives should be...

This is the first I've heard of it. Does this happen from any SQL 2008 client tool, on any other workstation?

Can you change/add/view linked servers via T-SQL?

Is this what happens?...

Gail is absolutely correct. There is no chance of data loss.

Fundamental backup principle - Do not store backups on the same physical drive as the data/logs. Use a separate drive. In terms of clustering, as George said, get a second...