touche, I was trapped by Jon and Joe.

Good seeing you in any case and glad you had a good week.

Perhaps we have different definitions of side project. As John H noted, this would be 15-20 hours outside your current job, nights, weekends, whatever.

This would assume you've gotten through an...

This might work. Looks like it's got old sprocs being called in it

http://www.sqlservercentral.com/scripts/Security/63991/

I'd guess you have some permissions issue here. With the three part naming, I'd expect that context isn't an issue, but either the object, or the delete permission is missing...

Thanks, Brent. I've made an update to the article, but the setting is probably OK for us right now.

I've also queried the SQL Monitor folks on the backup history. We...

Already added 😉

That's one I want as well.

I think this is on our list, but I've forwarded it on and (hopefully) given it a bump.

because?

You'll have to provide mode DDL and sample data. Also, how do you define an internal address?

YSLGuru (6/26/2013)

---

SQL Server Audit (as of 2008) can capture everything I need it just puts it in a Window Log and while I can get at it via the fn_get....blahblah...

Andrew Watson-478275 (6/26/2013)

---

Would it be possible to be a bit more careful with the content of articles? Our content filter bounced this newsletter, presumably because of the use of...

Lots to look at. As mentioned, warm v cold cache can matter. Did you run it multiple times on the VM?

You restored, did you update statistics, rebuild indexes (only the...

You're deeper than most us at this point. Apart from burning a call to CSS, I might email Paul and ask him. He may get a blog/article out of it,...

mtucker-732014 (6/25/2013)

---

This is a problem in many businesses and I believe stems from the near universal idea that a business should maximise shareholder value ahead of value generated for other...

I believe SQL Audit can do a lot of this at the database level. You'd have to experiment a bit with that. However you can do some of this with...