Cool PowerShell for SharePoint – Start Here

Central point for PowerShell and SharePoint
Reference guide of PowerShell on the web

PowerShell 101

Basic
http://powershell101.blogspot.com/2012/09/sharepoint-powershell.html

Add Online Modules
http://sharepoint-tricks.com/install-update-uninstall-cmdlets-for-sharepoint-online

LinkedIn Articles

General Scripts: (Retrieve List and Email) untested
https://www.linkedin.com/in/sachchin-annam-21517031/detail/recent-activity/posts/

Office 365

Exchange PS1
https://blogs.technet.microsoft.com/exchange/2016/10/06/tip-a-few-useful-powershell-scripts-for-exchange-and-office-365-admins/
Using PowerShell to Specify License Plans in Office 365
http://www.toddklindt.com/blog/Lists/Posts/Post.aspx?ID=664
Multi Tenant
http://www.luisevalencia.com/2019/02/28/leveraging-office-pnp-core-to-run-multi-tenant-specific-operations

2016

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

DisableLoopBackCheck when routing through a Load Balancer

(PowerShell sample included) NOTE the tick is in the upper left corner of the keyboard, note the single quote used in `r`n for carriage return line feed and use iisreset to complete.

https://blogs.technet.microsoft.com/scottstewart/2014/09/15/disableloopbackcheck-when-routing-through-a-load-balancer-powershell-sample-included/

2013

How-to Enable Protocols on SQL Server with PowerShell https://technet.microsoft.com/en-us/library/dd206997(v=sql.105).aspx

SQL Alias PowerShell script https://blogs.technet.microsoft.com/sqlpfeil/2014/03/31/sql-alias-powershell-script/

Limit SharePoint Site Templates
http://briantjackett.com/2014/03/04/powershell-script-to-limit-sharepoint-site-templates-available/

SharePoint PowerShell Script Series Part 4–Gathering item count for all document libraries in a Site Collection
https://blogs.msdn.microsoft.com/russmax/2012/01/20/sharepoint-powershell-script-series-part-4gathering-item-count-for-all-document-libraries-in-a-site-collection/

Cool site with a ton of scripts
https://github.com/sharepoint

Alternate to Warm Up Scripts

http://thesharepointfarm.com/2012/06/sharepoint-warm-up-scripts-a-thing-of-the-past/

PowerShell Tips
http://secretsofsharepoint.com/cs/
http://powershell101.blogspot.com/search/label/tips

Service Application PowerShell
Search

http://blogs.technet.com/b/praveenh/archive/2013/02/07/create-a-new-search-service-application-in-sharepoint-2013-using-powershell.aspx

Copy lists in PowerShell (thx Todd)
http://www.sharepointdiary.com/2012/12/copy-list-between-sites-powershell.html
http://sharepointpsscripts.codeplex.com/releases/view/21696 Bulk Import

Tools

https://spuploader.codeplex.com/
http://spbulkdocumentimport.codeplex.com/
https://difs.codeplex.com/
http://docuploadmetadata.codeplex.com/
http://get-spscripts.com/2010/10/bulk-upload-files-with-metadata-into.html

2010

Configure a service application by using a Windows PowerShell script (SharePoint Server 2010)
https://technet.microsoft.com/en-us/library/gg983005(v=office.14).aspx

Change Page Layout On Publishing Sites.
https://myspworld.wordpress.com/2012/08/16/powershell-script-to-change-the-page-layout/
Issues
PowerShell 3.0 Issues http://support.microsoft.com/kb/2796733
PowerShell Builder - SharePoint
http://www.microsoft.com/resources/TechNet/en-us/Office/media/WindowsPowerShell/WindowsPowerShellCommandBuilder.html

Untested but look good
Warm-up Scripts
http://gallery.technet.microsoft.com/office/SharePoint-2007-2010-or-d1884b4b
Copy an entire document library from SharePoint to Disk
http://sharepointkunskap.wordpress.com/2012/12/11/powershell-copy-an-entire-document-library-from-sharepoint-2007-to-disk/
Upload File to SharePoint Library using PowerShell
http://www.sharepointdiary.com/2012/07/upload-file-to-sharepoint-library-using.html
http://get-spscripts.com/2010/10/bulk-upload-files-with-metadata-into.html
Move Content Types
http://get-spscripts.com/2011/02/export-and-importcreate-site-content.html
Duplicate Documents
http://blog.pointbeyond.com/2011/08/24/finding-duplicate-documents-in-sharepoint-using-powershell/
https://www.nothingbutsharepoint.com/sites/devwiki/articles/pages/finding-duplicate-documents-in-sharepoint-2010.aspx
Export Reports from SharePoint Reports
http://social.technet.microsoft.com/Forums/sharepoint/en-US/dc719361-50bc-40ba-bd6b-5035c5a876ca/export-report-from-sharepoint-over-powershell

Jquery and JavaScript for SharePoint Admins

Cool Tips

Change List New Item to …

https://sharepoint.stackexchange.com/questions/193726/sharepoint-2013-designer-changing-text-of-new-item-for-custom-list

