I have done real, complex database development, both in OLTP...

We all just need to come to terms with the fact that application programmers have a need to locally persist things like shopping carts, messaging, or just generic objects. It...

Okay.... and in that example with foreign key constraints in place the customer still wouldn't get their order because not only would there not be a parent order there wouldn't...

I guess why I find this topic so interesting is that I keep hearing this "the consequences will dire" statement about not using foreign keys and I just don't...

What does this even mean? Is it arbitrary to ensure the items order...

If a table has a...

All too true. Any database of any size that doesn't have primary keys will eventually have duplicates. Any database of any size that doesn't have foreign keys will...

Really liked the way you stepped back to give an objective overview. I'm now more open to the idea of NOSQL to solve certain business issues.

A very interesting analogy. Thanks!

I have to tell you that for calculating things like amortization tables, 4 decimal places is simply not enough. 15 seems to be the magic number. And, yes, Granny Spreadsheet...

Thanks for the clarification.

Thanks for that clarification. So if I don't need the instance to act within an Always On group or cross domains, a virtual service account should be sufficient, right?

Thanks for this. I think I'm closing in for what I need. A couple of follow ups:

VAs allow registration of an SPN but will not provide authentication across...

To me a full answer depends on how many sources you are pulling from to populate your data warehouse.

I have four principle sources. Each source has it's...

Let's try this from another angle. I've reviewed your answer and done further reading.

With a SQL Server 2014 installation there is the option for the service accounts...