Tuesday, June 28, 2016

Organization Browser in 2013

 

image

FIX

https://support.microsoft.com/en-us/kb/2643420

Repost …

Fix – add following code below web part using content editor web part.

<script type="text/javascript">
function CreateHierarchyChartControl(parentId, profileId, type, persistControlId) {
  var i = profileId.indexOf("|");
  var claimsmode = profileId.substr(i-1,1);
  if((i >=0 ) & (claimsmode=="w"))
  {
   profileId = profileId.substr(i+1,profileId.length-i-1);
   var initParam = profileId + ',' + type + ',' + persistControlId;
   var host = document.getElementById(parentId);
   host.setAttribute('width', '100%');
   host.setAttribute('height', '100%');
   Silverlight.createObject('/_layouts/ClientBin/hierarchychart.xap',
    host,
    'ProfileBrowserSilverlightControl',
    {
     top: '30',
     width: '100%',
     height: '100%',
     version: '2.0',
     isWindowless: 'true',
     enableHtmlAccess: 'true'
    },
    {
     onLoad: OnHierarchyChartLoaded
    },
     initParam,
     null);
    }
  }
</script>

Monday, June 27, 2016

SQL Admin Tips and Tricks for SharePoint Admins

If you are a SharePoint Admin, you are probably a reluctant SQL admin, since few are SharePoint admins first.  There are the SQL admins and developers that are required to understand SharePoint but in my travels they are the exceptions not the rules.  So here are some links to help out those newly appointed SQL admins.

Troubleshooting Port Redirection

SQL Port Redirection - SQL Alias
https://technet.microsoft.com/en-us/library/ff607733(v=office.16).aspx

SQL Port Redirection – Cliconfg
https://nikpatel.net/2013/09/05/step-by-step-configuring-sql-alias-on-all-sharepoint-web-and-application-servers/

SQL Port Redirection – Testing
https://social.technet.microsoft.com/Forums/office/en-US/7dcf9b8d-ba48-4c09-bb31-84a55908de1c/change-sharepoint-from-port-1433-to-something-else

Frienemies – SQL Gardner’s great presentation

http://blogs.msdn.com/b/sqlgardner/archive/2013/06/12/presentation-from-dayspug.aspx

SQL Performance Presentations

Bill Baer - Tuning SQL Server 2012 for SharePoint 2013
Mod 01: Key SQL Server and SharePoint Server Integration Concepts
Mod 02: Best Practices for SQL Server Database Settings
Mod 03: Server Settings for SQL Server
Mod 04: SQL Server and SharePoint Availability

More Good Stuff

SQL 2012 improvements

Appendix

Database Recovery Model
image

Free Book on Backup and Restore
http://www.red-gate.com/community/books/sql-server-backup-and-restore

Free Whitepaper – Maximizing SQL 2012 Performance for SharePoint 2013
http://sharepoint-community.net/profiles/blogs/free-whitepaper-maximizing-sql-2012-performance-for-sharepoint-20

Tuesday, June 21, 2016

SharePoint Labs – 2016 2013 2010

2016

Using Azure to create SharePoint Labs
https://blogs.msdn.microsoft.com/mvpawardprogram/2015/05/25/create-a-sharepoint-production-farm-on-azure/
More from the cloud engineer

2013

Several Setup 2013 labs for Testing or Dev Environment http://thuansoldier.net/?p=2618
http://sharepointdemobuilds.codeplex.com/
http://blogs.technet.com/b/keithmayer/archive/2013/01/07/step-by-step-build-a-free-sharepoint-2013-lab-in-the-cloud-with-windows-azure-31-days-of-servers-in-the-cloud-part-7-of-31.aspx#.Uz8DcvldU3I
http://absolute-sharepoint.com/2014/10/create-sharepoint-2013-farm-in-azure-step-step.html
Sorry Office Demos are now gone – pulled June 30 2014.

2010

SharePoint 2010 Virtual Labs
http://technet.microsoft.com/en-us/virtuallabs/bb512933.aspx

2012 SQL Server Microsoft has posted this VHD
Business Intelligence - SQL Server 2012 – RC0 - PowerView - PowerPivot Excel Documents.
http://www.microsoft.com/betaexperience/pd/BIVHD/enus/default.aspx (Large Download)
Note that these use hyper-v in Windows Server but if using Windows 7 you can download Virtual PC
http://www.microsoft.com/windows/virtual-pc/download.aspx
Converting the SharePoint and Office 2010 Information Worker Virtual Machines to VMWare from Hyper-V http://sharepointyankee.com/2010/06/03/converting-the-sharepoint-and-office-2010-information-worker-virtual-machines-to-vmware-from-hyper-v/

