Build on SharePoint

The blog of Sam Betts on SharePoint application development - full of lot's of useful info, guides, and various cats.

Browse by Tags

Tagged Content List
  • Blog Post: Hosting SharePoint Content Databases in SQL Azure

    Another great feature of Azure which we can harness for SharePoint farms for is SQL Azure. SQL Azure is basically SQL Server as a service; you never manage the SQL Servers running the service for your databases – it’s all managed for you with you just having a SQL endpoint to consume. Frankly it’s preferable...
  • Blog Post: Multi-subnet SQL Server Clusters + SharePoint 2013 + SPDatabase.MultiSubnetFailover

    Small but significant update; earlier I described a problem where SharePoint can get its’ knickers in a twist when it comes to consuming a SQL Server endpoint that exists in multiple clusters . Well the problem is real enough; anyone with this configuration that has a failover will probably find SharePoint...
  • Blog Post: SharePoint & SQL Server AlwaysOn Failovers – Video Demonstration

    To demonstrate how SharePoint and SQL Server AlwaysOn work together, especially with a failover, I did a quick video to show it in action. Here it is, enjoy ( https://www.youtube.com/watch?v=se_M1vdriMA if the embedded video doesn’t load): SharePoint 2013 with SQL Server AlwaysOn SQL Server AlwaysOn...
  • Blog Post: Calling SQL Server from SharePoint Web-Part with Impersonation

    A question that comes up with fairly persistent regularity is “how come my web-part can’t connect to my SQL database/web-service/whatever with integrated credentials?”. It’s a question that has some rationale and some history behind it; the rationale being “I logged into the page as a user that should...
  • Blog Post: SharePoint 2013 on SQL Server AlwaysOn, 2014 Edition

    SQL Server 2014 is out bringing with it enhanced AlwaysOn clustering, and is indeed already supported by SharePoint 2013 with at least the SharePoint 2013 May 2014 cumulative update installed . Some new benefits in SQL Server 2014 are the reliability improvements for when connectivity is lost between...
  • Blog Post: Building True Multi-Subnet Windows Server Failover Clusters

    Something you may have heard of if you know clustering at all is the idea of “multi-subnet clusters”; a capability introduced in Windows Server 2012 (if memory serves) to Windows Failover Clustering. It’s conceptually the same thing as a normal cluster; it’s designed to withstand an instance failure...
  • Blog Post: Multi-subnet Clustered SQL + RegisterAllProvidersIP + SharePoint 2013

    Those of us that have even the most passing knowledge of SharePoint will know that it needs a SQL Server instance to work at all. If SQL goes down it takes SharePoint with it which is why it’s quite common to have SQL clustered to make sure SQL stays alive at all costs. I’ve covered this...
  • Blog Post: SQL Server Log Shipping – Bandwidth Analysis for Content Database Updates

    A question that often comes up when talking about SharePoint and SQL Server log-shipping is “how much bandwidth will I need to make log-shipping work between my two farms?” It’s certainly a sensible question given these things need to be planned to avoid over-congestion preventing the Disaster-Recovery...
  • Blog Post: Patching SharePoint Farms with No Downtime

    Patching SharePoint farms is a rare occurrence but one that almost certainly will happen at some point or other, if only for the need to stay on a supported platform as time goes on. When patching SharePoint it’s necessary to take the entire farm offline at one point for reasons explained here...
  • Blog Post: Hot-Standby/Disaster-Recovery SharePoint Farms – Basic Setup & Failover

    Something that’s often required for high-availability SharePoint installations is the ability to failover to another web-farm entirely when needed because of a failure of some kind on the 1st farm, or wanted because of maintenance taking the 1st farm offline completely. It’s simple enough...
  • Blog Post: Set SharePoint Content Database in Read-Only Mode

    This a quick & easy one; I couldn’t find any MSFT material on how to do this as easily as I thought I might, hence this article. A simple question: how do you set a SharePoint content database to read-only? You may’ve seen the setting “Read-Only” in Central Administration and wondered “how do I make...
  • Blog Post: SharePoint 2013 and SQL Server AlwaysOn - High Availability SharePoint

    What is AlwaysOn and why use it for SharePoint? Update : SQL 2014 + SharePoint 2013 (abridged) guide also available . Also if you want to use AlwaysOn for SharePoint Disaster Recovery , then you'll want to have a look at this article - http://blogs.msdn.com/b/sambetts/archive/2015/04/24/setting-up...
Page 1 of 1 (12 items)