Build on SharePoint
The blog of Sam Betts on SharePoint application development - full of lot's of useful info, guides, and various cats.
Translate This Page
Translate this page
Office Web Apps
Browse by Tags
Build on SharePoint
Tagged Content List
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...
10 Apr 2015
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...
13 Feb 2015
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...
20 Oct 2014
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...
15 Sep 2014
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...
16 May 2014
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...
16 May 2014
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...
4 Feb 2014
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...
7 Jan 2014
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...
15 Nov 2013
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...
11 Oct 2013
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...
6 May 2013
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...
24 Apr 2013
Page 1 of 1 (12 items)
© 2015 Microsoft Corporation.
Privacy & Cookies