SharePoint 2010 SP1 VHD (Virtual Hard Drive)
If you don't want virtual labs (too slow) then use this great VHD from Microsoft.  I was able to reduce the memory to 6 GB and the first VM with sharepoint installed has worked well.  The other two VMs that contain Lync and Exchange remain untested.
http://www.microsoft.com/en-us/download/details.aspx?id=27417
Video Bonus – Setting Up a SharePoint Developer Virtual Machine
http://www.sharepoint-howto.com/2011/12/16/setting-up-a-sharepoint-developer-virtual-machine/

Here is more information from Microsoft on the Information Worker Demo. Note that this download contains a three Windows Server 2008 R2 SP1 Hyper-V Virtual Machines set for evaluating and demonstrating Office 2010, SharePoint 2010 and Project Server 2010.  Login to all Virtual Machines using the Virtual Machine Console as the following user:

User: administrator
Password: pass@word1
Domain: CONTOSO

Virtual machine “a” contains the following pre-configured software:
  1. Windows Server 2008 R2 SP1 Standard Evaluation Edition, running as an Active Directory Domain Controller for the “CONTOSO.COM” domain with DNS and WINS
  2. Microsoft SQL Server 2008 R2 Enterprise Edition with Analysis, Notification, and Reporting Services
  3. Microsoft Visual Studio 2010
  4. Microsoft SharePoint Server 2010 SP1 Enterprise Edition
  5. Microsoft Office Web Applications SP1
  6. Microsoft FAST Search for SharePoint 2010 SP1
  7. Microsoft Project Server 2010 SP1
  8. Microsoft Office Professional Plus 2010 SP1
  9. Microsoft Visio 2010 SP1
  10. Microsoft Project 2010 SP1
  11. Microsoft Lync 2010
Virtual machine “b” contains the following pre-configured software:
  1. Windows Server 2008 R2 SP1 Standard Evaluation Edition, joined to the “CONTOSO.COM” domain
  2. Microsoft Exchange Server 2010 SP1
Virtual machine “c” contains the following pre-configured software:
  1. Windows Server 2008 R2 SP1 Standard Evaluation Edition, joined to the “CONTOSO.COM” domain
  2. Microsoft Lync Server 2010
Active directory has been preconfigured over 200 “demo” users with metadata in an organizational structure. All of these user profiles have been imported and indexed for search within SharePoint Server 2010, with “contoso\administrator” granted Domain Admin permissions.
SharePoint Server 2010 has been configured in a “Complete” farm using the default SQL Server 2008 R2 instance. A default site has been created using the Team Site template at http://intranet.contoso.com/ and a FAST Search Center at http://intranet.contoso.com/search/.
Virtual machine “a” is required for all scenarios, image “b” for email functionality and image “c” for instant messaging.

Wednesday, June 15, 2016

SharePoint 2016 Updates


SharePoint MVP now called Microsoft Office Server & Services MVP

Articles

Posters - Technical diagrams for SharePoint (2013 2016)
https://technet.microsoft.com/en-us/library/cc263199.aspx

SharePoint 2016 (TechNet)
https://technet.microsoft.com/en-us/library/cc303422(v=office.16).aspx

Index of Windows PowerShell cmdlets for SharePoint Server 2016
https://technet.microsoft.com/en-us/library/ff678226(v=office.16).aspx

SharePoint 2016 Upgrade Requirements. Veified 2013 experience required!
http://danielglenn.com/sharepoint-2010-site-experience-with-sharepoint-2016/

SharePoint 2016 New and Deprecated Features
http://connectedsystems.com/news/Latest%20News/SharePoint-2016-new-and-deprecated-features.aspx

Issues

Missing SharePoint Templates in Visual Studio 2015?
https://blog.devoworx.net/2016/07/14/office-sharepoint-template-missing-in-visual-studio-2015/

Updates

SharePoint Summit 2017

http://thecloudengineer.blogspot.com/2017/05/sharepoint-virtual-summit.html

ZDP - Zero Downtime Patching

ZDP - SharePoint Server 2016 – Video
https://technet.microsoft.com/en-us/library/mt767550(v=office.16).aspx
ZDP - SharePoint Server 2016 – Diagram with Steps
https://technet.microsoft.com/en-us/library/mt743024(v=office.16).aspx

ZDP in SharePoint Server 2016
https://blogs.technet.microsoft.com/pla/2016/03/10/zero-downtime-patching-in-sharepoint-server-2016/

