SharePoint Online - Mapping Masterpage Directory

If the URL is this:
https://COMPANYNAME.sharepoint.com/sites/SITENAME/_catalogs/masterpage/

The networked mapped location is this:
\\COMPANYNAME.sharepoint.com@ssl@443\sites\SITENAME\_catalogs\masterpage

Gotchas:

• Internet Explorer must have the site in the trusted intranet zone. Discuss with network administrator as this may involve editing group policy.
• You must sign into the site with Internet Explorer, and may have to allow IE to remember automatic login.

SharePoint Online - Bootstrap Resources

ShareBoot - http://www.topsharepoint.com/shareboot-responsive-sharepoint-2013-theme#comment-142954

BindTuning - http://www.bindtuning.com/

Responsive SharePoint

• https://responsivesharepoint.codeplex.com/
• http://bastiaanjacobs.nl/2014/01/30/sharepoint-2013-responsive-mpb-bootstrap/ 

Making seattle.master responsive - http://blog.sharepointexperience.com/2015/03/making-seattle-master-responsive/

Avoid CSS Ricochet-
https://melcher.it/2016/03/bootstrap-sharepoint-online-avoid-css-ricochet/

SharePoint Online - Promoted Links Nuances

1. By default it will create a very limited view of the tiles that only spans horizontally. It will be limited to a maximum of 30 items. You also can not modify this view. To get around this maximum item limitation create a NEW standard view. Modify the new view to meet your needs.
   
2. The tiles will only scroll horizontally. A simple fix for this is to add the following CSS to a custom page via a script webpart. This will target the promoted links webpart by hiding the arrow navigation and forcing the tiles to be a bit more responsive.
   
   .ms-promlink-header{
   display:none;
   }
   .ms-promlink-body {
   width: 100%;
   }
   

Exploring WMI

Free tools for exploring the Windows Management Instrumentation (WMI). Free registration is required. They also have many free e-book and script examples.
http://www.sapien.com/downloads

File Encryption Software

https://www.boxcryptor.com/en/download
http://blog.cloudfogger.com/
http://veracrypt.codeplex.com/
http://www.axantum.com/AxCrypt/

Office 365 & Power BI

Very compelling reasons to use Office 365 and Power BI.
http://channel9.msdn.com/Shows/Cloud+Cover/Episode-168-The-Redesigned-Power-BI-Service-with-Josh-Caplan
https://msdn.microsoft.com/powerbi/
http://docs.powerbi.apiary.io/#

Cloud Drive Software Solutions

http://www.cloudberrylab.com/
https://mover.io/
https://www.syncovery.com
https://www.boxcryptor.com/en/boxcryptor
http://www.webdrive.com/products/webdrive/
http://www.skysync.com/default.aspx
http://www.netdrive.net/   (cryptowall could infect mapped drives?)
http://www.expandrive.com/   (cryptowall could infect mapped drives?)
http://www.aubrett.com/InformationTechnology/CloudServices/MapGoogleDrive.aspx
http://hydra.geht.net/tino/english/opinion/alternatives/expandrive/
https://www.jumptuit.com/
http://wappwolf.com/dropboxautomator
https://www.zeropc.com/
https://www.cloudhq.net/amazon_cloud_drive
https://www.odrive.com/

Windows 2012 Server - Speed Up Internet Connection

Run in elevated command prompt:

netsh interface tcp set global ecncapability=disabled
netsh interface tcp set global congestionprovider=none

http://forums.elderscrollsonline.com/discussion/97277/enable-ctcp-and-ecn-in-windows-may-reduce-latency-in-some-online-applications


Window 2012/8+ Commands
This command will error out. "netsh interface tcp set global congestionprovider=none"
The congestionprovider parameter can be set using the 'netsh int tcp set supplemental' command. The parameter is incorrect.



Try these...
set supplemental congestionprovider=none
netsh int tcp show global

Javascript Frameworks

• AngularJS
• EmberJS
• KnockoutJS
• NodeJS

SharePoint 2010 - Search Sevice Application Problems (Event IDs: 6482, 6398, 2159)

SharePoint really has a mind of it's own. For whatever reason one day all of the search service applications stopped working. I found several articles that stated that all of the search service application  objects needed to be deleted and rebuilt. Other article indicating that the indexes needed to be cleared out. Finally, I found this one line powershell gem that fixed my issue of event IDs: 6482, 6398, 2159. Voila...all the event errors stopped.


Get-SPEnterpriseSearchServiceInstance -Local | Start-SPEnterpriseSearchServiceInstance

http://social.msdn.microsoft.com/Forums/en-US/3e24eaae-86a3-4f6c-89de-1dc38f3a55f5/the-search-application-guid-on-server-servername-did-not-finish-loading?forum=sharepointsearchprevious

SharePoint 2010 - Change Column Types

Sometimes InfoPath doesn't promote fields they way you would like to the SharePoint list. For instance, currency is promoted to a list as a decimal, or a decimal is promoted as an integer. Powershell to the rescue!

Output all of the list columns
$w = Get-SPWeb "https://site";   
$l = $w.GetList("https://site/listname/");
$l.Fields | sort StaticName,Type | ?{$_.CanBeDeleted -eq $true -and $_.Hidden -eq $false} | FT Title,StaticName,Type;

Change Column Type
$w = Get-SPWeb "https://site";   
$l = $w.GetList("https://site/listname/"); 
$column = $l.Fields["Amount Due"];
#$column.AllowDeletion = $false;
#$column.Sealed = $true;
$column.Type = "Number";
$column.Update($true);
$web.Dispose();

