SQL Server in SharePoint:
SQL Server is used to store content and configuration information. We have two types of databases: content databases and configuration databases. We had said previously that content is according to a site. So every site has its own content database. For instance, if we have a payroll site and recruitment site, they have their own content databases. Configuration database is for the entire site as they are used in web farms, site configuration, and a lot of other things which are generic and common across all sites.
Thanks for learning my blogs!!!