SPBG High availability with SharePoint 2013

I hold a speech at the SPBG network seminar's, the topic was (High availability with SharePoint 2013) and yes, still using the Microsoft "metro" style.

A great seminar with with a lot of good questions. 
SPBG, is known for it's high end SharePoint users and technicians, with a broad knowledge in alll topics.
Please wisit http://www.spbg.dk

 The slides from the seminar is shown here and your all welcome to leave some comment.

Slides

SPBG slides-3-10-2013 from Torben Rimmer

jBoye seminar in London

Yesterday I hold a speech at the one of jBoye network seminar's in London, the topic (High availability with SharePoint 2013) and yes, still using the Microsoft metro style.

A great seminar with with a great view over London city. I wish my office hade this view.
Big thanks to Lau, who facilitated the meeting and to jBoye for arranging the seminar. Please visit http://www.jboye.com

 The slides from the seminar is shown here and your all welcome to leave some comment.
(Please mind that all Saxo Bank specific slides have been removed)

Slides

Disable all Health analyzer rules in SharePoint 2013

As in SharePoint 2010 we also in SharePoint 2013 have a lot of jobs running and analyzing the overall health of our server.  

All those rules are really nice, but in some cases you don’t need them. 

Example: 

• If you know that you are running with databases over the limit and you are okay with that. 
• You are running with only one service account, and is okay with that.
• Your running whit a smaller page file than your physical RAM  (Quit a big file if you have 48Gb)

They all have in common that you as an admin made choices, and as we all know admins never make bad decisions. So instead of mannerly disable rules one at the time, you can just disable all and enable the ones you need.

To disable all rules just run the script below, this will disable all rules. To include the SharePoint SnapIn read this post  

If you like, this can be combined with a xml file so you can disable rules based on this as well. See this post to get inspiration. I would recommend using this if your maintaining a large organisation with a lot of environments.

PowerShell Script:

------------------------------

function main

{

$healthList = [Microsoft.SharePoint.Administration.Health.SPHealthRulesList]::Local.Items

 foreach ($Listitem in $healthList)

 {

  Write-Host -ForegroundColor Green $listitem.Id ": " -NoNewline

  if ($Listitem["HealthRuleCheckEnabled"] -ne $false)

  {

   Write-Host -ForegroundColor Magenta "Disable job"

   $Listitem["HealthRuleCheckEnabled"] = $false

   $Listitem.Update()

  }

  else

  {

   Write-Host -ForegroundColor White Done -BackgroundColor Black

  }

 }

}

Have fun with PowerShell 

Sharepoint Document cheked out to

I wass asked to make a blog on an topic that was related to the checked out to <none> problem.

When SharePoint gets a deadlock in relation to Check-In/Check-Out situation it is due to the state of the CheckOutUserID field in the AllDocs table.

This field is set to -1, which by SharePoint is interpreted as <none>

To fix the page and thus be able to check-in or -out the page the CheckOutUserID must be replaced by an existing UserID from that particular Site Collection/Web Application.

The below SQL script does that, however it is important, that one item exist in the list in addition to the broken one, as the ID used in the script below, will be taken from the first item having an ID different from -1.
Alternative Microsoft advice to use the ID "58"

Generic script below, only the Database name is needed prior to running this.

USE [Portal_XXX_content]

GO

BEGIN TRY

BEGIN TRANSACTION

-- Check if any documents checked out with an invalid status

IF (SELECT COUNT(*)

FROM AllDocs (NOLOCK)

WHERE CheckoutUserId = -1) <= 0

BEGIN

PRINT 'INFO: No document checked out with invalid user id (-1)'

END

ELSE

BEGIN

-- Check if any checked out documents available

IF (SELECT COUNT(*)

FROM AllDocs(NOLOCK)

WHERE CheckoutUserId IS NOT NULL

AND CheckoutUserId > -1) <= 0

BEGIN

