SharePoint By Gaurav Goyal

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