I'll reverse points on this one. I was trying to word as adding all the machines the same way. Adding some as SQLSales and some as 10.10.34.56 doesn't make sense....

Examples? Want to share in an article, Gary?

Bradley Deem (5/6/2015)

---

I've been writing idempotent scripts for years. However, even that's not the best defense against a script run twice. I've found it's more economical to write a guard...

Yet Another DBA (5/6/2015)

---

Been writing my release scripts like this for years. Like you I didnt know there was a specific term for it.

As one co-worker said: "write it like...

Isn't this the forum?

I'd argue auditing needs to be in the database when it affects data or legal requirements. App logging certainly should always be included.

RonKyle (5/5/2015)

---

I'm with Gail, somewhat on this. It's not that I think it's harder for me to restore or recover, but it is slightly less readable and confusing. That's the...

Thanks, and no worries.

Compression could still help you, but you'd have to have the clients do it if you move to standard edition. Not sure it's worth the effort there,...

Jeff Moden (5/4/2015)

---

I don't understand why anyone would need to do this through PowerShell. Can someone who actually had such a need please explain? I'm looking for someone...

I set the placeholder, but didn't commit.

I'm in.

Eric M Russell (5/5/2015)

---

In most scenarios the auditing operation should be done asynchonously, if possible, for performance reasons. But you can't do that if the auditing operation is bundled within...

arr.nagaraj (5/4/2015)

---

Guess I am that "someone" whose auditing requirements surprised you 😀

one of the needs for auditing to be async is, in most of the shops, the infrastructure...

I'm with Gail, somewhat on this. It's not that I think it's harder for me to restore or recover, but it is slightly less readable and confusing. That's the concern...

The explanation has been corrected. Thanks

David.Poole (5/3/2015)

---

The thing that was overlooked was that outsourced staff are just like us. They want to get their hands on the new toys. Would you accept a...