SharePoint Dragons

Nikander & Margriet on SharePoint

Monthly Archives: March 2013

Nice PowerShell Examples for working with SharePoint 2013

Dan Holme provided some really nice PowerShell examples to do some of the most common basic SharePoint tasks, such as creating site collections and adding people to groups. You can use them as an easy reference to start creating your own .ps1 files. If interested, check out:

The Definitive Feature Overview Overview?

The SharePoint 2013 Best Practices page contains an overview of all SharePoint 2013 and SharePoint Online feature overviews that are really worth your time:

Small SharePoint Free e-Book

In case you’re interested, this a small and free e-book about SharePoint 2013:

Drinking the Poison Cup

Taming Text


When you haven’t done it yourself, it’s hard to imagine the effort that goes into writing a book. Not just a couple of chapters, but an entire book. Sometimes, we hear complaining about the lack of in depth books, but we guess that a lot of people don’t realize that the more in depth a book gets, the more work it is to write, and the smaller the audience for the book becomes. Because of this mechanism, with a new product release you’ll see lots of books getting published covering more or less the same grounds.

When we were technical reviewers of the book “Taming Text” it became quite clear that this was one of those rare cases where a very specific topic gets covered in great depth. We have one fear for this book, the fear that the audience for this book will be so small that the end result won’t be very satisfying for the authors. This is undeserved, as it is a great book.

What is it about? Basically, it covers how to find, organize, and manipulate text. It discusses topics such as:

  • How to work with phrases, clauses, morphology
  • Searching and indexing
  • Fuzzy string matching
  • Identifying people, places, and things
  • Clustering text
  • Classification, categorization, and tagging

If you belong to the audience that is interested in this, check out

PowerPoint Picture Transparancy

This was just the small PowerPoint trick we were looking for, making a picture transparant:

NDepend Review

It has been quite some time since we looked at the NDepend tool ( We remember reading a Robert C. Martin book and were enthusiastic about his ideas about assembly dependencies. Back then, we were pleasantly surprised to find out that there was a tool based on the ideas of Robert C. Martin, and did some experimenting with it, but for some reason the tool didn’t quite fit in our development process.

Recently, we took another look at the tool and were pleasantly surprised by the way it has evolved. It has been designed to participate in Continuous Integration (CI) scenarios, has become a full-blown code analysis tool including nice reporting capabilities, and the documentation and ease of use are top notch. The feature we like best of all is the little amount of effort it takes to create your own code rules, something we have really want for some time and found to be lacking in the standard Visual Studio Static Code analysis features.

Let’s take a moment to discuss some of the other features…

  • There’s a visual tool that allows you to inspect NDepend projects (that analyze your own VS projects) without having to start Visual Studio separately.
  • There’s a console tool that ios ideal for CI purposes.
  • There’s a VS add-in(also support VS 2012) allowing easy access to NDepend features:
  • The Queries and Rules explorer performs static code analysis of your code:
  • The tool is shipped with nice reporting capabilities:
  • You can run Linq queries live at design time to inspect the code base you’re working with:
  • The Dependency Graph is impressive:
  • Great in-context info. In the example below we use NDepend to find out which methods are using the current method:
  • NDepend allows you to Diff separate versions of source files and highlights the differences ( )
  • Of course, the unique Robert C Martin package dependency report isn’t missing, and luckily our PressurePoint is doing wonderful:

The tool is packed with handy features:

As said before, our favorite feature is the ability to quickly create new code rules. You can do this just by using some Linq code and learn from the examples. For instance, the next code rule checks for methods that are considered to be too big:

// <Name>Methods too big</Name>

warnif count > 0 from m in JustMyCode.Methods where

m.NbLinesOfCode > 30 ||

m.NbILInstructions > 200

orderby m.NbLinesOfCode descending,

m.NbILInstructions descending

select new { m, m.NbLinesOfCode, m.NbILInstructions }

// Methods where NbLinesOfCode > 30 or NbILInstructions > 200

// are extremely complex and should be split in smaller methods.

// See the definition of the NbLinesOfCode metric here


This rule checks method access modifiers:

// <Name>Methods that could have a lower visibility</Name>

warnif count > 0 from m in JustMyCode.Methods where

m.Visibility != m.OptimalVisibility &&

!m.HasAttribute(“NDepend.Attributes.CannotDecreaseVisibilityAttribute”.AllowNoMatch()) &&

!m.HasAttribute(“NDepend.Attributes.IsNotDeadCodeAttribute”.AllowNoMatch()) &&

// If you don’t want to link NDepend.API.dll, you can use your own attributes and adapt this rule.

// Eliminate default constructor from the result.

// Whatever the visibility of the declaring class,

// default constructors are public and introduce noise

// in the current rule.

!( m.IsConstructor && m.IsPublic && m.NbParameters == 0) &&

// Don’t decrease the visibility of Main() methods.


select new { m,

m.Visibility ,

CouldBeDeclared = m.OptimalVisibility,

m.MethodsCallingMe }

Finally an easy way to implement code rules specific to our own projects. All in all, we’re happy with our brand new toy! If you want to take it for a test spin you can get it here:

The Perpetuum Mobile

SharePoint 2013 Back-up

SharePoint 2013 Best Practices

The SharePoint 2013 Best Practices was updated again and is becoming more extensive: