I would assume this is TDE. That's the native encryption.

If this is a response to regulation (PCI, SOX, etc.) , this really is what your auditor thinks. I would request...

I don't know if it's better or worse, but it's more a question of scale of use. If you have something you are trying to run as cheap as possible,...

I would encourage everyone to do research into how much it will cost to host stuff in the cloud.

We have a simple web application with a small database in...

Is there a different in how you architect an app, depending upon if you choose a IaaS vs. PaaS approach? If we just did a lift-and-shift the VM's into...

Is there a different in how you architect an app, depending upon if you choose a IaaS vs. PaaS approach? If we just did a lift-and-shift the VM's into...

I think this season is a bust for me. However, I seem to be helping others set scoring records on a weekly basis

Great point on data. That's the limiting factor in many of these technologies. Second to that, I find that people building the models often don't have a great idea of...

My pleasure. Azure DevOPs, or Bamboo (Atlassian), or Jenkins, are just step engines. Like SQL Agent, they will run things.

The nice thing about using these is they can abstract away...

Ugh, I would not have wanted to find that.

This article shows me two techniques I don't know much about. I've got some questions about this, to help me learn more about it.

Whether you use state-based approach of...

Personally I think the article is a bit biased against the state-based approach. Since it assumes you would be applying changes to production blindly as opposed to comparing the...

This is the main reason why people go with migrations. However, lots of customers don't go into the...

Finally a win. Surprised even me

Location data isn't preventing tracking, as they track the towers you use. If you have location off, you reduce their accuracy as GPS data isn't available, but you are still...

As Scott mentioned, only shrink files, one at a time. This often seems to work quicker to me as well, when a database shrink seems to take forever.