ZDP with SharePoint Server 2016 Start to Finish
https://blogs.technet.microsoft.com/sharepoint_foxhole/2016/08/04/zero-downtime-patching-with-sharepoint-server-2016-start-to-finish/

PSConfig
https://blogs.technet.microsoft.com/stefan_gossner/2015/09/09/why-we-recommend-require-to-run-the-configuration-wizard-also-for-security-fixes/

NOTE MinRole is not required as per video, reboot after binaries or patch install

Feature Pack 1

Feature Pack 1 – New Shared MinRoles
https://blogs.office.com/2016/09/26/announcing-feature-pack-1-for-sharepoint-server-2016-cloud-born-and-future-proof/

Check Patch Level
https://blogs.technet.microsoft.com/stefan_gossner/2016/08/23/sharepoint-does-not-have-a-build-version-full-stop/

New Site Contents Page

image

RTM

New Features in SharePoint 2016

https://technet.microsoft.com/en-us/library/mt346121(v=office.16).aspx

SharePoint Server 2016 IT Web Template (preview)
https://blogs.technet.microsoft.com/wbaer/2015/09/07/sharepoint-server-2016-it-preview-web-templates/

SharePoint 2016 List of all Sites / Web Templates
https://gallery.technet.microsoft.com/office/SharePoint-2016-Web-8548823e

SharePoint 2016 List Templates
https://gallery.technet.microsoft.com/office/SharePoint-2016-List-98e46150

SharePoint 2016 Feature Compare
https://gallery.technet.microsoft.com/office/SharePoint-2016-Feature-1746745d

SharePoint 2016 PowerShell List
https://gallery.technet.microsoft.com/office/SharePoint-2016-List-of-7236099e

SharePoint 2016 Deprecated
https://technet.microsoft.com/en-us/library/mt346112(v=office.16).aspx

BI SharePoint 2016
http://whitepages.unlimitedviz.com/2015/12/rethinking-business-intelligence-in-sharepoint-and-sql-server-2016/

Windows 10 Install

http://www.disruptivei.com/Lists/Anslag/Post.aspx?ID=33

May 4th Future of SharePoint Event

https://blogs.office.com/2016/05/04/the-future-of-sharepoint/

https://blogs.office.com/2016/03/14/sharepoint-2016-rtm-and-the-future-of-sharepoint-event/

Breakout Sessions from Launch

Accelerating Innovation with Hybrid: SharePoint Server 2016 and Office 365

https://vts.inxpo.com/scripts/Server.nxp?LASCmd=AI:1;F:SF!42000&EventKey=185893

Effortless File Sharing on Any Device: OneDrive for Business and SharePoint

https://vts.inxpo.com/scripts/Server.nxp?LASCmd=AI:1;F:SF!42000&EventKey=185894

Foundation for the Future: SharePoint Server 2016

https://vts.inxpo.com/scripts/Server.nxp?LASCmd=AI:1;F:SF!42000&EventKey=185892

Open and Connected Platform: The SharePoint Framework

https://vts.inxpo.com/scripts/Server.nxp?LASCmd=AI:1;F:SF!42000&EventKey=185898

Security, Privacy and Compliance for SharePoint and OneDrive for Business      

https://vts.inxpo.com/scripts/Server.nxp?LASCmd=AI:1;F:SF!42000&EventKey=185897

The Mobile and Intelligent Intranet: SharePoint Sites and PowerApps

https://vts.inxpo.com/scripts/Server.nxp?LASCmd=AI:1;F:SF!42000&EventKey=185895

Your Intranet in Your Pocket: The SharePoint mobile app

https://vts.inxpo.com/scripts/Server.nxp?LASCmd=AI:1;F:SF!42000&EventKey=185896

 

SharePoint 2016 User profile Service and MIM

http://social.technet.microsoft.com/wiki/contents/articles/33819.sharepoint-2016-user-profile-service-and-mim-apply-the-connection-filter.aspx

https://docs.com/markus-hintner/5587/what-s-new-in-user-profile-sync-in-sharepoint-2016

https://thesharepointfarm.com/2016/03/automating-mim-user-profile-synchronization-with-sharepoint-2016/

New and Improved Features in 2016

https://msdn.microsoft.com/en-us/library/mt346121(v=office.16).aspx

Durable Links – Bill Baer and Others

Durable links limitations:
OOS is required (Office Online Server)
https://technet.microsoft.com/en-us/library/mt170644(v=exchg.160).aspx
https://technet.microsoft.com/en-us/library/ff431687(v=office.16).aspx
File Types Supported – Word Excel PowerPoint OneNote and PDF
Site Collection based
Unique permission are NOT supported – permissions lost
Site Content and Structure is NOT supported - breaks links