Code

<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.1.0/jquery.min.js"></script>

<script> $(document).ready(function(){ var spans = document.getElementsByTagName("span");

for(var i=0;i<spans.length; i++) {
if(spans[i].innerHTML == "new item") {
spans[i].innerHTML = "new person";
break;
}
}
});
</script>

SharePoint List Type Column to show icon based on file type attached

https://social.technet.microsoft.com/wiki/contents/articles/30896.sharepoint-list-type-column-to-show-icon-based-on-file-type-attached.aspx

Code:

<script type="text/javascript" src="{reference to jquery library}">​
</script>
<script type="text/javascript">
$(document).ready(function(){
$('.ms-listviewtable > tbody > tr').each(function () {
var docTypeIcon = getDocTypeImage($(this).find("td:nth-child(<column count*>)").text());
//alert(docTypeIcon);
$(this).find("td:nth-child(<column count*>)").find("img").attr("src",docTypeIcon);
});

function getDocTypeImage(x)
{
var imageUrl = '';
switch(x)
{
case 'pdf' : imageUrl = "/_layouts/images/pdficon_small.gif";
break;
case 'pptx' : imageUrl = "/_layouts/images/icpptx.png";
break;
case 'ppt' : imageUrl = "/_layouts/images/icppt.png";
break;
case 'docx' : imageUrl = "/_layouts/images/icdocx.png";
break;
case 'doc' : imageUrl = "/_layouts/images/icdoc.png";
break;
case 'xlsx' : imageUrl = "/_layouts/images/icxlsx.png";
break;
case 'xls' : imageUrl = "/_layouts/images/icxls.png";
break;
case 'zip' : imageUrl = "/_layouts/images/iczip.gif";
break;
default: imageUrl = "/_layouts/images/icgen.gif";
break;
}
return imageUrl;
}
});
</script>

Reference

https://drboolean.gitbooks.io/mostly-adequate-guide/content/

SharePoint Career– V.Next

SharePoint .next is coming …

More to come

SharePoint 2016

Looking forward to a technical career with SharePoint? 

SharePoint technical careers fall typically along two major careers paths of an administration or development, but many do both roles. SharePoint administrators typically start out as a site, site collection administrator or server administrator and grow into a SharePoint farm administrator role.  Developers typically start either as a ASP.NET developer or SharePoint designer and then grow into a SharePoint developer role.  SharePoint architects and BI experts are worth noting since they have mastered SharePoint administrator, BI and developer skills.

Here are a list of career paths and the corresponding training paths.

Administration
SharePoint Site Collection Administrator
SharePoint Farm Administrator

Development
SharePoint Site Designer or SharePoint UX Designer
SharePoint Developer

Business Intelligence – BI
SharePoint Site Collection Administrator
SharePoint Farm Administrator
SharePoint Site Designer or SharePoint UX Designer
SharePoint Developer
SharePoint BI

SharePoint Architect
SharePoint Administration and Developer

SharePoint Site Collection Administrator

Basic SharePoint and Site Administration Skills
55033 – SharePoint 2013 Site Collection and Site Administration

Technical SharePoint Administrator
MCSE: Productivity
MCSE: SharePoint (Retired March 31 2017)

O365, On-premises, Azure Administrators

CompTIA A+ or equivalent knowledge
CompTIA Network+ or equivalent knowledge
CompTIA Server+ or equivalent knowledge

CompTIA Security+ or equivalent knowledge

PowerShell
10961 – Automating Administration with PowerShell 3.0

MCSA: Windows Server 2012
20410 – Installing and Configuring Windows Server 2012
20411 – Administering Windows Server 2012
20412 – Configuring Advanced Windows Server 2012 Services

SQL Administration
20461/10774 – Querying Microsoft SQL Server 2012
20462/10775 – Administering Microsoft SQL Server 2012 Databases
20463/10777 – Implementing a Data Warehouse with Microsoft SQL Server 2012

Office 365 - Needed for Hybrid Solutions Only
20346B - Managing Office 365 Identities and Services

Basic SharePoint and Site Administration Skills
55033 – SharePoint 2013 Site Collection and Site Administration

SharePoint 2013 Administrator (Farm)
20331 - Core Solutions of Microsoft SharePoint Server 2013
20332 - Advanced Solutions of Microsoft SharePoint Server 2013

SharePoint 2016 Administrator (Farm)
20339-1 - Planning and Administering Microsoft SharePoint Server 2016
20339-2 – Advanced Technologies of Microsoft SharePoint Server 2016
 

SharePoint Site/UX Designer

Basic SharePoint and Site Administration Skills
55033 – SharePoint 2013 Site Collection and Site Administration

HTML and CSS
Web Design with HTML5 and CSS3 - Level 1 (1 Day)
Web Design with HTML5 and CSS3 - Level 2 (1 Day)

SharePoint Designer
Microsoft SharePoint Designer 2013 (1 Day)

SharePoint Developer

