Feeds:
Posts
Comments

Archive for July, 2011

Dear all,

 

I already got the happy notice on July, 1st while on the way to the holidays. I returned 2 days ago and finally could embrace the MVP Award Kit!

 

In fact, I’m the first SharePoint Server MVP from South Tyrol, and one among only few in Italy.

 

WP_000554

The MVP Award Kit box.

 

MVP_Certificate

The Certificate.

 

I also updated my MVP Profile, which you can find here:

 

https://mvp.support.microsoft.com/default.aspx/profile/angler

 

The kit contained:

  • Glass-made award
  • Certificate
  • Plastic card w/ MVP ID
  • MVP Pin
  • NDA agreement

Thanks, Microsoft, and big thanks also to Ale and Marjorie! I hope to be able to contribute many, many more times to the communities and wish you all a nice week start!

 

I also hope to meet some of you at the conference Collaboration Days in Luzern, on November 29th and 30th this year!

 

Best regards,

Martin

Read Full Post »

Dear all,

 

one of the definitely nicest features of the Service Pack 1 for SharePoint Server 2010 is the ability to restore single sites, which wasn’t possible before.

 

Procedure for restoring a site pre-SP1:

  • Restore entire farm from backup.

 

Drawbacks: Time consuming, costly. Most of the times not performed at all.

 

Procedure for restoring a site post-SP1:

  • Ensure user is a site collection administrator
  • Go to Site Actions –> Site Actions
  • Click Site Collection Administration
  • Click Recylce Bin
  • Check the site you want to restore and click Restore.

 

Quick and simple, isn’t it?

 

In Microsoft SharePoint Server 2010 w/ SP1, a deleted site is not permanently deleted, but moved to the 2nd stage Recycle Bin. The default setting for automatic deletion is 30 days – however, this is modifyable. You can see how to do these changes here:

 

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

 

Restoring whole Site Collections:

 

You can use the following PowerShell cmdlets to restore, delete or view deleted site collections:

 

Get-SPDeletedSite
Remove-SPDeletedSite
Restore-SPDeletedSite

 

Stay tuned till the next time and best regards,

Martin

Read Full Post »

Dear all,

while you can plan and organize availability on farm level by configuring Network Load Balancing and also SQL Server database mirroring and failover clustering, you do also have the possibility to plan for high availability on service application level, especially for critical service applications like PerformancePoint. In order to perform this, you must have a failover database server along your normal SQL server.

 

Higher availability for PerformancePoint Services can be achieved by adding additional failover databases to the PerformancePoint Service Application.

 

Go to the Central Administration, choose the row of the PerformancePoint Services Application (don’t click the name, otherwise you’ll “Manage”), and select “Properties” from the ribbon. Just like in Fig. 1

 

image

Fig.1: Open the properties window for the PerformancePoint Service Application

 

Next, in the “Failover Database Server”, insert the name of your failover database server.

image

Fig. 2: Specify the database failover server

After you did this, click “OK” to confirm.

 

Before fully relying on this mechanism, it could make sense to do a test run to verify whether the failover is working at all.

 

Caution: Do not execute the following steps in a production environment, unless you know what you are doing. At all costs, before testing the settings, notify users, schedule downtimes and make sure to do this together with a SQL administrator. Before applying any changes in production, test them in a similar test environment. The following steps assume that you have a working failover cluster for SQL server. If you don’t, DO NOT PROCEED at this point. If you are having only a single instance of SQL server (tested or untested) or a failover cluster that has been untested or is known not to be working, DO NOT EXECUTE the following steps. Otherwise you might lose data and functionality of your SharePoint environment.

 

1. Open a PPS dashboard.

2. Then, shut the principal SQL server instance down (again: Caution! do not do this in a production environment or without experience. You might lose all or partial functionality of SharePoint temporarily). This is the machine that is running Configuration Manager.

3. The failover server should now take over all the workload of the principal server.

4. Refresh the dashboard. It should work fine.

5. Try to modify it to see whether also write operations work on the PPS failover database.

6. Make sure to start again the SQL Server instance and verify that everything is up and working again.

 

The PowerShell approach:

The same result can also be achieved using the following PowerShell cmdlet:

 

Set-SPPerformancePointServiceApplication –Identity <Identity> –DatabaseFailoverServer <Servername>

 

This is very straightforward and increases the availabilty of your PerformancePoint Services.

Upshot: If you have a running SQL Server failover cluster, with little effort you can achieve high availability also for you Business Intelligence data. Not bad, is it?

 

Stay tuned, and till next time!

Martin (still in Calabria)

Read Full Post »

Dear all,

