Our developers are experimenting with containerised databases, that is, many separate little unconnected databases rather than having the lot in one monolithic database. This means that a lot of the referential integrity work once done by SQL Server is now done by .NET and Entity Framework.
I am curious to see how this will turn out.