Some eons ago.. I wrote a blog post about the same topic on SharePoint 2007 which still gets a fair few hits and one of the comments on that post recently was asking about SharePoint 2010 databases and why there was so many of them. And incidentally  I was preparing for a talk  on the same topic at the Wellington SQL Server user group so that comment couldn’t have come at a better time. If you are just starting out with learning SharePoint the chances are you will not need to know about SharePoint 2007. So I am going to *try* and not mention anything about 2007 but keep this post only on the topic of SharePoint 2010 and why SP2010 has so many databases. The new and improved architecture of SharePoint 2010 uses a concept called Service Applications. If you are struggling to understand this fundamental concept in SharePoint I suggest y ...[Read More]