the same way that you can Toggle the Developer Dashboard using STSADM.exe, you can also toggle it using PowerShell. It is slightly more complicated, but works just as fine and it’s also faster than the STSADM command. Let’s have a look:

$service = [Microsoft.SharePoint.Administration.SPWebService]::ContentService
$ddSettings =$service.DeveloperDashboardSettings
$ddSettings.DisplayLevel = [Microsoft.SharePoint.Administration.SPDeveloperDashboardLevel]::OnDemand
$ddSettings.Update()

What it does, is retrieving the content web service, then retrieve the service’s dashboard developer settings and setting their display visibility level. It can be set to either of these:

[Microsoft.SharePoint.Administration.SPDeveloperDashboardLevel]::On
[Microsoft.SharePoint.Administration.SPDeveloperDashboardLevel]::Off
[Microsoft.SharePoint.Administration.SPDeveloperDashboardLevel]::OnDemand

If you execute script, do it line by line or store them as a scripted .ps1 file before. There will be no success messages, but if you don’t get an error or warning from the PowerShell

Make sure you run these in a SharePoint Management Shell that you started with “Run as administrator”. Otherwise it will not work. Also, using the SharePoint Management Shell saves you from needing to add the SharePoint library using the Add-PSSnapin cmdlet. If  you should decide to open just a “normal” PowerShell command interface, make sure to execute the following:

Add-PSSnapin Microsoft.SharePoint.Powershell

Then run the above mentioned script, it should work fine. Please make sure to test any scripts before running them in a production environment. As usual, I cannot take responsability for any damage caused by scripts on this page. They are provided as-is. Adaptations could be necessary to make it run successfully.

Best regards and stay tuned till the next time!

Martin (currently enjoying the sun in Calabria!)

Read Full Post »

Dear all,

The developer dashboard is a very handy tool in Microsoft SharePoint Server 2010, when it comes to analyzing how your site is loading and finding potential bottlenecks. It displays information about databases, webservices, the current page itself and so on. You can see an example of the developer dashboard here. Once enabled, it can be found scrolling at the bottom of the page you want to analyze.

The Developer Dashboard

There are three states the developer dashboard can be in:

  • On: Displayed
  • Off: Not displayed
  • On Demand: Can be toggled by the user.

And you have three possibilities of turning it on or off:

  • STSADM.exe
  • PowerShell
  • SharePoint COM

In this post, we’ll just focus on the STSADM.exe method, since it is the fastest one. STSADM.exe is located in the HIVE folder of SharePoint 2010 (usually “C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\”, and there in the “BIN” folder).

The STSADM.exe Method:

On:  stsadm -o setproperty -pn developer-dashboard -pv on

Off:  stsadm -o setproperty -pn developer-dashboard -pv off

On Demand:  stsadm -o setproperty -pn developer-dashboard -pv ondemand

Turning it on “On Demand” creates a new button in the menu, which is shown in the following picture:

On Demand Developer Dashboard Toggle Button

On Demand Developer Dashboard Toggle Button

That’s it! The command takes a few seconds to run and then quits with a “Operation successful” message.

Best regards and stay tuned till the next time,

Martin

Read Full Post »

Dear all,

this week is just awesome! After receiving the Microsoft Community Contributor 2011 Award,

it is a great great pleasure & honour to announce that today I have been awarded with the Microsoft Most Valuable Professional Award as of July 2011, in the field of SharePoint Server 2010!

This means I am the first SharePoint MVP in South Tyrol and one of only a hand full in Italy!

It is awarded by Microsoft for outstanding commitment and contributions in technical communities and it is an appreciation for the voluntary work of contributing to the community.

I am really enjoying having received this award and I’m looking forward to be contributing even more to the Microsoft SharePoint, and even more: to join the network of the MVPs worldwide. Currently, there are 4,000+ MVPs in 90 countries worldwide, and about 180 German-speaking MVPs, among which I am (plus Italian & English 😉 ).

 

It is a great motivation to carry on like this, and I’m looking forward to contribute many more times! Thanks to the community, and thanks to Microsoft!

 

Now I’m looking forward to 2 weeks of holidays in Calabria, Italy and will check back with all of you on July, 18th.

 

Best regards,

Martin

Read Full Post »

Dear all,

I’m on vacation for the next 2 weeks and will be back on July, 18th. However, this blog is not standing still in the meantime. 🙂 It will continue emitting posts about SharePoint and Office 365 throughout the next 2 weeks, since I prepared and scheduled several posts, so please check back here regularly. 😉

Wish you all a good time, happy SharePointing, Office 365ing and coding!

Looking forward to check back with you soon!

Best regards,

Martin

Read Full Post »

Older Posts »