Feeds:
Posts
Comments

Archive for the ‘Opinion’ Category

Dear readers,

I have decided to discontinue this blog and not further publish posts on SharePoint. Thank you for more than 160,000 visits!

I am now writing a blog on algorithms and science, which is hosted at http://www.scilogs.com The blog is called Algoworld:

Algoworld is all about algorithms, mathematical and computer models and how they influence and shape our daily lives. They are either inspired by science, or they are aiding it.
The models and algorithms you will find here deal with the prediction of hurricanes, earthquakes, health and crime (and many more to come!), but also with solving engineering problems like traffic jam optimization. Many of these algorithms are strongly interwoven with the analysis of scientific “big data” – hence they are also facing its implied problems.

You can find it here: Algoworld – algorithms meet science.

I hope to see you there!

Best wishes,
Martin W. Angler

Read Full Post »

Dear all,

it’s a celebration day: angler.wordpress.com has reached a 50,000 hits!

 

Print

 

It’s about time to say thanks to all of you out there!

Numbers are still increasing, and currently we have about 3,000 views per month on average.

 

We will continue to contribute as much as we can about SharePoint Server!

 

Cheers!

Martin

Read Full Post »

Dear all,

it is my pleasure to announce a new initiative of communicating SharePoint knowledge via videos using the “SharePointFive” approach: Show how technical configurations are done within only a few minutes (guideline: 5 mins per video, up to a max of 15 in special cases.

If you want to learn about SharePoint 2010 configurations, but only want to invest a few minutes at a time, if you are looking for the essentials that make up what you actually want to do, then SharePointFive is for you.

SharePointFive (SharePoint5)

SharePointFive is a youtube channel, that you can access under the below mentioned URL. It contains all videos (currently 1 only :-)) that have been and will be published, showing how to apply SharePoint (or related) configurations in just a few minutes. Usually, like in this case, there will be published a related blog post on angler.wordpress.com, in order to facilitate it for you to copy scripts and apply them.

SP5Logo

http://www.youtube.com/sharepointfive

The Video

The video will give you an idea of the steps to be executed, a few caveats. But most of all, it is only a few minutes long and won’t take a long time to watch. This first episode of SharePointFive is  a bit longer (about 12-13 minutes), since it contains also the explanation and motivation why SP5 has been launched.

The Scripts

1. Create the Master Key:

 1: USE master;
 2: 
 3: go
 4: 
 5: CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'n0PWStealingAll0w3d!';
 6: 
 7: go

2. Create the Certificate:

 1: CREATE CERTIFICATE SP5Certificate WITH SUBJECT = 'SP5 DEK Certificate';
 2: go
 3: 

 

3. Back up Certificate & Private Key (EXTREMELY IMPORTANT TO KEEP IT BACKUPPED AND SAFE!):

 1: USE master;
 2: go
 3: BACKUP CERTIFICATE SP5Certificate TO FILE = 'C:\Certificate\TDECertificate.cer'
 4: WITH PRIVATE KEY (
 5: FILE = 'C:\Certificate\PK.pvk',
 6: ENCRYPTION BY PASSWORD = '?pkP4SsW0rD!');
 7: GO

4. Create Database Encryption Key:

 1: CREATE DATABASE ENCRYPTION KEY WITH ALGORITHM = AES_256 ENCRYPTION BY SERVER CERTIFICATE SP5Certificate;
 2: 
 3: GO

5. Enable Transparent Data Encryption for a Specific Content Database:

 1: CREATE CERTIFICATE SP5Certificate WITH SUBJECT = SP5Certificate;
 2: go

Please bear in mind:

  • Scripts need to be adapted to your needs, of course
  • Please run everything in a isolated test environment, before applying on production level
  • Consult your DBA before applying any changes to the SQL Server Instance, like running the beforementioned scripts.
  • The author of this blog cannot take responsibility for any damages caused by executing scripts, programs and configurations shown
  • It is your responsibility to inform yourself about possible side effects that are not reported. Usually, Technet and MSDN are good references for complete documentation of the concepts shown.
  • The scripts of SharePointFive are provided “as is”

Stay tuned till the next episode of SharePoint 5 and enjoy!

Best,

Martin

Read Full Post »

The good news

The manuscript is finished and submitted! Now I’m waiting for feedback, and certainly some corrections will be made. However, the big stuff is done.

Einstieg in Business Intelligence mit Microsoft SharePoint 2010: Überblick und Konfiguration der Business Intelligence-Features von SharePoint 2010

Preview it here: Einstieg in Business Intelligence mit SharePoint 2010

Below you can get some numbers about how I passed the last 4 months writing:

 

Book numbers

  • 1 Book
  • 9 chapters
  • 3 appendices
  • 340 pages
  • 250 images
  • 1.5 GB of content created

Time statistics

  • 500 hrs of writing
  • 142 hrs/month (yes, it’s become my second fulltime job)
  • 4.5 hrs sleep/day
  • 14 holidays taken for fulltime writing
  • Average hour of going to sleep:
    • First month of writing: 11.30 p.m
    • Last month of writing: 03.00 a.m.

Trivia

  • 15 albums listening to while writing (7 from which Rammstein)
  • 1 640GB backup hard disk smashed on the floor, causing:
    • INF swearings over the broken hard disk
    • 1 shock proof hard disk purchased
  • 1 MacBook Pro AC adapter cable chewed to death by cat
  • INF amount of:
    • Coffee
    • Red Bull
    • Tea
    • Fresh Fruit
    • Sweets

