Thanks Perry.

Can certificate actually be used to connect to Server instance via SQL Management Studio? if yes how? I mean for example, SQL server authenticated login needs to enter their...

Erland Sommarskog (7/14/2013)

The problem is only know when you don't need any of those other feature. You may not need Service Broker or Change Tracking today, but who knows what...

Thanks Steve.

So that makes me think in what real scenario do we want to use contained database? We know that it can have contained users and solve collation issue, which...

Thank you for the link.

If I can gather all the limitations of using contained database do not allow:

> Partially contained databases cannot use replication, change data capture, or change tracking.

>...

Ah its making sense now, thanks Markus for explaining. I misunderstood that part.

If I can put in different scenario, if we don't specify the max server memory (leave to default),...

Thanks Markus, however I am still not clear.

When configuring max memory from Resource Governor, we specify the max percentage in resource pool. Definition of resource pool taken from msdn website...