Eric M Russell (7/31/2014)

---

If the windows group like 'MyCorp\ProductionDBA' or 'Builtin\Administrators' are members of SYSADMIN, and user account 'MyCorp\JohnSmith' is added to one of these groups, then he has sysadmin...

Sure there is. A long running...

FYI, here's a post someone sent me: http://blogs.xtivia.com/home/-/blogs/alerting-on-elevation-of-privileges-in-sql-server?_33_redirect=http%3A%2F%2Fblogs.xtivia.com%2Fhome%3Fp_p_id%3D33%26p_p_lifecycle%3D0%26p_p_state%3Dnormal%26p_p_mode%3Dview%26p_p_col_id%3Dcolumn-2%26p_p_col_count%3D2%26p_r_p_564233524_categoryId%3D12100%26p_r_p_564233524_resetCur%3Dtrue

Lynn Pettis (7/30/2014)

---

It should be noted as well, that sometimes people come to SSC and ask question(s) and then actually get upset when we try to show them better ways...

Eric M Russell (7/30/2014)

---

SQL Server Audit has an 'Addlogin' event and a 'Add Login to Server Role' event. For example, when a login is created or granted membership in SYSADMIN...

jcrawf02 (7/29/2014)

---

[Been reading through Michael's lengthy post and comments, only to find yours Steve. I think his main problem is that SO is focused on *only* providing fish, where SSC...

Are backups included in the size of your data+log? If not, I'd try to reduce transactions, as Jason mentioned, and have frequent backups.

Thanks, I'll take a look as soon as I can.

Gary Varga (7/30/2014)

---

There simply isn't enough education on security.

I have two decades of commercial experience programming. I have read books, watched online presentations, read whitepapers, read technical articles and gone...

Ray K (7/29/2014)

---

I'm also thinking that the Rockies would be served well by a manager who thinks outside the box, a la Tony LaRussa. Maybe someone who knows how...

Andrew Kernodle (7/29/2014)

---

As crazy as it seemed two hours ago, I might just give this a shot :-D. I'll see if I can meet with the .NET team for...

I've thought that building for Denver would be the thing. Get back to the Blake Street Bombers and find hitters, guys that smack the ball and go for offense. The...

That's an easy place to organize something.

There are Memphis and Nashville SQL groups that hold events and they'd come support you (I think). Huntsville, Atlanta, etc would probably get...

A big debate on the radio in CO: do the Rockies management do a good job? So many people are upset with them, and think they aren't spending $$ or...

Jeter moves to 6th and I think that's where he stays. Can't see him getting 95 more this year, but it's been an amazing career.