CDC works great, but it complicates administration, and especially DR. If you use it, make sure you understand how to restore it.

Jason Whitish (8/1/2014)

---

We're in the middle of a huge project that's migrating an old legacy database into the current model, and we're using this strategy heavily, along with instead of...

As Keith mentioned, there is no way to do this directly without having something setup. You can use a trigger and audit changes into another table (or the same one...

SQLRNNR (7/31/2014)

---

That's completely misworded. It's "because you had just two pina coladas."

Just dropped over to the Heap Consultancy and I see a comment from Bill in KC about me staring at him from the login banner and then this:

"Steve is cool"

Maybe...

Jeff Moden (7/30/2014)

---

Instead of a move to Ask.SSC, maybe a...

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...