Tag Archives: SharePoint 2013
SharePoint 2013 MCSE Certified
This weekend I passed exam 070-332 and obtained the “MCSE” certification for SharePoint 2013. The exams were challenging (in a good way) because that increases the meaning and value of certification.
If you haven’t seen Vlad Catrinescu’s Ultimate SharePoint 2013 Certification Guide please go check it out. That’s a fantastic resource for learning what certifications are available in the marketplace. I didn’t even realize that Yammer and Business Intelligence have their own multiple exam tracks until I read this.
Next I plan to focus on the MCSD developer track starting with exam 070-480 for HTML5. Certification can be time consuming and easy to lose track of, but it really is helpful to have a structured course of study. There were so many features I haven’t used directly, but needed to learn about for the exam that helped round out my technical knowledge by opening up new topics.
New MS downloads for SharePoint
I noticed a handful of new Microsoft downloads published today on the RSS feed and wanted to share those links here in case others might find them helpful:
- Poster: What is governance in SharePoint 2013?
- SharePoint 2013 REST Syntax (wall posters)
- Test Lab Guide: Configure eDiscovery for an Exchange, Lync, SharePoint, and Windows File Shares Test Lab
Noderunner.exe – show search role (Query, Index, ContentProcessing, Analytics, Admin)
During performance troubleshooting you might discover “noderunner.exe” is consuming a lot of hardware. But what does it do? Well, noderunner supports everything for search in SharePoint 2013. The trick is knowing which PID instance of “noderunner.exe” matching to which search role:
- Query
- Index
- ContentProcessing
- Analytics
- Admin
Below you can see the “Command Line” property of each running process. Here, we can see the “—noderoot” argument when the EXE first launched. That clearly shows the role so you’ll know if CPU is high or RAM is low because of a single particular search role. Also, I’ve included a PowerShell command to get the same output.
Hope that helps! 
gwmi win32_process -filter "name='noderunner.exe'" | select name,processId,commandLine | fl
PowerShell – Notify all site users for outage / maintenance
The below PowerShell can be used to email all users of all site collections on your system. I find this helpful when planning maintenance outages to alert users of the down time, impact, and changes being performed.
Get-SPSite -Limit All |% {$url = $_.url;$_.RootWeb.SiteUsers | select UserLogin, DisplayName, Email, @{Name="SiteUrl";Expression={$url}}} | Export-Csv SiteUsers.csv
Do not start Server Manager automatically at logon
This option is harder to find in Windows Server 2012 than it was in 2008R2. A quick blog will help me remember and maybe even help some of you fine folks also. Cheers! 
Test Lab Guides for #SP2013
I saw a handful of test lab guide downloads hit the MS download RSS feed today and wanted to share all of them in one place for quick reference.
Test Lab Guide: Configure SharePoint Server 2013 in a Three-Tier Farm
Test Lab Guide: Demonstrate Forms-Based Authentication with SharePoint Server 2013
Test Lab Guide: Demonstrate Permissions with SharePoint Server 2013
Test Lab Guide: Configure Intranet and Team Sites with SharePoint Server 2013
Test Lab Guide: Demonstrate SAML-based Claims Authentication with SharePoint Server 2013
Business Intelligence Demo VHD (Part 2 of 10) – Windows Server 2012
We continue the build by installing Windows Server 2012 Standard Edition with GUI. The default install choice is server code (no GUI) but we will want the GUI to work with SharePoint and BI features interactively. For security, I am using “pass@word1” on all areas including local Administrator.
NOTE – There are some helpful tricks at http://www.win2012workstation.com/ if you plan to use this server with RDP for demos to get a more robust desktop like experience. Otherwise, you can always browse over HTTP from the VM host. Sometimes that’s a good way to show cross browser compatibility (IE, FireFox, Chrome, etc.)
I like to run Windows Update before doing anything else just to make sure I’m current and hopefully avoid errors.
I modified the computer name to be “DEMO2013A” for matching the Content Pack scripts from CodePlex documented requirements.
I modified the user “Administrator” to be just “Admin” for easier typing. This name will have to be typed into all sorts of places, easier to save a few keystrokes.
Next, it’s a good idea to load the VM guest additions. This might be different for other VM products (VMWare, Hyper-V, etc.)
Then we can modify PowerShell to have unrestricted execution policy. This will allow for running any PS1 script file without security prompt. I am using this for DEV, but in practice it is better to keep “RemoteSigned” for production.
Next, we run the Microsoft Content Pack Installer so that we can deploy package files downloaded from https://sharepointdemobuilds.codeplex.com/
Business Intelligence Demo VHD (Part 1 of 10) – Prepare VM
This series of posts covers in detail my experience with installing SharePoint 2013 and SQL 2012 BI features using http://sharepointdemobuilds.codeplex.com/
One of my favorite demos with SP2010 was the “Information Worker” VHD because it had so many great visuals, people, org charts, SharePoint team sites, and databases for BI. I haven’t been able to find any IW download VHD for SP2013.
However, today we have http://sharepointdemobuilds.codeplex.com/. Ivan Sanders was kind enough to package sample content with automated deployment. NOTE – There is no complete VHD file. You must obtain installation media for each Microsoft product (Windows, SQL, SharePoint). Trial editions are available and work fine, but you will need install from media. Below are screenshots from my experience configuring SP2013 with the demo content.
Please leave a comment if you found this post series helpful. 
First we need to create a VHD container for the machine we plan to build. This can be done on any Windows 7/8 machine by opening Computer Manager and right clicking on Disk Management. I chose to create a 96 GB dynamic file. That allows room to expand while minimizing current disk usage.
The disk must be initialize to prepare it for the Windows O/S install we’ll perform next. Default options (MBR) are fine here.
The VHD file is now complete and ready for use in any VM host software. I chose VHD format for wide compatibility.
Next, we will create the VM guest machine. I am using VirtualBox (http://www.virtualbox.org) because it’s free and runs well on any Windows 7/8 desktop. The specifications I am using are shown below. NOTE – More RAM would boost performance. I have 10GB RAM and pointed to the VHD file we just created for storage. Also, I attached the Windows 2012 install media ISO to the virtual CD-ROM so we can boot and install.
Site Templates (all 17 w/ screenshots)
Microsoft offers 17 site templates in SharePoint 2013 Enterprise Edition. Below are descriptions of each with a homepage screenshot. Also, I included the PowerShell script I used to create all 17 site collections so you can copy/paste to run on your farm. Please leave a comment if you found this helpful. 
Get-SPWebTemplate |% {Write-Host $_.Name;$url=$_.Name.Replace("#","-");New-SPSite -URL http://intranet.contoso.com/sites/$url -OwnerAlias "CONTOSO\Administrator" -Language 1033 -CompatibilityLevel $_.CompatibilityLevel -Template $_.Name}Team Site
A place to work together with a group of people.
Blog
A site for a person or team to post ideas, observations, and expertise that site visitors can comment on.
Developer Site
A site for developers to build, test and publish apps for Office.
Project Site
A site for managing and collaborating on a project. This site template brings all status, communication, and artifacts relevant to the project into one place.
Community Site
A place where community members discuss topics of common interest. Members can browse and discover relevant content by exploring categories, sorting discussions by popularity or by viewing only posts that have a best reply. Members gain reputation points by participating in the community, such as starting discussions and replying to them, liking posts and specifying best replies.
Document Center
A site to centrally manage documents in your enterprise.
eDiscovery Center
A site to manage the preservation, search, and export of content for legal matters and investigations.
Records Center
This template creates a site designed for records management. Records managers can configure the routing table to direct incoming files to specific locations. The site also lets you manage whether records can be deleted or modified after they are added to the repository.
Business Intelligence Center
A site for presenting Business Intelligence content in SharePoint.
Enterprise Search Center
A site focused on delivering an enterprise-wide search experience. Includes a welcome page with a search box that connects users to four search results page experiences: one for general searches, one for people searches, one for conversation searches, and one for video searches. You can add and customize new results pages to focus on other types of search queries.
My Site Host
A site used for hosting personal sites (My Sites) and the public People Profile page. This template needs to be provisioned only once per User Profile Service Application, please consult the documentation for details.
Community Portal
A site for discovering communities.
Basic Search Center
A site focused on delivering a basic search experience. Includes a welcome page with a search box that connects users to a search results page, and an advanced search page. This Search Center will not appear in navigation.
Visio Process Repository
A site for viewing, sharing, and storing Visio process diagrams. It includes a versioned document library and templates for Basic Flowcharts, Cross-functional Flowcharts, and BPMN diagrams.
Publishing Portal
A starter site hierarchy for an Internet-facing site or a large intranet portal. This site can be customized easily with distinctive branding. It includes a home page, a sample press releases subsite, a Search Center, and a login page. Typically, this site has many more readers than contributors, and it is used to publish Web pages with approval workflows.
Enterprise Wiki
A site for publishing knowledge that you capture and want to share across the enterprise. It provides an easy content editing experience in a single location for co-authoring content, discussions, and project management.
Product Catalog
A site for managing product catalog data which can be published to an internet-facing site through search. The product catalog can be configured to support product variants and multilingual product properties. The site includes admin pages for managing faceted navigation for products.
PowerShell – download all files in a Document Library
I needed to download the full contents of a Document Library to a local folder. Explorer View, SharePoint Designer, and WebDAV simply weren’t fast enough for the large number of items needed. So I wrote a quick script:
PowerShell – SOM (Server Object Model)
$s = Get-SPSite “http://sp2013”
$files = $s.RootWeb.GetFolder("Shared Documents").Files
foreach ($file in $files) {
Write-host $file.Name
$b = $file.OpenBinary()
$fs = New-Object System.IO.FileStream(("d:\temp\"+$file.Name), [System.IO.FileMode]::Create)
$bw = New-Object System.IO.BinaryWriter($fs)
$bw.Write($b)
$bw.Close()
}
PowerShell – Remote HTTP (Client Side / Office 365)
# Download all files from a SharePoint Document Library view to the local folder over HTTP remotely.
# No server side requirement, can run anywhere, including end user desktops.
param (
$url, # "http://portal/sites/test",
$listID, # "41E5FC8E-D174-4F48-AC3C-79F999A045D1",
$viewID # "5E9415B3-3C63-48AD-9DC2-A5A282B61790"
)
# Current folder
$scriptpath = Split-Path $MyInvocation.MyCommand.Path
# Open file list
Write-Host "Opening $url"
$ows = "$url/_vti_bin/owssvr.dll?Cmd=Display&List={$listID}&View={$viewID}&XMLDATA=TRUE"
$owsList = "$url/_vti_bin/owssvr.dll?Cmd=ExportList&List={$listID}&XMLDATA=TRUE"
$r = Invoke-WebRequest $ows -UseDefaultCredentials
$rList = Invoke-WebRequest $owsList -UseDefaultCredentials
$xml = $r.Content
$xmlList = $rList.Content
$folder = $xmlList.List.Url
# Client
$client = New-Object System.Net.WebClient
$client.UseDefaultCredentials = $true
# Loop and download
foreach ($row in $xml.xml.data.row) {
$name = $row.ows_LinkFilename
$from = "$url/$folder/$name"
$client.DownloadFile($from, "$scriptpath\$name")
}
Write-Host "DONE"NOTE – Remote HTTP (Client Side / Office 365) can recurse files from all sub-folders by updating the View to “Show all items (all folders)”
References