https://blogs.technet.microsoft.com/wbaer/2015/09/22/durable-links-in-sharepoint-server-2016-it-preview/

https://thesharepointfarm.com/2015/08/sharepoint-2016-durable-links/

http://sharepointpaul.blogspot.com/2015/11/office-online-server-and-durable-links.html

http://techtrainingnotes.blogspot.com/2018/01/sharepoint-2016-durable-links.html

SharePoint Server 2016 RTM

https://blogs.office.com/2016/03/14/sharepoint-2016-rtm-and-the-future-of-sharepoint-event/

Project Server 2016

https://msdn.microsoft.com/en-us/library/ff631142(v=office.16).aspx

SharePoint Server 2016 Release Candidate

What's deprecated or removed from SharePoint Server 2016 Beta 2

What's New in SharePoint Server 2016 Beta 2

https://technet.microsoft.com/en-us/library/mt346121(v=office.16).aspx

Microsoft Forum and Blogs

Resource List


First Installation Guides

https://nhutcmos.wordpress.com/2015/08/25/setup-sharepoint-server-2016-step-by-step/
http://blogs.technet.com/b/wbaer/archive/2015/05/12/what-s-new-in-sharepoint-server-2016-installation-and-deployment.aspx
http://blogs.msdn.com/b/how24/archive/2015/08/27/what-s-new-in-sharepoint-2016.aspx

First Look

First screen shot of SharePoint 2016 via Unity Podcast with Bill Baer
File size is no longer limited to 2 GB now 10 GB
image

Features

https://blogs.office.com/2015/04/16/sharepoint-server-2016-update/

Upgrade Challenges

15 mode only site collections – 2013 mode only
OOS

Announcements

SharePoint Online or On-Prem is hyper-focus
Checkout Julia’s WPC Keynote

Advanced Timer Jobs

List of COMMONLY “RUN NOW” Timer Jobs By Category

MMS
Taxonomy Update Scheduler
SharePoint Updates list items when the Managed Metadata changes

Reference
https://technet.microsoft.com/en-us/library/cc678870.aspx

More on Timer Jobs

Create Custom Timer Jobs
http://sharepointpromag.com/sharepoint/understanding-timer-jobs-sharepoint-premises-and-azure-web-jobs-office-365
Missing Custom Timer Jobs
http://alispasset.blogspot.com/2013/11/custom-sharepoint-timer-jobs-are-not.html

Monitor SharePoint Timer Jobs via PowerShell
http://nikcharlebois.com/monitor-sharepoint-timer-job-execution-using-powershell/

More Reading

Article - Taxonomy Update Scheduler Timer Job
https://davidfrette.wordpress.com/2010/05/26/taxonomy-update-scheduler%C2%A0timer%C2%A0job/

Article - Developer View of timer jobs
http://www.simple-talk.com/dotnet/.net-tools/a-complete-guide-to-writing-timer-jobs-in-sharepoint-2010/

http://blogs.msdn.com/b/besidethepoint/archive/2011/11/01/sharepoint-timer-service-config-refresh-and-internal-jobs.aspx 

Great article with repost here:

SharePoint Timer Service: Config Refresh and Internal Jobs

JoshGav

In describing the invocation and execution of timer jobs within SharePoint's Timer Service framework, there are a few possible approaches. We could begin by describing the SPJobDefinition class and its various descendants. Another approach would be to describe how the Timer Service instantiates and invokes the jobs. The approach we'll take is to go through many of the standard SharePoint Timer Jobs, using them as examples of types of jobs and paradigms in job creation.

The Internal Timer Jobs

The first two jobs we encounter on our journey are the two internal timer jobs - the Sweep job and the Lock Refresh job. These jobs are not associated with a service instance or Web Application; they are instead automatically added to the local job collection each time the Timer Service is started. The Sweep job checks for other jobs which failed to acquire a lock when they were run and tries again to acquire a lock for them. The Lock Refresh job updates the time for any locks already acquired by this Timer Service Instance (i.e. server). In the ULS logs, the Sweep job is sometimes referred to as "Internal Timer Job 0," and the Lock Refresh job is known as "Internal Timer Job 1." Attached to this post is the sequence of ULS logs typically created by runs of each of these jobs.
In a healthy farm, administrators will likely never need to concern themselves with these jobs. They do however have several important configurable elements which admins should be aware of. These are set on the farm's Timer Service, which can be retrieved as follows:
PS:> $farm = Get-SPFarm
PS:> $farm.TimerService
Three configurable properties of the Timer Service are SweepSchedule, RefreshLockSchedule, and LockTimeout. By default, the Sweep job runs once every hour; the RefreshLock job runs every 15 minutes; and the Lock Timeout period is 20 minutes. It seems logical that the RefreshLock job be scheduled at least more frequently than the period of the Lock Timeout so that locks are refreshed before they time out. I cannot state definitively whether performance would be effected negatively by setting the Lock Timeout lower.

