I'd concur with Alan on the disabling them. Easier to put them back if you have issues.

kevin77 (7/8/2012)

---

Steve, what does SqlServerCentral.com do to store passwords and authenticate users? If it's not a hash with a four or five byte salt, then I would gladly help...

Doctor Who 2 (7/9/2012)

---

Bottom line: if the agency is small enough, they don't want a DBA. They're not willing to pay that "DBA tax". They'll make anyone who...

Good points, and I won't argue with you on this. There are...

Jeff Moden (7/8/2012)

---

Excellent editorial, Steve! I wish I could give it a hundred stars because it really hits the nail on the head. There're too many people that...

SSL isn't too bad. Easy procedure in BOL for setting it up. Do not use a self signed cert. Get a real one.

Also, IPSec works well if you coordinate with...

Pettite and CC out, and the Yanks still near the top of MLB : http://espn.go.com/mlb/standings

And the Rockies are officially in the doghouse. Tied for the worst record, behind KC, CIN,...

Michael Meierruth (7/6/2012)

---

Steve,

I got a real bang seeing that photo on the right hand side of your editorial. Not many people can say they actually ever used a card punch...

Brandie Tarvin (7/6/2012)

---

Hey, guys. I'm going to post something and if it's inappropriate, please let me know.

A lot of people have been displaced due to the recent East Coast flooding...

thadeushuck (7/6/2012)

---

Cloud computing is just another executive buzz word Ponzi scheme to con a bunch of money out of the everyday honest IT/DBA/Developer workman. Let's join the cloud AND fire...

This might help: http://www.sqlservercentral.com/articles/Administration/sqlserveralerts/1435/

In terms of changing settings, alerts don't detect this. You'd be better off using Policy Based Management to prevent, or alert you when these occur (DOP/tempdb).

For size...

You'd have to describe the sequence of what you did. If you tried to apply a log with the LSN earlier than what's already been applied, it might not error...

It would be contained databases, if they were contained. Only the basis for it in 2012.

I do like the T-SQL enhancements. IIF and Window functions, but my favorite would be...

If you can break your reindexing into separate transactions (separate tables), then running a log backup in the middle can help.

Or use a script that reindexes only some tables when...

Try the key for the instance and the setup. I think I see mine in there. It's MSDN, so hard to tell if that's the right key