It was a great experience to write the book and I had the chance to take a 4 month intensive course in specializing on selected topics. However, now I’m really looking forward to increase my sleeping again back from 4.5 to 8 hours!

😉

 

Stay tuned and 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,

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 »

I just received the Microsoft Community Contributor Award!
Microsoft Community Contributor Award 2011

Today, while watching TV, I received an email from support@microsoftcommunitycontributor.com. It was stating:

Congratulations! We’re pleased to inform you that your contributions to Microsoft online technical communities have been recognized with the Microsoft Community Contributor Award.

The Microsoft Community Contributor Award is reserved for participants who have made notable contributions in Microsoft online community forums such as TechNet, MSDN and Answers. The value of these resources is greatly enhanced by participants like you, who voluntarily contribute your time and energy to improve the online community experience for others.

[…]

This is a great honor to me to be awarded with this recognition. After all, it’s a great pleasure to dedicate time and to contribute something meaningful to the community. So thanks, Microsoft for awarding me the MCC award, and thanks also to the unknown promotors who have proposed me for this.

This is a big motivation for going on like until now. So I’m looking forward to many, many more contributions!

Thanks and best regards,

Martin

Read Full Post »

Hi all,

 

these are the latest news about the Office 365 launch in NY, where Mr. Steve Ballmer presented the following information. Office finally has moved to the cloud.

 

Janice Kapner gave a brief introduction and welcomed then Steve Ballmer.

image

 

These are the key points Ballmer named before the demo:

 

  • Simultaneously working on documents
  • Realtime collaboration and meetings
  • Suited for business of any size
  • Instant access
  • Small- and midsized businesses can compete now with the “big shots”

 

 

image

 

During the demo, the following things were shown:

 

  • Office 365 start screen w/quick access to Apps
  • Office Web Apps – simultaneous editing the same document
  • Browser-based Applications render exactly the same result as client-based applications
  • Connecting Windows Phone 7 to Office 365 thru Office Hub
  • Integrating OneNote on WP7, Browser and Client Apps – really fast synchronisation
  • 25 GB Email access
  • Lync meetings’ organization
  • Video conferences w/ simultaneous presentations
  • SharePoint Online website editing using the SP Online UI

 

For the rest of the talk, Ballmer was mainly pointing out the opportunities for small- and midsized businesses to get an enterprise collaboration platform with Office 365, that will help not only to maintain contacts and collaboration among employees but also with the outside world.

 

Some more facts:

 

Monthly subscription is available.

70% of the Office 365 Beta users were small- to midsized companies.

 

One big advantage Ballmer mentioned is the possibility for small businesses, to decide not to run an IT infrastructure of their own, but to outsource it to the cloud.

 

Best regards,

Martin

Read Full Post »

Hi all,

as you probably know, Office 365 is about to be released to the public. Today, Steve Ballmer is going to talk in a live webinar and probably will announce that Office 365 is final and ready.

 

http://www.microsoft.com/presspass/press/2011/jun11/06-20MSMOD365MA.mspx

 

I also joined the beta and found the interface very fast and efficient. Especially the web apps rock and are just as responsive as their corresponding client versions are. Great stuff so far!

 

However, there is a weird error that I stumbled across: When creating a new document, opening the dropdown for the font, then *not* selecting a font but clicking back in the writing’s area, the Word Web App crashes.

 

image

Fig. 1: After creating a document: Everything’s still fine

 

image

Fig. 2: After opening the fonts’ dropdown: Still fine

 

image

Fig. 3: After clicking back into the writing’s area.

 

It’s not much of a problem, since you can easily restart the Word Web App and re-open the document using the “Restart” button of the dialog in Fig. 3, but any unsaved text is lost in such a case.

 

Has anyone else encountered this?

Best regards,

Martin

Read Full Post »

1. Close Distance Rule:

Keep Web Frontends, Application Servers and Database Servers physically located as close as  possible.

 

Rule of thumb: No more than 1 ms of latency between WFEs/AS and DB servers. In practice, this means: WFEs/ASs should reside in the same data center as DB servers.

 

 

2. Co-Location/Separation of Databases

Certain databases must be co-located or ideally separated from other databases.

 

Rule of thumb: Separate the following databases:

 

 

 

image

Source: Microsoft Technet

 

Rule of thumb: Co-locate the following databases:

 

 

image

Source: Microsoft Technet

 

3. Constantly Monitor Database Servers

Size: Rules of thumb:

    Pre-grow databases and logs.

    Monitor disk space at all times.

    < 50 Databases per SQL Server instance (when mirroring)

                          < 200 GB per content database

 

 

Metrics: Rules of thumb:

    Network Queue: 0 or 1 for best performance

    Average Disk Queue length (latency) : < 5 ms

                       Memory used: < 70%

                       Free disk space: > 25%

                       Buffer cache hit ratio: >= 90%

 

4. Transaction Logs Backup

Rule of thumb: Back up and truncate the transaction logs every 5 minutes. Shrinking the transaction logs is not recommended since it will have a performance impact while it re-grows.

 

 

For preventing the transaction logs to grow unexpectedly, view the following KB: http://support.microsoft.com/kb/873235

 

That’s it for this time. Have fun configuring your DB servers for your SP2010 environment. As usual, no responsibility is taken for any damage that could occurr. And as ususal, I highly recommend trying all changes on a test environment and the adaptation to your specific IT infrastructure.

 

Enjoy and best regards,

Martin

Read Full Post »

Older Posts »