Making SharePoint More Secure

Making SharePoint More Secure

Facilitating social computing in SharePoint 2010

Facilitating social computing in SharePoint 2010

New SharePoint 2010 features aid in enterprise content management

New SharePoint 2010 features aid in enterprise content management

Installing SharePoint 2013 Preview on Windows 2012 Server with SQL 2012-Part 1

Installing SharePoint 2013 Preview on Windows 2012 Server with SQL 2012-Part 1

Installing SharePoint 2013 Preview on Windows 2012 Server with SQL 2012-Part 2

Installing SharePoint 2013 Preview on Windows 2012 Server with SQL 2012-Part 2

Configuring My Site in SharePoint 2010

Configuring My Site in SharePoint 2010

How to customize an existing permission level in SharePoint 2010

 ·         Verify that you have one of the following administrative credentials:

o   You are a member of the Administrators group for the site collection.

o   You are a member of the Owners group for the site.

o   You have the Manage Permissions permission.

How to copy an existing permission level in SharePoint 2010

·         Verify that you have one of the following administrative credentials

o   You are a member of the Administrators group for the site collection.

o   You are a member of the Owners group for the site.

o   You have the Manage Permissions permission.

How to create a permission level in SharePoint 2010

·         Verify that you have one of the following administrative credentials

o   You are a member of the Administrators group for the site collection.

o   You are a member of the Owners group for the site.

o   You have the Manage Permissions permission.

Adding and Deploying Solutions in SharePoint 2010

Adding and Deploying Solutions in SharePoint 2010

How we can add solutions in SharePoint 2010 ?

We can add solution via common line using either STSADM or PowerShell command while solution deployment can be done either via Central Admin or using STSADM or PowerShell

Uninstallation and Retraction of a Solution in SharePoint 2010

Uninstallation and Retraction of a Solution in SharePoint 2010

Using STSADM:

stsadm -o retractsolution -name solutionName.wsp -immediate

stsadm -o deletesolution -name solutionName.wsp

Using PowerShell:

Uninstall-SPSolution -identity solutionName.wsp

Remove-SPSolution -identity solutionName.wsp

Deployment guide for Microsoft SharePoint Server 2010 and Server 2013

Deployment guide for Microsoft SharePoint Server 2010
http://www.microsoft.com/en-us/download/details.aspx?id=10009
Downloadable eBook: Deployment guide for SharePoint 2013
http://www.microsoft.com/en-us/download/details.aspx?id=30384
Deploying F5 with Microsoft SharePoint 2010
http://www.f5.com/pdf/deployment-guides/f5-sharepoint-2010-dg.pdf

TIP GUIDE:The Top 10 Guiding Principles for Successful BI
Go beyond reporting to capture the true value of your data! This is the last week to download this tip guide! Overcome data chaos and achieve business-transforming insights: Turn your data into a competitive advantage Achieve higher effeciency and effectiveness Understand the factors that drive your organization Click here to read the next 9 >>

SQL fragmentation analyzer

SQL fragmentation analyzer

Error while modifying Content Query Web Part

Issue:

User tried to modify Content Query Web Part and got following error:

An unexpected error has occurred. Web Parts Maintenance Page: If you have permission, you can use this page to temporarily close Web Parts or remove personal settings. For more information, contact your site administrator

Resolution:

• Open the page in SPD where you put the web part
• Right click on web part and click web part properties
• 
  It will give you following error

•  This is the first step where you can narrow down the issue

• Open Style Library > XSL Style Sheets
• There is a file called itemstyle.xsl
• Open that file in designer
• Press ctrl + F and select “Replace all” option type nbsp
• Replace it with &#160
• Save it and try again to modify the web part
• Let me know if you have any queries on above steps

Recommendation:

Before making any change to any file from SPD please take backup of that particular file, this will be a real SAVIER in such situations

The best link I found for customizing Content Query Web Part – http://www.heathersolomon.com/blog/articles/customitemstyle.aspx

How to cancel a content deployment job in SharePoint 2010

To cancel a content deployment job

You cannot perform this task by using Windows PowerShell cmdlets. You must use the SharePoint Central Administration Web site instead.

