SQL Server for SharePoint–Best Practices

SQL Server has many configuration settings to allow it to be tailored and optimised for specific applications that depend on the databases being hosted. SharePoint is no different to many other applications in that it has particular configuration settings that are recommended, and in some cases, mandatory. SQL Server Installation Dedicated Server In testing and Read More

SharePoint Databases Knowledge Base

SharePoint depends on databases for everything: without a healthy SQL Server installation, SharePoint will not work at all.  As part of it’s dependence on SQL Server, SharePoint creates multiple databases when it is installed and when new service applications are created, more databases are created and finally, SharePoint Administrator’s can create new databases to store Read More

PowerPivot for SharePoint: Lessons Learned and Useful Links

When designing a new SharePoint farm there are some decisions that are easy to make and for which there are useful examples such as the number of SharePoint servers that will be required and the distribution of the SharePoint Service applications. It is considerably harder in all circumstances to make design decisions when the expected Read More

SQL Server 2014 – What to Know

New releases of SQL Server always have an impact on SharePoint.  SharePoint depends so heavily on the functionality provided by SQL Server that there is usually a SharePoint Service Pack released to enable full supported compatibility. This post focuses on compatibility issues with SharePoint 2013, not with SharePoint 2010. SQL Server Enhancements Database Engine A Read More

SharePoint Tools: My Favourites

There are some great posts out there on sets of useful tools that are essential when working with SharePoint, chief among them is Tobias Zimmergren’s post Tools for your SharePoint 2013 development toolbox. Tobias’s post inspired my to do this post as I have also found some additional tools to be invaluable: Design Tools Balsamiq Read More