PRINT 'ERROR: Nothing checked out so can''t find a valid user ID'

END

ELSE

BEGIN

-- Show documents that has invalid user id

SELECT *

  FROM AllDocs(NOLOCK)

  WHERE CheckoutUserId = -1

  --Updating sharepoint field [checkoutUserId] to a value different from -1

  UPDATE [AllDocs]

  SET CheckoutUserId = (SELECT TOP 1 CheckoutUserId

                        FROM [AllDocs] (NOLOCK)

                        WHERE CheckoutUserId > -1)

WHERE CheckoutUserId = -1

SELECT *

  FROM AllUserData (NOLOCK)

  WHERE tp_CheckoutUserId = -1

  --Updating sharepoint field [tp_CheckoutUserId] to a value different from -1

  UPDATE [AllUserData]

  SET tp_CheckoutUserId = (SELECT TOP 1 CheckoutUserId

                           FROM [AllDocs] (NOLOCK)

                           WHERE CheckoutUserId > -1)

  WHERE tp_CheckoutUserId = -1

END

END

--Finish SharePoint update

PRINT 'The operation completed successfully.'

COMMIT TRANSACTION

END TRY

BEGIN CATCH

IF XACT_STATE() <> 0

BEGIN

ROLLBACK TRANSACTION

END

DECLARE @ErrorInfo NVARCHAR(4000)

SELECT @ErrorInfo = ERROR_MESSAGE()

RAISERROR(@ErrorInfo, 16, 1)

END CATCH

This Solution is supported by Microsoft!

SharePoint 2013 on Azure

So this blog post is about Windows new Azure platform. And will not have any technical contend. But take it as a fun story on me trying to figure out the price for a server on Windows Azure.
   
I as a Microsoft Bizspark Partner was looking for an easy way to set up a new SharePoint 2013 installation on Azure. Just to start a POC on hosting SharePoint 2013 server. So i went to the portal administration panel to create my first windows machine, so I could get started.

My first concern was with the size, I should at least start with the minimums requirements for SharePoint 2013, since I need to present this solution to some customers and need to show that my solution is running fast and problem free. And also not get in to a discussion about my solution is running on at testing environment and it of course would be much faster for the customer. So to find out how big my installation needed to be I went to Microsoft to find the minimums requirements, just to discover that its good sense and fully lives up to my expatiation. So for the smallest installation I need 4 CPU and 8GB RAM, this should be no problem. (I would strongly recommend a larger server)

http://technet.microsoft.com/en-us/library/cc262485.aspx

As a Bizspark Partner I have some benefit regarding Azure as I can use some servers for free so I can get up and running before I have to pay for the services I need. And trust me I have no problem with paying for a service. So I went and signed up for Azure to get started. I thought to myself this is no problem, Microsoft have this under control so it is just for me to start. And my expectation was correct, under offers I found a link and with no problem I was up and running. This process got me smiling. 

So to set up A virtual machine on Azure just go to the administration portal click the big and easy to find plus sign and pick Virtual machines (This of course demand that you sign up for the review program first). So I thought to myself. Microsoft wants all to use SharePoint so they will make this easy for me. I will just have to pick an image and off I go right.

But I was soon to get a lot wiser. First up to choose the Image, just to find that I can choose a SQL image, a windows image even a Linux image, but not a SharePoint image? So I figured out that they properly haven made this one jet, so I will just need to create this myself. So I picked a clean windows 2012 server. And then I needed to choose my Virtual machine size. And then I got a little confused. I could choose from the following sizes.

