SharePoint Dragons

Nikander & Margriet on SharePoint

Small Windows Trick to be used for Excel files

Suppose you have a folder filled with dozens of Excel files, and you want to merge all of them together in one go, here’s a small trick you can apply:

1) Open a command prompt.

2) Go to the folder that contains all Excel files.

3) Type: copy *.csv test.csv

Presto, the result is 1 file called test.csv that is the result of the merge of all other files! A little trick that some day will save a lot of time!

Data Collector Set for SharePoint WFEs

Check out Margriet’s latest TechNet gallery upload at: http://gallery.technet.microsoft.com/Data-Collector-Set-for-a-08c6a39d It contains a useful set of performance counters ready to import in perfmon so you can start monitoring right away.

Data Collector Set for SharePoint back-ends: SQL Server

Check out Margriet’s latest TechNet gallery upload at: http://gallery.technet.microsoft.com/Data-Collector-Set-for-6fefef51 It contains a useful set of performance counters ready to import in perfmon so you can start monitoring right away.

Setting up test user accounts with photos

This is a nice article about setting up test user accounts, the nice touch is that it takes photos from a photo service to make testing a lot more fun and realistic. We really like this article:

http://social.technet.microsoft.com/wiki/contents/articles/22864.sharepoint-create-2000-domain-accounts-with-profile-photos-for-a-development-environment.aspx

Top support solutions

Handy overview of top support solutions taken from the various SharePoint forums:

http://blogs.technet.com/b/topsupportsolutions/archive/2013/11/05/top-support-solutions-for-microsoft-sharepoint-server.aspx

Getting and Setting fields in Code

Progress Bar

Stop list crawl

Ahum, “Better know the SharePoint framework”. A little gem for disabling the crawling of a list: http://msdn.microsoft.com/en-US/LIBRary/microsoft.sharepoint.client.list.nocrawl.aspx

The Man Who Saved TechNet Wiki

The Subtle Art of Not-Convincing People

And here’s the latest Wiki Ninja blog post of Margriet called “The Subtle Art of Not-Convincing People”. Check it out at: http://blogs.technet.com/b/wikininjas/archive/2014/01/05/the-subtle-art-of-not-convincing-people.aspx

Follow

Get every new post delivered to your Inbox.

Join 630 other followers