SharePoint 2013 – create an external content type for SQL Server
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…
Enable FILESTREAM and provision a Remote Blob Store
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…
Using sp_BLITZ to verify SQL configuration
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…
Creating a SQL Maintenance Plan to backup SharePoint content databases
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,…
Loading ...