Congrats!

Good questions, and I pinged Allen to let him know this thread had a post.

This is a political job, and politics come into play.

I tried to ask some tough ones...

Congrats, Grandpa ^ 2

Do what George wrote. Standby for logs, with the automated process.

Note that whenever logs get restored, users will be kicked out of the database, so plan your restores accordingly. If...

First, encrypting the entire table means that access is going to be slow since you have to decrypt. Indexing doesn't help, and that can be an issue. If you always...

Only if you can change the code that accesses the tables. If you can control the code, and have users enter a password, you can use symmetric/asymmetric encryption to secure...

Mirroring is in a restoring state. You cannot access the secondary. You can make snapshots on it, but those are points in time.

Log shipping is the best option here, but...

The scripting does work great, and I'd actually recommend that you do it periodically as a DR item. Keep the scripts handy in case you don't want to, or can't,...

One quick note:

I don't see the idea of accepting we'll have bugs in our software as implying that we allow those bugs to live or that we don't work to...

It's a good suggestion. Not so easy for us to always know as well, though most articles apply to multiple versions. I think it's the minority that aren't useful for...

Craig-315134 (9/26/2013)

---

Steve Jones wrote:

... I am starting to think that Powershell might be the best investment in my future skills.

Steve, do you think Powershell would also be a good skill...

It should be local time. It is possible it's showing the server time, which I believe is set to my time, US Mountain time.

No need for a potato gun, lathe, or automation.

If you need it peeled, find someone that deserves a little punishment. Kids are good for this, but the rogue developer...

simon.crick (9/25/2013)

---

I sense a degree of disbelief, and I can't blame you given the culture of not caring about the odd bug here and there that seems to invaded the...

simon.crick (9/25/2013)

---

I was lucky. I had teachers who drummed this into me from an early age, and I have written some fairly complex systems that have not needed a single...