SharePoint By Gaurav Goyal

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

Here is good solution for the same error :  http://support.microsoft.com/kb/2361559

Download SharePoint 2013 Branding and User Interface Design ook Description If you are planning, designing, and launching your brand using SharePoint, this book and author trio will walk you through everything you need to know in an understandable and approachable way. From specific technologies such as master pages, page layouts, and  CSS  to offering best-practices and real-world experience for creating successful branding projects through  SharePoint  2013, you will learn how to approach your branding  project  in effective new ways. This visual book provides step-by-step instructions in a simple and striking format that focuses on each of the tasks you will face in your own branding project. Book Details Publisher: Wrox By: Randy Drisgill ,  John Ross ,  Paul Stubbs ISBN: 978-1-118-49567-4 Year: 2013 Pages: 432 Language: English File size: 54.4 MB File format: PDF Download SharePoint 2013 Branding and User Interface Design