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

Not to hijack too much, but is the data highly distributed towards numbers or characters? Large fields of text?

Is the impact more in tempdb or the user db?

We have some articles that look at differences: http://www.sqlservercentral.com/search/?q=SQL+Server+2012&t=a&sort=relevance

2012 was a nice release. AlwaysOn, Extended Events (as Jason mentioned), Full-Text Search got enhanced, Service Broker, a few other things.

Is there...

I have a few friends with TDE enabled on large production databases (> 100GB) and fairly low overhead. Around 4-5% for their workload.

Overhead is workload dependent and can impact performance...

CDC works great, but it complicates administration, and especially DR. If you use it, make sure you understand how to restore it.

Jason Whitish (8/1/2014)

---

We're in the middle of a huge project that's migrating an old legacy database into the current model, and we're using this strategy heavily, along with instead of...

As Keith mentioned, there is no way to do this directly without having something setup. You can use a trigger and audit changes into another table (or the same one...

SQLRNNR (7/31/2014)

---

That's completely misworded. It's "because you had just two pina coladas."