I am creating an external content type to display records from an SQL table in a SharePoint list, using a target application in the Secure Store for authentication. I will do this using SharePoint Designer 2013. At a minimum, I…

Binary large objects, known as BLOBs, are used to store large binary data such as Office documents and media. By default BLOBs are stored in the content database on the SQL server. Today I am going to enable FILESTREAM on…

I’m not an SQL expert so I imagine I make a lot of common mistakes when setting up databases. I have just discovered sp_BLITZ by Brent Ozar, which is a set of scripts that will assess the configuration, security, health…

In addition to regular SharePoint backups I have decided to create a SQL Maintenance Plan to backup the content database to a file each night. This will enable me to quickly and easily restore the database directly in SQL should I need to,…