Query query, sql sql, should we debate tomatoes and potatoes as well?

I don't. We've tried a few at RG, but none of them has stood out for me. Plus many of them aren't SQL Server based (or .NET), so there's the...

I think the design of many of these auditing products is to log and detect issues, not prevent them. Nor should they be under the control of the privileged users...

Charps (8/10/2015)

---

It is true that we can't adequately redeploy everything from source control when we are talking about production deploys. We have think about data loss and how we handle...

I'm not sure it's hubris, but more a question of having a view of your code that you can count on for future work. Certainly some of us work in...

robert.sterbal 56890 (8/10/2015)

---

I'm not sure why the sharing of these tools isn't mentioned in every article about them.

Glen Berry's are a good example of what would be great on a...

I don't believe this was the intention. It seems as though SQL Standard is the publisher, moving to a variety...

I'd still suggest they add each of your DBAs, use a group for access, and disable all accounts. Then when an issue arises, they can activate only the account needed.

Brian J. Parker (8/7/2015)

---

I'm really curious to follow this for ideas. My company takes team building seriously and I recognize its importance... but I'm also a serious introvert and generally...

I'm not 100% sure what will happen if you change the replicated values. I'd think you're OK, but I'd have to test some things, and you should as well.

I...

1. Always worry. You should be fine, but if you aren't looking, you'll have issues. Try checking this: https://msdn.microsoft.com/en-us/library/ms142490.aspx

2. I think you should be OK, but I'd prep clients that...

Grant is right on the main issue. Secondary ones are more disk space, potentially lots more. Some systems have more index data than real data.

Also, slows down backup/restore with more...

Never share IDs, including service accounts. That's my philosophy. I don't even like SA available.

Always use groups. If one person needs access, someone else will.

As for preventing new additions, you...

I don't like this as if the rebuild and...

+1 here for me. I like the SQLFool script, but hear good things about MInion