Default Timer Service Jobs

The following seven jobs are configured by default when a new farm is created. They can be restored by running the EnsureDefaultJobs() method on the SPTimerService object retrieved above, as follows:
PS:> $farm = Get-SPFarm
PS:> $farm.TimerService.EnsureDefaultJobs()


Display Name

Type

Default Schedule
job-config-refresh
SPConfigurationRefreshJobDefinition
every 15 minutes
job-ceip-datacollection
SPSqmTimerJobDefinition
daily between 4:31 and 4:33
job-delete-job-history
SPDeleteJobHistoryJobDefintion
weekly Sunday 5:00
job-password-management
SPPasswordManagementJobDefinition
daily between 0:31 and 0:33
job-admin-product-version
SPProductVersionJobDefinition
daily between 0:51 and 0:53
job-timer-recycle
SPTimerRecycleJobDefinition
daily at 6:00
job-timer-locks
SPDatabaseLocksJobDefinition
every 1 minute

We will discuss the Config Refresh job in this article and the other jobs later.

SPJobDefinition

The Config Refresh job will be our first encounter with SPJobDefinition. Properties of instances of SPJobDefinition represent data used by the Timer Service to execute jobs properly. This data includes the Service or Web Application with which the job is associated, the Server on which the job is designated to run (when applicable), the Lock Type of the job (to be discussed later), the job's Title and Description, and finally the job's schedule. The virtual Execute() method is overridden in derived classes to define the actions the job will take; it is this method that is called when the job is invoked.

The Config Refresh Job

The Config Refresh job is one of the most important of the timer jobs. By monitoring version numbers, it detects when changes have been made to objects in SharePoint's shared object store (in the Configuration Database), and updates file and in-memory object caches on the local server accordingly. In addition, it evaluates these changes for any impact they have on locally scheduled jobs and modifies the store of jobs for the local server. For example, if a service instance on a server is brought online through an update, jobs associated with that service will now be scheduled for execution by the local Timer Service Instance.
The Config Refresh Job is one of two jobs in the farm allowed to run more frequently than once a minute; it runs every 15 seconds by default.
In addition to its own work, during the process of running the Config Refresh job, the server checks itself to see if it is busy (based on HTTP Throttling Settings). If it is, all pausable jobs are paused until the next run of the Config Refresh Job (at which point the server checks to see if it is busy again). Results of this check are written to the ULS log as "The current server busy status is (true/false)." If jobs don't seem to be running on a server, this could be something to check.
We will discuss other jobs going forward.

Tuesday, June 14, 2016

SharePoint Navigation

2013

Limitations to MMS Navigation
https://nikpatel.net/2014/06/09/limitations-of-managed-navigation-in-sharepoint-2013/

Top Navigation Issues using MMS SP2013 fix
http://apppagetopnavigation.blogspot.in/
http://stackoverflow.com/questions/17188301/sharepoint-2013-global-navigation-issue

SharePoint 2013 – Simple MMS Navigation (Technet)
http://social.technet.microsoft.com/wiki/contents/articles/15876.sharepoint-2013-navigation-using-managed-metadata.aspx

Building global navigation in SharePoint 2013 (MVP)
https://blog.mastykarz.nl/building-global-navigation-sharepoint-2013/

Make a global navigation over multiple site collections
http://sharepoint.stackexchange.com/questions/106086/sharepoint-2013-global-navigation-across-site-collections

http://sharepoint.stackexchange.com/questions/77151/best-way-to-make-a-global-navigation-over-multiple-sitecollections

https://sharepointotoole.wordpress.com/2013/05/30/global-navigation-in-sharepoint-2013/

http://blog.sharepointexperience.com/2013/04/working-with-sharepoint-navigation/

 

2010

Current Navigation (quick launch)
You can edit quick lauch easily through the site settings click navigation under Look and Feel

Quick launch is security filtered by default and can be modified by audiences. Quick Launch settings for each link required clicking the link and the click Edit under Navigation Editing and Sorting section.

Great article with more on quick launch http://www.endusersharepoint.com/EUSP2010/2010/05/21/navigating-sharepoint-2010-part-1-introductions/

Global Navigation (top link header)
However top link bar customization requires SharePoint Designer or Visual Studio
http://technet.microsoft.com/en-us/library/ee695757.aspx#Section2a