MCSA: Web Applications
MCSD: App Builder
MCSD SharePoint Applications (Retired March 31 2017)

https://www.microsoft.com/en-us/learning/mcsd-sharepoint-apps-certification.aspx

https://dev.office.com/sharepoint/about

The developer track is a highly debated track but here is my advice as an administrator.  Reference

HTML5 JavaScript and CSS
20480 - Programming in HTML5 with JavaScript and CSS3

ASP.NET Programming
20486 - Developing ASP.NET MVC Web Applications

Basic SharePoint and Site Administration Skills
55033 – SharePoint 2013 Site Collection and Site Administration

SharePoint 2013 Developer
20488 - Developing Microsoft SharePoint Server 2013 Core Solutions
20489 - Developing Microsoft SharePoint Server 2013 Advanced Solutions

Back End SharePoint Developer – Farm Skills Added
MCSD SharePoint

CompTIA A+ or equivalent knowledge
CompTIA Network+ or equivalent knowledge
CompTIA Server+ or equivalent knowledge
CompTIA Security+ or equivalent knowledge

PowerShell
10961 – Automating Administration with PowerShell 3.0

MCSA: Windows Server 2012
20410 – Installing and Configuring Windows Server 2012
20411 – Administering Windows Server 2012
20412 – Configuring Advanced Windows Server 2012 Services

SQL Administration
20461/10774 – Querying Microsoft SQL Server 2012
20462/10775 – Administering Microsoft SQL Server 2012 Databases
20463/10777 – Implementing a Data Warehouse with Microsoft SQL Server 2012

Office 365 - Needed for Hybrid Solutions Only
20346B - Managing Office 365 Identities and Services

Basic SharePoint and Site Administration Skills
55033 – SharePoint 2013 Site Collection and Site Administration

SharePoint Administrator (Farm)
20331 - Core Solutions of Microsoft SharePoint Server 2013
20332 - Advanced Solutions of Microsoft SharePoint Server 2013

HTML5 JavaScript and CSS
20480 - Programming in HTML5 with JavaScript and CSS3

ASP.NET Programming
20486 - Developing ASP.NET MVC Web Applications

SharePoint 2013 Developer
20488 - Developing Microsoft SharePoint Server 2013 Core Solutions
20489 - Developing Microsoft SharePoint Server 2013 Advanced Solutions

Business Intelligence
MCSE Business Intelligence

20461C:(5 day) Querying Microsoft SQL Server 2014
20462C: (5 day) Administering Microsoft SQL Server Databases
20463C: (5 day) Implementing a Data Warehouse with Microsoft SQL Server
20466C: (5 day) Implementing Data Models and Reports with Microsoft SQL Server – Intro BI - Performance Point – SSRS
20467C: (5 day) Designing Business Intelligence Solutions with Microsoft SQL Server 2012

SharePoint 2013 Admin

Shredded Storage – TechNet – Official from Bill Baer
http://blogs.technet.com/b/wbaer/archive/2012/11/12/introduction-to-shredded-storage-in-sharepoint-2013.aspx
Shredded Storage Overview
http://www.learningsharepoint.com/2012/12/14/sharepoint-2013-shredded-storage-how-it-works/
Using Copy-SPSite to rename Site Collections in SharePoint 2013
http://www.toddklindt.com/blog/Lists/Posts/Post.aspx?ID=372
Document your farm using PowerShell
http://technet.microsoft.com/en-us/library/ff645391.aspx
Licensing
http://www.degdigital.com/blog/big-changes-in-sharepoint-2013-licensing-for-portal-clients/
Host Named Site Collections
http://social.technet.microsoft.com/Forums/en-US/sharepointadmin/thread/b5323367-a06a-4747-b1cb-3139dad6457b

Manage SharePoint using Microsoft Management Console

So you love the mmc, here is a neat trick to add Central Administration SharePoint to your MMC.  First note the URL you need to add to the MMC.  In this case adding the url for central administration, just copy the URL for later use.

Start your MMC by typing mmc in Search programs and files textbox

Select File > Add\Remove Snap-in

Select Link to Web Address > Add

Type your URL or paste if copied earlier > Next

Give it a friendly name > Finish

Select OK after adding all the snap-ins

Select your new link and congrats

Great Article on 10 Admin Gotchas

Check out this great article on 10 Admin Gotchas.  Also great links to other blogs and articles to help support these topics, so make sure to check those out as well.

https://www.nothingbutsharepoint.com/sites/itpro/Pages/Top-10-mistakes-made-by-SharePoint-2010-administrators.aspx

1. Not having "SharePoint" in your job title.

2. Creating too many Web applications.

3. Making changes in IIS manually.

4. Failing to use the SharePoint solutions framework.

5. Inadvertently installing a standalone server.

6. Using the default SQL DB growth settings.

7. Failing to document the farm configuration.

8. Manually changing SharePoint databases to "fix" things.

9. Believing that PowerShell is only for developers.

10. Disregarding SharePoint capacity planning recommendations.

More links
http://www.sqlskills.com/blogs/paul/