Search code examples
sql-serversecurityproduction-environmentmulti-tenant

Is it safe to keep all databases on one SQL server?


I'm creating a Multi-Tenant application that uses separate databases for each 'client'.

Is it safe to keep all the clients databases on one SQL server? Assuming I give each db its own user account?

Thanks


Solution

  • There was an excellent blog post by Brent Ozar last week on this exact subject.

    How To Design Multi-Client Databases