SharePoint By Gaurav Goyal

Create css file "LeftNavStyle.css" & upload in Style Library with below mentioned contents : /* To Set minum Height of the page */ .s4-ca{  min-height:500px !important; } /* Remove Top Space From Left Navigation */ .ms-quickLaunch  { padding-top:5px !important; } /* For Footer */ .custom-footer { clear:both; text-align: center; padding: 10px; background-color: #FCFCFC; border: 1px solid #DBDDDE; } /* Left Navigation Heading */ .s4-ql ul.root > li > .menu-item, .s4-qlheader, .s4-qlheader:visited {         border-bottom:1px solid #B8BABD !important;     border-top: 1px solid #E0E0E0 !important;     font-size: 1.2em;     margin: 0;     overflow-x: hidden;     padding: 3px 4px 3px 10px;     word-wrap: break-word;  background:  url('../SiteAssets/01-03.png') repeat-x;  /*background-color:#005B96 !important;*/  color:#fff; } /* Left Navigation item Hover */ .s4-ql ul.root ul > li > a:hover{  color: #005B96 !important;  backg

I have created a web application in SharePoint & also set the “Alternate Access Mapping” for the web application like: Zone URL Host Header in IIS Default http://sharepoint2010 sharepoint2010 Intranet http://sharepoint2010.mydomain.com sharepoint2010.mydomain.com Internet http://www.mysharepoint2010.com www.mysharepoint2010.com Custom Extranet When I login to http://www.mysharepoint2010.com , it allow me to login. But just after this login, I won’t be able to use my default url ( http://sharepoint2010 ). It prompts me for credentials so many times & won’t allow me to login to the url http://sharepoint2010 . When I reset my iis then it allow me to login to http://sharepoint2010 . But when again I login to http://www.mysharepoint2010.com and then again I want to use url http://sharepoint2010 . It won’t allow me to use this url. I have done some R & D and found that SharePoint uses Session-Based-A

Add-PSSnapin Microsoft.SharePoint.Powershell -ErrorAction SilentlyContinue $SolutionPackageName = "MySolution.wsp" $SolutionPackagePath = "C:\PowershellSetup\MySolution.wsp" Write-Host "Checking Solution exist or not..." -foregroundcolor Yellow $solution = Get-SPSolution | where-object {$_.Name -eq $SolutionPackageName} if($solution -ne $null) { Write-Host "Solution Found & Updating Solution..." -foregroundcolor Green Update-SPSolution -Identity $SolutionPackageName -LiteralPath $SolutionPackagePath -Local -GACDeployment -Force Write-Host "Solution Updated..." -foregroundcolor Yellow } Write-Host "Solution Updation Complete." -foregroundcolor Green

Add-PSSnapin Microsoft.SharePoint.Powershell -ErrorAction SilentlyContinue $SolutionPackageName = "MySolution.wsp" $SolutionPackagePath = "C:\PowershellSetup\MySolution.wsp" Write-Host "Checking Solution exist or not..." -foregroundcolor Yellow $solution = Get-SPSolution | where-object {$_.Name -eq $SolutionPackageName} if($solution -ne $null) { Write-Host "Solution Found..." -foregroundcolor Green if($solution.Deployed -eq $true) { Write-Host "Uninstalling Solution..." -foregroundcolor red Uninstall-SPSolution -Identity $SolutionPackageName -Local -Confirm:$false Write-Host "Uninstallation Done..." -foregroundcolor Yellow } Write-Host "Removing Solution..." -foregroundcolor red Remove-SPSolution -Identity $SolutionPackageName -Confirm:$false Write-Host "Solution Removed..." -foregroundcolor Yellow } Write-Host "Adding Solution..." -foregroundcolor red Add-SPSolution -LiteralPath $Sol

Add-PSSnapin Microsoft.SharePoint.Powershell -ErrorAction SilentlyContinue $SolutionPackageName = "MySolution.wsp" $SolutionPackagePath = "C:\PowershellSetup\MySolution.wsp" Write-Host "Checking Solution exist or not..." -foregroundcolor Yellow $solution = Get-SPSolution | where-object {$_.Name -eq $SolutionPackageName} if($solution -ne $null) { Write-Host "Solution Found..." -foregroundcolor Green if($solution.Deployed -eq $true) { Write-Host "Uninstalling Solution..." -foregroundcolor red Uninstall-SPSolution -Identity $SolutionPackageName -Local -Confirm:$false Write-Host "Uninstallation Done..." -foregroundcolor Yellow } Write-Host "Removing Solution..." -foregroundcolor red Remove-SPSolution -Identity $SolutionPackageName -Confirm:$false Write-Host "Solution Removed..." -foregroundcolor Yellow } Write-Host "Adding Solution..." -foregroundcolor red Add-SPSol

I found best video tutorial & blog which describe how to install & configure SQL Server 2012 for SharePoint 2013. Here you can find : Set Up SQL Server 2012 as a SharePoint 2013 Database Server Configure SQL Server 2012 for SharePoint 2013 Fine-Tune Your SQL Server 2012 Configuration for SharePoint 2013

This is an example how we can update a web part programmatically in multiple sites. LiteralControl lit = new LiteralControl(); lit.Text = ""; try { using (SPSite site = new SPSite(SPContext.Current.Web.Site.RootWeb.Url)) { for (int i = 1; i < site.AllWebs.Count; i++) { lit.Text += "<BR/>" + site.AllWebs[i].Title; SPFile file=site.AllWebs[i].GetFile(site.AllWebs[i].ServerRelativeUrl + "/default.aspx"); if ( file.Exists) { using (Microsoft.SharePoint.WebPartPages.SPLimitedWebPartManager wpm = site.AllWebs[i].GetLimitedWebPartManager(file.Url, PersonalizationScope.Shared)) { foreach (WebPart wp in wpm.WebParts) { if (wp.Title == "Notes") { wp.Height = new Unit("200px"); wpm.SaveChanges(wp); break; } } } } } } } catch (Exception ex) { lit.Text += "<BR/>" + ex.ToString(); } this.Controls.Add(lit);

Here I found some good examples which shows how to use html & javascripts in calculated columns like if you want to show progress bar in task list based on percent completed or change color of font based on certain condition or put any symbol or highlight row based on any condition. Please check below given links for the same : http://sharepointwijzer.nl/sharepoint-blog/tech/icc-html-calculated-column-sharepoint-view/ http://www.pentalogic.net/sharepoint-products/free-stuff/html-calculated-column/hcc-example-uses

SharePoint Validation Controls You must check this blog for validation related controls. http://karinebosch.wordpress.com/sharepoint-controls/sharepoint-validation-controls/ http://fychan.blogspot.in/2009/12/sharepoint-validation-controls.html

PowerPivot Installation & Configuration links : http://technet.microsoft.com/en-us/library/ee210627(v=sql.105).aspx http://technet.microsoft.com/en-us/library/ee210616(v=sql.105).aspx http://www.bybugday.com/Lists/Posts/Post.aspx?ID=63 http://blogs.office.com/b/microsoft-excel/archive/2009/11/11/excel-services-in-sharepoint-2010-dashboard-improvements.aspx http://technet.microsoft.com/en-us/library/ee210685(v=sql.105).aspx http://technet.microsoft.com/en-us/library/ee210608(v=sql.105).aspx http://technet.microsoft.com/en-us/library/ee210611(v=sql.105).aspx http://technet.microsoft.com/en-us/library/ee210660(v=sql.105).aspx http://www.brainlitter.com/2010/09/05/the-given-key-was-not-present-in-the-dictionarysharepoint-2010-error/ http://social.msdn.microsoft.com/Forums/sqlserver/en-US/4e6287f7-451b-4eec-9bef-52112587ff20/the-data-connection-uses-windows-authentication-and-user-credentials-could-not-be-delegated-the?forum=sqlkjpowerpointforsharepoint http://dennyglee.com