Okay not the biggest machines in the world. I  can as a bizspark partner choose extra small or small. So to have the minimums demand in the back of my head, I found that I needed the extra large server to install a single instance of SharePoint 2013. (BTW why can have a server with 768MB of RAM, that's not even enough to run a decent IIS).
So looking at the largest instance I can start using being the small server having 1 CPU and 1.75BG RAM it would be a little hard to get something installed. So okay I thought, to get something up and running I need to pay for my service.

So to make a simple calculation on what I need to pay, for my minimum installation. I went to the calculation site to look at some numbers. For a single SharePoint installation with everything on the same box I need an Extra Large server, since the Large server with 4 CPU’s only have 7GB RAM. Remembering that the minimum RAM I need is 8GB.

After finding out that I needed an Extra Large server, I wanted to figure out what my monthly bill would be. I navigated to the calculator and found out that I had to pay. $460,80 per month for a single virtual server to run SharePoint 2013. (I know that I should use Office 365 for Office installation, and with good sense.) But I wanted to have full control over my installation and did not want to invest in hardware.

Azure is a good and fast system especial if you are using the "websites, databases or any other service", but in my sense it's not really mature for a windows installation. Except if you want to pay some really heavy prices. For my startup installation, I would need at least two severs one for SharePoint and one for SQL. So the price would be $921 on a monthly base. That’s a really heavy price to have as a startup.

So what is the key learning’s.

Azure is a really good alternative to buying servers yourself, and get them hosted. But I think the price is a little high for the machines you need. In my case I would have to spend almost $11.000 per year for two servers. Can I do this better? Well this depend on how good price I can get in a hosting company like Rackspace. I can get a decent server for less than $2.500 that matches the demands for running SharePoint and SQ. So I just need to find a place in the country to store my servers for about $5.000 a year. Well maybe it’s okay to pay a little more be-course my servers will hopeful work for more than one year.

So what will I do. Am not sure, I might call up Microsoft and ask if they can raise the number of RAM in there large server, this way it will support most of the applications for a little less on monthly base.
Else I will go and figure out on how to use O365 and SharePoint 2013.

Error on UserProfileManager and a funny SiteSubscriptionId

So I was struggling a little bit with an old PowerShell script to import pictures to the user profiles on our Intranet. The script was not working and I need to figure out what went wrong.

So the script is well documented on various forums, so that should be no big deal in getting this to work. So I went head first, and in to the pool I went.

So the script looks like this.

$site = Get-SPSite $mySiteUrl

$context = Get-SPServiceContext $site

$profileManager = New-Object Microsoft.Office.Server.UserProfiles.UserProfileManager($context)

So the first part was easy, just getting the “mysite” URL, Next part to get the mysite service context. Now again quit easy. But then I had to get the profile manager. Then some problems came up.
So when trying to get the profile manager I got this error when running the commands manual.

New-Object : Exception calling ".ctor" with "1" argument(s): "Object reference not set to an instance of an object.” At line:1 char:29
+ $profileManager = New-Object <<<< Microsoft.Office.Server.UserProfiles.UserProfileManager($context)
    + CategoryInfo          : InvalidOperation: (:) [New-Object], MethodInvocationException
    + FullyQualifiedErrorId : ConstructorInvokedThrowException,Microsoft.PowerShell.Commands.NewObjectCommand

So this had to be the problem to my script.
After some quick test I found my context hade a funny SiteSubscriptionId

SiteSubscriptionId
------------------
00000000-0000-0000-0000-000000000000

So I found that the SiteSubscriptionId will always be a blank Guid unless you have multi-tenancy enabled in the environment, so the problem should be found elsewhere.

I my case I found out that the user running the script was net in the administrators group of the service provider, so adding the user running the script to the group fixed the problem.

Go to Central Administration => Application Management => Manage Service Applications 

Highlight the row “User Profile Service Application”

Click the administrators in the ribbon and add the correct user.

Click the Permissions in the ribbon and add the correct user

Speech at jBoye

Today I hold a speech at the one of jBoye network seminar's, on the topic (High availability with SharePoint 2013). A fun presentation as this was my first try on using the Microsoft metro style.

For the ones that know Danish will be able to read the slides. but your all welcome to leave a comment.
(Please mind that all Saxo Bank specific slides have been removed)

Slides