DBA From The Cold (5/6/2015)

---

Yep, the data in the BLOBs is data retained "just in case". It has nothing to do with the day to day application operations.

I'm definitely leaning...

Just as a general call, if anyone is interested in sharing how they do this for specific code, perhaps an example of how you handle data, config, table changes, etc....

This is the DBA Stig

For sure. I've been enjoying some of the live streaming of sessions at BUILD (last week) and Ignite (this week). Almost wish I was there, but glad I wasn't traveling.

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