InfoPath 2013 - Project location for Visual Basic and C# code

Does not seem to stick for me today:
File > Advanced form options: Form Options (large square button) > Programming > Project location for Visual Basic and C# code:

Use this instead:
File > Options (left nav) > General > 'More Options' button > 'Design' tab > Project location for Visual Basic and C# code:

Failed to connect to the existing server farm

Verify that the SQL Alias matches Central Administration > System Settings > Manage servers in this farm > Microsoft SharePoint Foundation Database:

Start > Run > cliconfg.exe > 'Alias' tab > 'Add...' button > 'TCP/IP' radio button > Server name: SAMPLESERVERNAME\SAMPLEINSTANCENAME > Server alias: SAMPLEALIAS > OK.

SP2013 - web.config debug settings

inetpub\wwwroot\wss\VirtualDirectories\80\web.config
15\TEMPLATE\LAYOUTS\web.config
15\CONFIG\web.config
15\TEMPLATE\ADMIN\web.config

<configuration>
  <SharePoint>
    <SafeMode CallStack="true" />
  </SharePoint>
  <system.web>
    <customErrors mode="Off" />
    <compilation debug="true" />
  </system.web>
</configuration>

PowerShell - Find Content Type in Use

$siteURL = http://sample/
$contentType = "Sample"
$web = Get-SPWeb $siteURL
$ct = $web.ContentTypes[$contentType]
if ($ct) {
$ctusage = [Microsoft.SharePoint.SPContentTypeUsage]::GetUsages($ct)
      foreach ($ctuse in $ctusage) {
        $list = $web.GetList($ctuse.Url)
        $contentTypeCollection = $list.ContentTypes;
        #$contentTypeCollection.Delete($contentTypeCollection[$ContentType].Id);
        Write-host "(Would have) Deleted -" $contentType "- content type from -" $ctuse.Url "-"
        }
#$ct.Delete()
Write-host "(Would have) Deleted -" $contentType "- from site."
} else { Write-host "Nothing to delete." }
$web.Dispose()


Reference:
http://stackoverflow.com/questions/6427315/unable-to-delete-sharepoint-2010-contenttype-contenty-type-in-use

PowerShell - Merge-SPLogFile

$logPath = "C:\MergedULSLogs\log.txt"
$startTime = "02/23/2015 07:50"
$endTime = "02/23/2015 07:59"
$correlationID = "a9afa74b-119f-46bf-aea8-ec2d886ee490"

Merge-SPLogFile -Path $logPath -Overwrite -StartTime $startTime -EndTime $endTime -Correlation $correlationID

Then open the log.txt file with ULS Viewer.

PowerShell - Delete Duplicate Quick Launch Nodes

Scenario:

• Site slow to load, resulting in an exception with a correlation ID
• ULS log error: PortalSiteMapProvider was unable to fetch children for node at URL
• Temporarily hide the quick launch so users can navigate to the site: SharePoint Designer 2010 > http://samplesite > Left Nav > 'Sample Site Name' > uncheck 'Display Quick Launch' > Save.
• Find the offending Quick Launch node by running the following SQL query against the content database. You should see many, many repeating entries: SELECT * FROM NavNodes
• Delete the repeats from the Quick Launch via PowerShell:
  
  $FindString = “Offending Sample Title”
  $web = get-spweb ("http://samplesite/")

  for ($i = $web.Navigation.QuickLaunch.Count-1; $i -ge 0; $i--)
  {
  write-host $web.Navigation.QuickLaunch[$i].Title "heading deleting...... "
  $web.Navigation.QuickLaunch[$i].Delete()
  write-host "heading deleted successfully !!!."
  }
• Display the quick launch again.

Resources:

• https://social.msdn.microsoft.com/Forums/en-US/258f05c7-23cd-4a37-b227-85d55c558575/powershell-command-to-delete-all-navigation-links-from-quick-launch-in-sp-2010?forum=sharepointdevelopmentprevious

PowerShell - No Ellipses

No Ellipses:

| Format-Table -AutoSize

Excel 2013 - Freeze Top Row and First Column

Click B2 > Ribbon > View tab > Freeze Panes

PowerShell - SharePoint Database Size Report

$SMTPServer = "" 
$emailFrom = "" 
$emailTo = "" 
$subject = "Sharepoint DB Size Report"

$total = ""
$each = Get-SPDatabase | Sort-Object disksizerequired -desc | ForEach-Object {$db=0} {$db +=$_.disksizerequired; $_.name + " - " + ("{0:n0}" -f ($_.disksizerequired/1024/1024)) + "`t"} {$total = "`nTotal Storage (in MB) =" + ("{0:n0}" -f ($db/1024/1024))}
$each = Out-String -InputObject $each
$total = Out-String -InputObject $total

$emailBody = "SharePoint DB - Size in MB" + "`n" + "`n" + $each + $total

Send-MailMessage -SmtpServer $SMTPServer -From $emailFrom -To $emailTo -Subject $subject -Body $emailBody


Resources:
http://www.toddklindt.com/blog/Lists/Posts/Post.aspx?ID=193