• Verify that you have the following administrative credentials:
• You must be a member of the Farm Administrators group on the Central Administration server.
• On the Central Administration Web site, in the General Application Settings section, click Configure content deployment paths and jobs.
• On the Manage Content Deployment Paths and Jobs page, on the menu for the job that you want to cancel, click Cancel.
• The status of the job is reported in the Status column.

Ref: http://technet.microsoft.com/en-us/library/cc262075%28v=office.14%29.aspx#Section4

How to delete a content deployment job by using Windows PowerShell in SharePoint 2010

To delete a content deployment job by using Windows PowerShell

• Verify that you meet the following minimum requirements:
• See Add-SPShellAdmin.
• On the Start menu, click Administrative Tools.
• Click SharePoint 2010 Management Shell.
• From the Windows PowerShell command prompt (that is, PS C:\>), type the following command and press ENTER:
• Remove-SPContentDeploymentJob -Identity <GUID, name or a valid SPContentDeploymentJob object of the job to be deleted>

Ref: http://technet.microsoft.com/en-us/library/cc262075(v=office.14).aspx#Section8

How to delete a content deployment job by using Central Administration in SharePoint 2010

To delete a content deployment job by using Central Administration

• Verify that you have the following administrative credentials:
• You must be a member of the Farm Administrators group on the Central Administration server.
• On the Central Administration Web site, in the General Application Settings section, click Configure content deployment paths and jobs.
• On the Manage Content Deployment Paths and Jobs page, on the menu for the job that you want to delete, click Delete.
• Click OK in the message box that asks whether you want to proceed with the deletion.

Ref: http://technet.microsoft.com/en-us/library/cc262075(v=office.14).aspx#Section8

How to test a content deployment job in SharePoint 2010

To test a content deployment job

• Verify that you have the following administrative credentials:
• You must be a member of the Farm Administrators group on the Central Administration server.
• On the Central Administration Web site, in the General Application Settings section, click Configure content deployment paths and jobs.
• On the Manage Content Deployment Paths and Jobs page, on the menu for the content deployment job that you want to test, click Test Job.
• The status of the job is reported in the Status column.

Ref: http://technet.microsoft.com/en-us/library/cc262075%28v=office.14%29.aspx#Section4

How to manually start a content deployment job by using Windows PowerShell in SharePoint 2010

To manually start a content deployment job by using Windows PowerShell

• Verify that you meet the following minimum requirements:

• See Add-SPShellAdmin.

On the Start menu, click Administrative Tools.

Click SharePoint 2010 Management Shell.

From the Windows PowerShell command prompt (that is, PS C:\>), type the following command and press ENTER:

• Start-SPContentDeploymentJob –Identity <GUID, name or a valid SPContentDeploymentJob object of the job to be started>

Ref: http://technet.microsoft.com/en-us/library/cc262075(v=office.14).aspx#Section3

How to edit a content deployment path by using Windows PowerShell in SharePoint 2010

To edit a content deployment path by using Windows PowerShell

• Verify that you meet the following minimum requirements:
• See Add-SPShellAdmin.
• On the Start menu, click Administrative Tools.
• Click SharePoint 2010 Management Shell.
• From the Windows PowerShell command prompt (that is, PS C:\>), type the following command and press ENTER:
• Set-SPContentDeploymentPath –Identity <GUID, name or a valid SPContentDeploymentPath object of the path to be changed>

Ref: http://technet.microsoft.com/en-us/library/cc262075%28v=office.14%29.aspx#Section4

How to edit a content deployment path by using Central Administration in SharePoint 2010

To edit a content deployment path by using Central Administration

• Verify that you have the following administrative credentials:
• You must be a member of the Farm Administrators group on the Central Administration server.
• On the Central Administration Web site, in the General Application Settings section, click Configure content deployment paths and jobs.
• On the Manage Content Deployment Paths and Jobs page, on the menu for the path that you want to edit, click Edit.
• For more information about the settings that you can edit, see Create a new content deployment path.

Ref: http://technet.microsoft.com/en-us/library/cc262075%28v=office.14%29.aspx#Section4

How to manually start a content deployment job by using Central Administration in SharePoint 2010

To manually start a content deployment job by using Central Administration

• Verify that you have the following administrative credentials:
• You must be a member of the Farm Administrators group on the Central Administration server.