SharePoint - List Filtering on Dates

This is an excellent article that describes how to connect date field web parts to a custom list, to perform range filtering.
http://www.bjw.co.nz/developer/sharepoint-2010/101-list-filtering-by-date-range

SQL Server 2012 - Best Practice Analyzer

The following are required for using SQL Server 2012 Best Practices Analyzer:

• PowerShell V2.0   (Powershell 4.0 is out now)
• Microsoft Baseline Configuration Analyzer V2.0

http://www.microsoft.com/en-us/download/details.aspx?id=29302
http://www.microsoft.com/en-us/download/details.aspx?id=16475

Source: http://www.mssqltips.com/sqlservertip/2712/using-the-microsoft-sql-server-2012-best-practice-analyzer/

SQL Server 2012 - SSIS Execution Permissions

I ran into an issue where even the server administrator and sql server services accounts would not properly execute SSIS packages. I had to perform the following steps so the service account could execute a sql agent job and run a package.

Run Dcomcnfg.exe. Dcomcnfg.exe provides a user interface for modifying certain settings in the registry. In the Component Services dialog, expand the Component Services > Computers > My Computer > DCOM Config node. Right-click Microsoft SQL Server Integration Services 11.0, and then click Properties. On the Security tab, click Edit in the Launch and Activation Permissions area. Add users and assign appropriate permissions, and then click Ok. Repeat steps 4 - 5 for Access Permissions. Restart SQL Server Management Studio. Restart the Integration Services Service. (Source MSDN)

http://stackoverflow.com/questions/13941998/sql-server-2012-integration-services-failed-when-connecting-thru-ssms

SharePoint & Antivirus

Folders to consider for exclusion in antivirus programs:

C:\Program Files\Microsoft Office Servers\14.0\Logs
C:\Program Files\Microsoft Office Servers\
C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\LOGS
C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\

C:\Program Files\Microsoft SQL Server
C:\Program Files (x86)\Microsoft SQL Server

Sources:

• http://support.microsoft.com/kb/952167
• http://social.technet.microsoft.com/wiki/contents/articles/953.microsoft-anti-virus-exclusion-list.aspx
• http://support.microsoft.com/kb/309422

SharePoint 2010 - Enabling the Developer Dashboard

Enabling via powershell:

$contentService = [Microsoft.SharePoint.Administration.SPWebService]::ContentService
$dashboardSetting = $contentService.DeveloperDashboardSettings
$dashboardSetting.DisplayLevel = [Microsoft.SharePoint.Administration.SPDeveloperDashboardLevel]::On
$dashboardSetting.Update()

http://msdn.microsoft.com/en-us/library/office/gg512103(v=office.14).aspx
http://msdn.microsoft.com/en-us/library/office/ff512745(v=office.14).aspx

Free IT eBooks

All Categories

• http://www.it-ebooks.info

Microsoft

• http://blogs.msdn.com/b/mssmallbiz/archive/2015/07/07/i-m-giving-away-millions-of-free-microsoft-ebooks-again-including-windows-10-windows-8-1-windows-8-windows-7-office-2013-office-365-sharepoint-2013-dynamics-crm-powershell-exchange-server-lync-2013-system-center-azure-clo.aspx

• http://social.technet.microsoft.com/wiki/contents/articles/11608.e-book-gallery-for-microsoft-technologies.aspx
  
• http://it-ebooks.info/publisher/8/
  
• http://blogs.msdn.com/b/mssmallbiz/archive/2013/06/28/almost-150-free-microsoft-ebooks-covering-windows-7-windows-8-office-2010-office-2013-office-365-office-web-apps-windows-server-2012-windows-phone-7-windows-phone-8-sql-server-2008-sql-server-2012-sharepoint-server-2010-s.aspx

SharePoint 2010 - Formulas

Some resources for SharePoint formulas:

• http://office.microsoft.com/en-us/windows-sharepoint-services-help/CH001171117.aspx
• http://office.microsoft.com/en-us/support/results.aspx?ctags=CH010372694
• http://office.microsoft.com/en-us/windows-sharepoint-services-help/examples-of-common-formulas-HA001160947.aspx

 Cheat Sheet I found:

Powershell - File Renaming

Here is a quick powershell script to tidy files that are not properly formatted for the web.

Get-ChildItem C:\Temp\rename\* -Recurse | Rename-Item -NewName {$_.name -creplace '[^A-Za-z1234567890.]','_' }
Get-ChildItem C:\Temp\rename\* -Recurse | Rename-Item -NewName {$_.name -replace '___','_' }
Get-ChildItem C:\Temp\rename\* -Recurse | Rename-Item -NewName {$_.name -replace '__','_' }

SharePoint 2010 - InfoPath - Web Browser Settings

There is a glitch in the form rendering processes. Even with all the apparent settings set correctly in Central Admin and in the Form Library itself, the form still tries to open in the client filler application. There are some workarounds.

1. Add this query parameter to the URL string. (Documentation)
   https://intranet.mysite.org/FormLibrary/Forms/template.xsn?OpenIn=Browser
   
2. Using powershell to force the settings on the library:
      http://technet.microsoft.com/en-us/library/ff805082(v=office.14).aspx
      Set-SPInfoPathFormsService -AllowUserFormBrowserRendering $true

The actual fix for me was to just do a full publish of the form again. For whatever reason the "Quick Publish" did not correct the issue.