SP Dispose check

When coding a solution in Visual Studio memory leaks which occurs from object disposals which were not handled can be checked using the tool available here.

Add / remove options from an existing SQL database

When there is a need to change settings of an existing Ms SQL database you will need to add ASP.NET SQL Server Registration into windows registry.

It can be done using the following method.

Navigate to [drive:]\%windir%\Microsoft.NET\Framework\version folder on your Web server, and type aspnet_regsql on the command prompt.

E.g.: 

C:\>cd Windows

C:\Windows>cd Microsoft.NET

C:\Windows\Microsoft.NET>cd Framework

C:\Windows\Microsoft.NET\Framework>cd v2.0.50727

C:\Windows\Microsoft.NET\Framework\v2.0.50727>aspnet_regsql

After registering this functionality existing settings of existing databases can be altered after creation.

More information on the tool can be found on the following reference link.

Reference: http://msdn.microsoft.com/en-us/library/ms229862%28v=vs.80%29.aspx

How to get the build version of SharePoint 2010

Keeping track on SharePoint 2010 upgrades are critical for maintenance and development using SharePoint.
There are three methods from which the build version of SharePoint 2010 can be checked.

• From the SharePoint 2010 Central Administration

Go to SharePoint 2010 Central Administration -> Upgrade and Migration -> Check Product and patch Installation Status

• From PowerShell (registry entry)

 Go to SharePoint 2010 Management Shell and enter the following script to get the SharePoint 2010 version registered in the Windows registry

(Get-item "hklm:software\microsoft\shared tools\web server extensions\14.0").Getvalue("version")

• From PowerShell (farm build version)

 Go to SharePoint 2010 Management Shell and enter the following script to get the SharePoint 2010 farm build version

(get-spfarm).buildversion

The newest updates on SharePoint 2010 Server can be checked from the following reference location.

References: http://technet.microsoft.com/en-us/sharepoint/ff800847

More accurate method to disable Loop back

Method 1 (recommended): Create the Local Security Authority host names that can be referenced in an NTLM authentication request

To do this, follow these steps for all the nodes on the client computer:

1. Click Start, click Run, type regedit, and then click OK.
2. Locate and then click the following registry subkey: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa\MSV1_0
3. Right-click MSV1_0, point to New, and then click Multi-String Value.
4. In the Name column, type BackConnectionHostNames, and then press ENTER.
5. Right-click BackConnectionHostNames, and then click Modify.
6. In the Value data box, type the CNAME or the DNS alias, that is used for the local shares on the computer, and then click OK.

Note Type each host name on a separate line.

Note If the BackConnectionHostNames registry entry exists as a REG_DWORD type, you have to delete the BackConnectionHostNames registry entry.
7. Exit Registry Editor, and then restart the computer.

Steps to deploy a SharePoint 2010 site

The basic steps to deploy a SharePoint 2010 site are as follows;

• Create Web Application
• Deploy the content packages 
•  (using a powershell script)
• Edit the web.config file 
• Located in the C:\inetpub\wwwroot\wss\VirtualDirectories\<web_application_folder>
• Do the IIS-Binding
• Go to Start -> Run -> IIS-Manager  and select the desired website from the list and click Bindings. Add the url of the site as a new binding. 
• Enable features
• This is only required if you are not restoring a backup of a site collection.
• (Optional) 
• Restoring a site collection backup. Refer here for details.

Restoring a sitecollection backup in SP 2010

In SharePoint 2010 Management Shell you can enter the following command in order to restore a site collection backup in to a SharePoint 2010 we application.

Restore-SPSite -Identity -Path [-DatabaseServer ] [-DatabaseName ] [-HostHeader ] [-Force] [-GradualDelete] [-Verbose]



For example in order to restore a site collection to a certain web application we can use the following command.

PS C:\> Restore-SPSite -Identity http://cd-sgunasena -Path C:\UpdateFw\sitecollectionbackup\abc.bak -HostHeaderWebApplication http://abcdemo.abcompany.com -Force


Reference: MSDN

Using Host Headers

We can use host headers to host different sites in the same port. We can access them using different host names assigned to the same port address in the host file of the machine.
You can find the host file in the following location;
C:\Windows\System32\drivers\etc 
Open it using a notepad and add the host address and the desired host name you wish to use.

E.G.:   
# localhost name resolution is handled within DNS itself.
#    127.0.0.1       localhost
#    ::1             localhost

172.11.111.111    somesite.abcompany.com