Certainly people need some training, though I understand companies being reluctant to train people too much as the investment might not pay off if the person leaves. I'd argue you...

Thanks, I've fixed it.

Correct link: http://www.infoworld.com/d/security/configuration-errors-lead-healthcaregov-breach-249849

a typo. It's fixed

Thanks, Romo. Way to start my season.

vincent.D_FR (9/3/2014)

---

Hello,

I have a problem that seems to be a bug existing in SQL 2008 R1/R2 http://support.microsoft.com/kb/2300689/en-us ). But I work on SQL 2014, so I don't know what to...

Doubt...

This might help: http://www.brentozar.com/archive/2014/03/finding-one-problem-query-extended-events/

Basically find the execution plan and track that.

You restore msdb if you need your jobs, alerts, operators back. It depends on your instance if you need/want this. Restoring master will recover your logins, but it also sets...

Ha, no worries about me. I get ya'll are scared. It's OK. I won't beat any of you too badly.

arkadiusz.stasiak (9/3/2014)

---

I see no paragraph about "High VLF Count". Was it missed by you, Steve?

And there is a small "bug" in the table with new Autogrowth values - for msdb...

I was there. Taking a break from painting my shed

DavidL (9/2/2014)

---

All good advice. I like the first one (there is no plan), and the part about being true to yourself. It was only after about 20 years...

The reason dropping and recreating the column is marked as wrong is because it says

"You must drop and recreate the column with the PERSISTED attribute"

That is incorrect. You can...

How in synch do you need it? Log shipping will be a pain with the users disconnecting, so I'd look at replication as suggested by Gail.

Apparently lots of people are on holiday at RG, so things moving slow.

I think football season has caused issues, though I'm keeping an eye out.

I may spend some time...