SharePoint By Gaurav Goyal

SharePoint Interview Questions and Answers Q What is SharePoint? Ans SharePoint is a browser based document collaboration platform given by Microsoft. Q What are features of SharePoint 2010? Ans Some features are : ·          Document Collaboration ·          Enterprise Search FAST Search ·          New Enhance Web Part ·          Ready made Silver Light web part ·          Business Connectivity Services ·          Social Media Investments ·          Large lists ·          Enhanced collaboration features ·          Visio Services ·          Usage reporting and logging ·          Better Network Differencing & SharePoint Offline in SharePoint Workspace ·          High Availability/ Disaster Recovery Innovation ·          Admin Insights through the Logging & Usage database, and dev dashboard ·          Service Applications ·          SharePoint Designer Enhancements like portable workflows, and gran

I wanted to create a report in which I have created a Parameter called "User Name" , Which shows all users from SharePoint list. Now I marked this parameter as Multi value selector. But I am not able to use values of this parameter in SSRS report because this report uses CAML Query not SQL query. When I select 1 or more users and click on 'View Report' button. It gives me an error : Cannot add multi value query parameter 'Users' for dataset 'TSADataSet' because it is not supported by the data extension. (rsErrorAddingMultiValueQueryParameter) So I used this parameter in filter option of Data Set. Now it is working fine. I just followed these steps : Create multi-value parameter as you want. Right click to “ your dataset ” then click on “ Dataset Properties ”. In Dataset property form, Click on “Filters” and add expression (Field) then select Operator (Select “In” operator in case of multivalue parameter) then select value (Click on form

Microsoft released 10 new SharePoint themes you can download these theams from : Download them from Microsoft

For Backup :     http://technet.microsoft.com/en-us/library/cc287967.aspx     For site collection backup stsadm -o backup -url <URL name> -filename <file name> [-nositelock] [-overwrite]   For Restore : http://technet.microsoft.com/en-us/library/cc288929.aspx   For site collection restore   stsadm -o restore -url <URL name> -filename <file name> [-hostheaderwebapplicationurl] <Web application URL> [-overwrite]   To Take Backup of Site C:\Progra~1\Common~1\Microsoft Shared\Web Server Extensions\14\BIN> stsadm -o backup - url http://testserver/sites/sitename -filename c:\backup\bk.dat    To Restore Whole Site C:\Progra~1\Common~1\Microsoft Shared\Web Server Extensions\14\BIN> stsadm -o restore - url http://server/sites/newsite -filename c:\backup\bk.dat If you want to overwrite existing web site then use -overwrite .    

If you want to remove "I like It" , "Tags & Notes " Then just follow these steps : Open Central Administration Click on System Settings Click on Manage Farm Features (_admin/ManageFarmFeatures.aspx) Deactivate the Social Tags and Note Board Ribbon Controls OR You can deactivate this feature by Power shell command : SharePoint 2010 Management Shell Disable-SPFeature –Identity SocialRibbonControl

First, increase the Maximum Upload Size for a specific web application. Go to the Central Administration > Application Management > Web Application General Settings Specify the new maximum upload size for your webapplication. For now, we are setting it to 256MB. It could be even set upto 2GB. Your second step should be to try increasing your default chunk size of large files by trying this STSADM command: Stsadm.exe –o setproperty –pn large–file–chunk–size –pv        This basically denotes the chunk of data that can be read from SQL Server at one time.     The -pv which determines the property value stands for the upload size in bytes (B).     It could be set to a maximum of 2GB i.e. (2,147,483,648 B).     Do an IISRESET Next, in web.config file of your particular web application, under the httpRuntime tag in system.web section, increase the upload limit to match the value that you set earlier in central administration. You also need to add the execution timeout to allow mo

Let’s say you have a control on your page that you want only a certain group of users to see. Fortunately, SharePoint has a built-in control that lets you hide controls to which users do not have the necessary permissions.  This control is the SPSecurityTrimmedControl. <Sharepoint:SPSecurityTrimmedControl runat=”server” Permissions=”ManageLists”> Place your control(s) here </SharePoint:SPSecurityTrimmedControl> All you have to do is wrap your control with this security control and set the correct permissions in the Permissions attribute. The Permissions attribute, when used in Visual Studio or Designer, will have intellisense and will be filled with the following properties obtained from http://msdn2.microsoft.com/en-us/library/microsoft.sharepoint.spbasepermissions.aspx .  Whatever permissions you specify will be required by the user in order to view the control(s) inside of the SPSecurityTrimmedControl:   Member name  Description EmptyMask