Bill Talada (8/1/2014)

---

Views might work for a small subset of DDL changes since views are rarely update-able when based on more than one table. How can you handle a...

I agree. You don't want to necessarily enable this by default.

That being said, I think you'd need to use dynamic SQL to build a script that would do this. I...

If someone is changing the encryption status, they're creating a lot of load to decrypt, and you'll create load to encrypt.

Don't automatically fix this. Catch it with monitoring (Check the...

Sean is correct in that you need some way of ordering things so that you know what table you are getting data from. Since you're trying to ensure all data...

My reminder is set.

Do we have a draft order?

Koen Verbeeck (8/11/2014)

---

GilaMonster (8/11/2014)

---

Maybe a throttle on posting new threads. A human can't post multiple threads in a...

First advice, don't chase the money. It will lead you to jobs that you might not otherwise like. The higher you go in salary/rate, the fewer jobs you have, and...

Our Stairway series can help with T-SQL. We have a couple on that subject.

Books are good, and the one Jason recommended (recipes) is a format I like. Those are good...

I'm not looking to break backwards compatibility. I just want improvements and things fixed that don't work well. There's no shortage of those. In replication, tooling has barely advanced, and...

Robert.Sterbal (8/11/2014)

---

More data might not get you the specific price on a house, but it will often help get you the reasonable estimate of whether a house should sell for...

My apologies. I forgot to check the other box and was traveling.

I've awarded back points.

Sean Lange (8/7/2014)

---

Well off for vacation for a few days to Colorado Springs. Will be nice to be in cooler air for a few days. See you all next week...

That makes sense. Text encryption/decryption is expensive. Working with numbers is much easier and gives much, much less of a hit.

Akki, does this help you?

A quick break for me, climbing a 14,000 foot peak in CO with the family.

The insert query needs to call the encryptbykey function with the appropriate parameters.

Depending on how you do this with SSIS, there are different ways, but essentially you need to open...