Create a new content deployment path by using Windows PowerShell in SharePoint 2010

·         Verify that you meet the following minimum requirements:

o   See Add-SPShellAdmin.

·         On the Start menu, click All Programs, click Microsoft SharePoint 2010 Products, and then click SharePoint 2010 Management Shell.

·         From the Windows PowerShell command prompt (that is, PS C:\>), type the following command and press ENTER after each line of the command:

$credentials=Get-Credential New-SPContentDeploymentPath -Name <Name of the new deployment path> -SourceSPWebApplication <GUID, URL or a valid SPWebApplication object of the source Web application> -SourceSPSite <GUID, URL or a valid SPSite object of the source site> -DestinationCentralAdministrationURL <URL of the Central Administration Web site on the destination server> -DestinationSPWebApplication <GUID, URL or a valid SPWebApplication object of the destination Web application> -DestinationSPSite <GUID, URL or a valid SPSite object of the destination site> -PathAccount $credentials

Ref: http://technet.microsoft.com/en-us/library/cc262075(v=office.14).aspx

Create a new content deployment path by using Central Administration in SharePoint 2010

·         Verify that you have the following administrative credentials:

o   You must be a member of the Farm Administrators group on the Central Administration server.

·         On the Central Administration Web site, in the General Application Settings section, click Configure content deployment paths and jobs.

Configure content deployment settings in SharePoint 2010

Use the following procedure to configure content deployment settings.

·         Verify that you have the following administrative credentials:

o   You must be a member of the Farm Administrators group on the Central Administration server.

·         On the Central Administration Web site, click General Application Settings.

·         On the General Application Settings page, in the Content Deployment section, click Configure content deployment.

How to enable sandboxed solutions by using Windows PowerShell

To enable sandboxed solutions by using Windows PowerShell

1. Verify that you meet the following minimum requirements: See Add-SPShellAdmin.
2. Click Start, and then click All Programs.
3. Click Microsoft SharePoint 2010 Products.
4. Click SharePoint 2010 Management Shell.
5. At the Windows PowerShell command prompt, type the following command:

 Start-Service -Name SPUserCodeV4

6. Repeat this procedure on every server on which you want to enable sandboxed solutions

 Ref: http://technet.microsoft.com/en-us/library/ff535780(v=office.14).aspx

Enable sandboxed solutions on the farm (SharePoint Server 2010)

Use the following procedure on each application server in your farm on which you want to enable sandboxed solutions.

To enable sandboxed solutions by using Central Administration

1.      Verify that you have the following administrative credentials:

• You must be a member of the Farm Administrators group on the computer that is running the SharePoint Central Administration Web site.

2.      On the home page of the Central Administration Web site, in the System Settings section, click Manage services on server.

3.      On the Services on Server page, in the Server box, select the server on which you want to enable sandboxed solutions.

4.      In the Microsoft SharePoint Foundation Sandboxed Code Service row, in the Action column, click Start.

5.      Repeat steps 3 and 4 for each server on which you want to enable sandboxed solutions.

Ref: http://technet.microsoft.com/en-us/library/ff535780(v=office.14).aspx

How to Enable Document IDs in SharePoint 2010

The document ID feature creates identifiers that can be used to retrieve items independent of their current location. The document ID service that supports it generates and assigns document IDs.

Microsoft explains:

-Document ID’s are automatically assigned to uploaded documents and this ID will follow the item throughout its entire life cycle. Document IDs can also be assigned to Document Sets.

- Document ID’s are automatically assigned to uploaded documents and this ID will follow the item throughout its entire life cycle. Document IDs can also be assigned to Document Sets.

Opening PDFs in SharePoint 2010

Background:

When trying to open a PDF file, I am prompted to save the file. I do not get the option of opening the file, I am forced to save it.

Resolution:

SQL interview questions and answers

What is the difference between IN and BETWEEN, that are used inside a WHERE clause?

-The BETWEEN clause is used to fetch a range of values, whereas the IN clause fetches data from a list of specified values.
What are the wildcards used for pattern matching?
- for single character substitution and % for multi-character substitution
What is Online Transaction Processing (OLTP) ?
-Online transaction processing systems relational database design use the discipline of data modeling and generally follow the Codd rules of data normalization in order to ensure absolute data integrity.