SharePoint Server, MOSS, SharePoint Development, Collaboration

Correct Permissions to Update WordPress installed on IIS

2018-11-14T15:13:00.000-08:00

To make WordPress update without the need of using FTP, add the following line to wp-config.php

/** Sets up auto update without FTP */
define('FS_METHOD','direct');

To Correct Permissions to Update WordPress installed on IIS, basically you need to give read/write permission to an "Authenticated users" and change the site Application Pool identity to LocalSystem

In IIS manager

Go to Application pools and choose the one used by your WordPress site.
Right Click and choose Advanced Settings...
Change the Identity to LocalSystem
Click OK to save changes.

Then on Sites list,

Choose your WordPress site from the sites list
Right click on it and click on Edit permissions
Go to security tab and click on Edit... (Group or user names)
Click on add and type "Authenticated users"
Give read/write permission to an "Authenticated users"
Click OK to save changes.

Now try to update WordPress and it should work perfect !

How to fix: Cannot connect to WMI provider. You do not have permission or the server is unreachable

2016-07-19T03:45:00.002-07:00

If you get the following error message when you open SQL Server Configuration Manager

"Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 and later servers with SQL Server Configuration Manager.
Invalid class [0x80041010]"

To make it work again, open a command prompt as an administrator, and type the following command, then press ENTER:
mofcomp "%programfiles(x86)%\Microsoft SQL Server\number\Shared\sqlmgmproviderxpsp2up.mof"
Note For this command to succeed, the Sqlmgmproviderxpsp2up.mof file must be present in the %programfiles(x86)%\Microsoft SQL Server\number\Shared folder.

The value of number depends on the version of SQL Server:nnn

Microsoft SQL Server 2012 110
Microsoft SQL Server 2008 R2 100
Microsoft SQL Server 2008 100
Microsoft SQL Server 2005 90

After you run the Mofcomp tool, restart the WMI service for the changes to take effect. The service name is Windows management Instrumentation.

Thats it :)

Ref: https://support.microsoft.com/en-us/kb/956013

Change the Display Order for a User Property in SharePoint User Properties with PowerShell

2015-12-05T02:09:00.000-08:00

#First create a connection to the User Profile Manager

$MySite = Get-SPSite http://MySite
$context = Get-SPServiceContext $MySite
$profileManager = New-Object Microsoft.Office.Server.UserProfiles.UserProfileManager($context)

#Then type To view the current order
$profilemanager.properties | ft name,displayorder

#set the display order for a property
$profileManager.Properties.SetDisplayOrderByPropertyName("Languages",16)
$profileManager.Properties.CommitDisplayOrder()

Fixed: Unable to start User profile sync service ,stuck at Starting - in SharePoint server 2013

2015-11-11T02:16:00.002-08:00

Issue & Observations
Unable to start User Profile sync service from Central administration site ->system settings->Services on server. The service freezes at "starting" and never start.
netsh http delete urlacl url=http://+:5726/

Exception occured while connecting to WCF endpoint: Microsoft.SharePoint.SPEndpointAddressNotFoundException: There are no addresses available for this application. at Microsoft.SharePoint.SPRoundRobinServiceLoadBalancer.BeginOperation() at Microsoft.Office.Server.UserProfiles.MossClientBase`1.get_Channel() at Microsoft.Office.Server.UserProfiles.MossClientBase`1.ExecuteOnChannel(String operationName, CodeBlock codeBlock) at Microsoft.Office.Server.UserProfiles.ProfilePropertyServiceClient.ExecuteOnChannel(String operationName, CodeBlock codeBlock)
UserProfileApplicationProxy.InitializePropertyCache: Microsoft.Office.Server.UserProfiles.UserProfileException: There are no addresses available for this application. ---> Microsoft.SharePoint.SPEndpointAddressNotFoundException: There are no addresses available for this application. at Microsoft.SharePoint.SPRoundRobinServiceLoadBalancer.BeginOperation() at Microsoft.Office.Server.UserProfiles.MossClientBase`1.get_Channel() at Microsoft.Office.Server.UserProfiles.MossClientBase`1.ExecuteOnChannel(String operationName, CodeBlock codeBlock) at
Microsoft.Office.Server.UserProfiles.ProfilePropertyServiceClient.ExecuteOnChannel(String operationName, CodeBlock codeBlock) --- End of inner exception stack trace --- at Microsoft.Office.Server.UserProfiles.ProfilePropertyServiceClient.ExecuteOnChannel(String operationName, CodeBlock codeBlock) at Microsoft.Office.Server.UserProfiles.ProfilePropertyServiceClient.GetProfileProperties() at Microsoft.Office.Server.Administration.UserProfileApplicationProxy.RefreshProperties(Guid applicationID) at Microsoft.Office.Server.Utilities.SPAsyncCache`2.GetValueNow(K key) at Microsoft.Office.Server.Utilities.SPAsyncCache`2.GetValue(K key, Boolean asynchronous) at Microsoft.Office.Server.Administration.UserProfileApplicationProxy.InitializePropertyCache()
From Event viewer
Log Name: Application
Source: Microsoft-SharePoint Products-SharePoint Foundation
Date: 3/4/2011 12:30:23 PM
Event ID: 8077
Task Category: Topology
Level: Error
Keywords:
User: Domain\sp_farm
Computer: Computer FQDN
Description:
"There are no instances of the User Profile Service started on any server in this farm. Ensure that at least one instance is started on an application server in the farm using the Services on Server page in Central Administration."
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="Microsoft-SharePoint Products-SharePoint Foundation" Guid="{6FB7E0CD-52E7-47DD-997A-241563931FC2}" />
<EventID>8077</EventID>
<Version>14</Version>
<Level>2</Level>
<Task>13</Task>
<Opcode>0</Opcode>
<Keywords>0x4000000000000000</Keywords>
<TimeCreated SystemTime="2011-03-04T18:30:23.718750000Z" />
<EventRecordID>18688</EventRecordID>
<Correlation />
<Execution ProcessID="3356" ThreadID="5948" />
<Channel>Application</Channel>
<Computer>Computer name</Computer>
<Security UserID="S-1-5-21-1834648779-3785927647-1620804944-5169" />
</System>
<EventData>
<Data Name="string0">User Profile Service</Data>
</EventData>
</Event>
-----------------------------------------------------------------------------------------------------------------------------------
Log Name: Application
Source: Microsoft Resource Management Service
Date: 3/4/2011 1:00:07 PM
Event ID: 0
Task Category: None
Level: Error
Keywords: Classic
User: N/A
Computer: Computer name
Description:
Service cannot be started. System.Data.SqlClient.SqlException: Cannot open database "Sync DB" requested by the login. The login failed.
Login failed for user domain\sp_farm'.
at Microsoft.ResourceManagement.WindowsHostService.OnStart(String[] args)
at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="Microsoft Resource Management Service" />
<EventID Qualifiers="0">0</EventID>
<Level>2</Level>
<Task>0</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2011-03-04T19:00:07.000000000Z" />
<EventRecordID>18718</EventRecordID>
<Channel>Application</Channel>
<Computer>sharepoint</Computer>
<Security />
</System>
<EventData>
<Data>Service cannot be started. System.Data.SqlClient.SqlException: Cannot open database "Sync DB" requested by the login. The login failed.
Login failed for user 'Domain\sp_farm'.
at Microsoft.ResourceManagement.WindowsHostService.OnStart(String[] args)
at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)</Data>
</EventData>
</Event>
-----------------------------------------------------------------------------------------------------------------------------------
Log Name: Application
Source: Forefront Identity Manager
Date: 3/4/2011 1:00:07 PM
Event ID: 3
Task Category: None
Level: Error
Keywords: Classic
User: N/A
Computer: sharepoint
Description:
.Net SqlClient Data Provider: System.Data.SqlClient.SqlException: Cannot open database "Sync DB" requested by the login. The login failed.
Login failed for user 'domain\sp_farm'.
at Microsoft.ResourceManagement.Data.Exception.DataAccessExceptionManager.ThrowException(SqlException innerException)
at Microsoft.ResourceManagement.Data.DatabaseConnection.Open(SqlConnection connection)
at Microsoft.ResourceManagement.Data.DatabaseConnection.Open(DataStore store)
at Microsoft.ResourceManagement.Data.TransactionAndConnectionScope..ctor(Boolean createTransaction, IsolationLevel isolationLevel, DataStore dataStore)
at Microsoft.ResourceManagement.Data.TransactionAndConnectionScope..ctor(Boolean createTransaction)
at Microsoft.ResourceManagement.Data.DataAccess.RegisterService(String hostName)
at Microsoft.ResourceManagement.Workflow.Hosting.HostActivator.RegisterService(String hostName)
at Microsoft.ResourceManagement.Workflow.Hosting.HostActivator.Initialize()
at Microsoft.ResourceManagement.WebServices.ResourceManagementServiceHostFactory.CreateServiceHost(String constructorString, Uri[] baseAddresses)
at Microsoft.ResourceManagement.WindowsHostService.OnStart(String[] args)
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="Forefront Identity Manager" />
<EventID Qualifiers="0">3</EventID>
<Level>2</Level>
<Task>0</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2011-03-04T19:00:07.000000000Z" />
<EventRecordID>18717</EventRecordID>
<Channel>Application</Channel>
<Computer>sharepoint</Computer>
<Security />
</System>
<EventData>
<Data>.Net SqlClient Data Provider: Sys
-----------------------------------------------------------------------------------------------------------------------------------
Log Name: Application
Source: Microsoft.ResourceManagement.ServiceHealthSource
Date: 3/4/2011 1:00:07 PM
Event ID: 2
Task Category: None
Level: Error
Keywords: Classic
User: N/A
Computer: sharepoint
Description:
The Forefront Identity Manager Service could not bind to its endpoints. This failure prevents clients from communicating with the Web services.
A most likely cause for the failure is another service, possibly another instance of Forefront Identity Manager Service, has already bound to the endpoint. Another, less likely cause, is that the account under which the service runs does not have permission to bind to endpoints.
Ensure that no other processes have bound to that endpoint and that the service account has permission to bind endpoints. Further, check the application configuration file to ensure the Forefront Identity Manager Service is binding to the correct endpoints.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="Microsoft.ResourceManagement.ServiceHealthSource" />
<EventID Qualifiers="0">2</EventID>
<Level>2</Level>
<Task>0</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2011-03-04T19:00:07.000000000Z" />
<EventRecordID>18716</EventRecordID>
<Channel>Application</Channel>
<Computer>sharepoint</Computer>
<Security />
</System>
<EventData>
<Data>The Forefront Identity Manager Service could not bind to its endpoints. This failure prevents clients from communicating with the Web services.
A most likely cause for the failure is another service, possibly another instance of Forefront Identity Manager Service, has already bound to the endpoint. Another, less likely cause, is that the account under which the service runs does not have permission to bind to endpoints.
Ensure that no other processes have bound to that endpoint and that the service account has pe
-----------------------------------------------------------------------------------------------------------------------------------
Log Name: Application
Source: Microsoft.ResourceManagement.ServiceHealthSource
Date: 3/4/2011 1:00:07 PM
Event ID: 26
Task Category: None
Level: Error
Keywords: Classic
User: N/A
Computer: sharepoint
Description:
The Forefront Identity Manager Service was not able to initialize a timer necessary for supporting the execution of workflows.
Upon startup, the Forefront Identity Manager Service must initialize and set a timer to support workflow execution. If this timer fails to get created, workflows will not run successfully and there is no recovery other than to stop and start the Forefront Identity Manager Service.
Restart the Forefront Identity Manager Service.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="Microsoft.ResourceManagement.ServiceHealthSource" />
<EventID Qualifiers="0">26</EventID>
<Level>2</Level>
<Task>0</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2011-03-04T19:00:07.000000000Z" />
<EventRecordID>18715</EventRecordID>
<Channel>Application</Channel>
<Computer>sharepoint</Computer>
<Security />
</System>
<EventData>
<Data>The Forefront Identity Manager Service was not able to initialize a timer necessary for supporting the execution of workflows.
Upon startup, the Forefront Identity Manager Service must initialize and set a timer to support workflow execution. If this timer fails to get created, workflows will not run successfully and there is no recovery other than to stop and start the Forefront Identity Manager Service.
Restart the Forefront Identity Manager Service.</Data>
</EventData>
</Event>
-----------------------------------------------------------------------------------------------------------------------------------
Log Name: Application
Source: Microsoft.ResourceManagement.ServiceHealthSource
Date: 3/4/2011 1:00:06 PM
Event ID: 22
Task Category: None
Level: Error
Keywords: Classic
User: N/A
Computer: sharepoint
Description:
The Forefront Identity Manager Service cannot connect to the SQL Database Server.
The SQL Server could not be contacted. The connection failure may be due to a network failure, firewall configuration error, or other connection issue. Additionally, the SQL Server connection information could be configured incorrectly.
Verify that the SQL Server is reachable from the Forefront Identity Manager Service computer. Ensure that SQL Server is running, that the network connection is active, and that the firewall is configured properly. Last, verify the connection information has been configured properly. This configuration is stored in the Windows Registry.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="Microsoft.ResourceManagement.ServiceHealthSource" />
<EventID Qualifiers="0">22</EventID>
<Level>2</Level>
<Task>0</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2011-03-04T19:00:06.000000000Z" />
<EventRecordID>18712</EventRecordID>
<Channel>Application</Channel>
<Computer>sharepoint</Computer>
<Security />
</System>
<EventData>
<Data>The Forefront Identity Manager Service cannot connect to the SQL Database Server.
The SQL Server could not be contacted. The connection failure may be due to a network failure, firewall configuration error, or other connection issue. Additionally, the SQL Server connection information could be configured incorrectly.
Verify that the SQL Server is reachable from the Forefront Identity Manager Service computer. Ensure that SQL Server is running, that the network connection is active, and that the firewall is configured properly. Last, ver

Cause
In this case, the SSP was not migrated properly. Some of the database information was not properly registered in the SharePoint server registry.

Resolution
- Stop User profile service and User profile sync service on ALL SharePoint servers in the farm
- Clear timer config cache by following the "resolution" documented at thttp://support.microsoft.com/kb/939308

- Deleted the Pending timer job related to the UPA sync service provisioning using Central administration->Monitoring->check job status

- Confirmed that the security token service has only windows and anonymous enabled ( from IIS manager->SharePoint web services->Security token service->Authentication (under IIS))

- On the SharePoint server access the registry editor and confirm that the information related to FIM ( database servername , sync DB name etc ) are properly populated, if found wrong , back up the registry key and edit the values to reflect the right information.

HKLM\system\currentcontrolset001\services\FIMservice
HKLM\system\currentcontrolset002\services\FIMservice
HKLM\system\currentcontrolset\services\FIMservice

- Delete all FIM related certificates from certificate store ( for account and system) . Make sure that no FIM related certificate is listed in any folders when looked at certificate manager.

Here is a script to remove the ForeFrontIdentityManager Certificates off your server for you:

net stop sptimerv4
net stop spadminv4

sl cert:
Get-ChildItem -Recurse | Where { $_.Issuer -eq “CN=ForefrontIdentityManager” }
Get-ChildItem -Recurse | Where { $_.Issuer -eq “CN=ForefrontIdentityManager” } | Remove-Item
Get-ChildItem -Recurse | Where { $_.Issuer -eq “CN=ForefrontIdentityManager” }

net start sptimerv4
net start spadminv4

And I deleted both of the Discresionary Access Lists ( acl )
netsh http delete urlacl url=http://+:5725/

- From Central administration->Application management->Manage service application, Make sure the User profile service application and its proxy are started, If found stopped, its always recommended to recreate them taking necessary backups (mysites)

- Start User profile service on the machine where you would like to start the User profile sync service (use central administration console)

- Once the service is started, try starting the User profile sync service from the central administration site

PLESK: How-to change subscription expiry to unlimited via command line in

2015-06-10T14:18:00.000-07:00

Sometimes you may discover that domains suspending for no reason every day !

Or subscriptions get automatically disabled when statistics are recalculated. This happens for several subscriptions.

We faced this! even while subscriptions are assigned to a custom plan where resource over usage is allowed!

Reason:
In Parallels Plesk control panel subscriptions get suspended automatically if their expiration date passes.

Plesk does not renew subscriptions automatically, so it suspends a subscription when the subscription expiration date comes. By default, the expiration date is "Setup date + 1 year".

As I mentioned in my previous post How to Activate Subscription via command line in PLESK for windows

in Parallels PLESK - Web Admin Edition you don't have a tap to manage subscriptions, so you will have to do it via command line

To check the expiry status for your hosted domains:

Open CMD and type the following in one line:
C:\Program Files (x86)\Parallels\Plesk\admin\bin>dbclient --direct-sql --

sql="SELECT domains.name,limits.value,limits.limit_name FROM

limits,subscriptionproperties INNER JOIN subscriptions ON

subscriptionproperties.subscription_id = subscriptions.id INNER JOIN domains

ON subscriptions.object_id = domains.id WHERE subscriptionproperties.name =

'limitsId' AND limits.limit_name = 'expiration' AND

subscriptionproperties.value = limits.id;"

Now, to change subscription expiry to unlimited via command line type the following:
C:\Program Files (x86)\Parallels\Plesk\admin\bin>subscription_settings.exe -u
mydomain.com -expiration -1

and you are done :)

How to Activate Subscription via command line in PLESK for windows

2015-06-10T00:03:00.000-07:00

Hi,

Few days ago I faced a problem on one of my servers, the server running with Parallels PLESK 12 - Web Admin Edition.

in Web Admin Edition you don't have a tap to manage subscriptions, one of my hosted domain suddenly suspended with no reason, when I tried to activate it I got an Error msg that the domain has been suspended by my Hosting provider and I can'y active it. WHAT !! I'm on my own server!

I searched in every link in the Plesk control panel and didn't found anyway to activate it!

the only solution was to activate it via command line as following:

Activate Subscription:
C:\Program Files (x86)\Parallels\Plesk\bin>domain.exe --webspace-on mydomain.com

Successfully activated

That fixed the problem and the domain become active now, but it was only for one day :(

The next day the domain got suspended again!

Find out why this happened an how I fixed it permanently in the next post.

How to update year only in a date datatype

2015-05-15T16:53:00.001-07:00

In some cases you may need to update your date value in database by changing the date from year to another Ex. updating your dates from year 2014 to 2015

SQL update datetime year only

This way is very simple:

UPDATE TableName SET [Date Column] = DATEADD(YEAR, 1, [Date Column]);

That's it !

Fixing a SharePoint 2010 Stuck Timer Job

2013-11-04T21:31:00.003-08:00

Resolution :Toresolve this issue, clear the file system cache on all servers in the serverfarm on which the Windows SharePoint Services Timer service is running. To dothis, follow these steps:

Stop the Timer service. To do this, follow these steps:

Click Start, point to Administrative Tools, and then click Services.
Right-click Windows SharePoint Services Timer, and then click Stop.
Close the Services console.

On the computer that is running Microsoft Office SharePoint Server 2007 and on which the Central Administration site is hosted, click Start, click Run, type explorer, and then press ENTER.
In Windows Explorer, locate and then double-click the following folder:

Drive:\Documents andSettings\All Users\Application Data\Microsoft\SharePoint\Config\GUID

Notes

The Drive placeholder specifies the letter of the drive on which Windows is installed. By default, Windows is installed on drive C.
The GUID placeholder specifies the GUID folder.
The Application Data folder may be hidden. To view the hidden folder, follow these steps:

On the Tools menu, click Folder Options.
Click the View tab.
In the Advanced settings list, click Show hidden files and folders under Hidden files and folders, and then click OK.

In Windows Server 2008, the configuration cache is in the following location:

Drive:\ProgramData\Microsoft\SharePoint\Config\GUID

Back up the Cache.ini file.
Delete all the XML configuration files in the GUID folder. Do this so that you can verify that the GUID folder is replaced by new XML configuration files when the cache is rebuilt.

Note When you empty the configuration cache in the GUID folder, make sure that you do not delete the GUID folder and the Cache.ini file that is located in the GUID folder.

Double-click the Cache.ini file.
On the Edit menu, click Select All.
On the Edit menu, click Delete.
Type 1, and then click Save on the File menu.
On the File menu, click Exit.
Start the Timer service. To do this, follow these steps:

Click Start, point to Administrative Tools, and then click Services.
Right-click Windows SharePoint Services Timer, and then clickStart.
Close the Services console.

Note The file systemcache is re-created after you perform this procedure. Make sure that youperform this procedure on all servers in the server farm.

Make sure that the Cache.ini file in the GUID folder now contains its previous value. For example, make sure that the value of the Cache.ini file is not 1.
Click Start, point to Programs, point to Administrative Tools, and then clickSharePoint 3.0 Central Administration.
Click the Operations tab, and then click Timer job status under Global Configuration.
In the list of timer jobs, verify that the status of the Config Refresh entry issucceeded.
On the File menu, click Close.

How to Create a Minimal Master Page

2013-09-29T00:16:00.003-07:00


To create a minimal master page



Open SharePoint Designer.


On the File menu, click New, point to SharePoint Content, and then click the Page tab.


Double-click Master Page to create a new master page.


Click Design to show the master page in design view. You should see header and left margin areas and several content placeholders in the master page.


Click Code to show the master page in code view.


Copy the following code into the master page.

<%-- Identifies this page as a .master page written in Microsoft Visual C# and registers tag prefixes, namespaces, assemblies, and controls. --%>
<%@ Master language="C#" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<%@ Import Namespace="Microsoft.SharePoint" %>
<%@ Register Tagprefix="SPSWC" Namespace="Microsoft.SharePoint.Portal.WebControls" Assembly="Microsoft.SharePoint.Portal, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>
<%@ Register Tagprefix="SharePoint" Namespace="Microsoft.SharePoint.WebControls" Assembly="Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>
<%@ Register Tagprefix="WebPartPages" Namespace="Microsoft.SharePoint.WebPartPages" Assembly="Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>
<%@ Register Tagprefix="PublishingWebControls" Namespace="Microsoft.SharePoint.Publishing.WebControls" Assembly="Microsoft.SharePoint.Publishing, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>
<%@ Register Tagprefix="PublishingNavigation" Namespace="Microsoft.SharePoint.Publishing.Navigation" Assembly="Microsoft.SharePoint.Publishing, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>
<%@ Register TagPrefix="wssuc" TagName="Welcome" src="~/_controltemplates/Welcome.ascx" %>
<%@ Register TagPrefix="wssuc" TagName="DesignModeConsole" src="~/_controltemplates/DesignModeConsole.ascx" %>
<%@ Register TagPrefix="PublishingVariations" TagName="VariationsLabelMenu" src="~/_controltemplates/VariationsLabelMenu.ascx" %>
<%@ Register Tagprefix="PublishingConsole" TagName="Console" src="~/_controltemplates/PublishingConsole.ascx" %>
<%@ Register TagPrefix="PublishingSiteAction" TagName="SiteActionMenu" src="~/_controltemplates/PublishingActionMenu.ascx" %>
<%-- Uses the Microsoft Office namespace and schema. --%>
<html>
  <WebPartPages:SPWebPartManager runat="server"/>
  <SharePoint:RobotsMetaTag runat="server"/>

  <%-- The head section includes a content placeholder for the page title and links to CSS and ECMAScript (JScript, JavaScript) files that run on the server. --%>
  <head runat="server">
    <asp:ContentPlaceHolder runat="server" id="head">
      <title>
        <asp:ContentPlaceHolder id="PlaceHolderPageTitle" runat="server" />
      </title>
    </asp:ContentPlaceHolder>
    <Sharepoint:CssLink runat="server"/>
    <asp:ContentPlaceHolder id="PlaceHolderAdditionalPageHead" runat="server" />
  </head>
  
  <%-- When loading the body of the .master page, SharePoint Server 2007 also loads the SpBodyOnLoadWrapper class. This class handles .js calls for the master page. --%>
  <body onload="javascript:_spBodyOnLoadWrapper();">
    <%-- The SPWebPartManager manages all of the Web part controls, functionality, and events that occur on a Web page. --%>
    <form runat="server" onsubmit="return _spFormOnSubmitWrapper();">
      <wssuc:Welcome id="explitLogout" runat="server"/>
      <PublishingSiteAction:SiteActionMenu runat="server"/>  
      <PublishingWebControls:AuthoringContainer id="authoringcontrols" runat="server">
        <PublishingConsole:Console runat="server" />
      </PublishingWebControls:AuthoringContainer>
      <%-- The PlaceHolderMain content placeholder defines where to place the page content for all the content from the page layout. The page layout can overwrite any content placeholder from the master page. Example: The PlaceHolderLeftNavBar can overwrite the left navigation bar. --%>
      <asp:ContentPlaceHolder id="PlaceHolderMain" runat="server" />
        <asp:Panel visible="false" runat="server">
        <%-- These ContentPlaceHolders ensure all default SharePoint Server pages render with this master page. If the system master page is set to any default master page, the only content placeholders required are those that are overridden by your page layouts. --%>
<asp:ContentPlaceHolder id="PlaceHolderSearchArea" runat="server"/>
<asp:ContentPlaceHolder id="PlaceHolderTitleBreadcrumb" runat="server"/>
<asp:ContentPlaceHolder id="PlaceHolderPageTitleInTitleArea"  runat="server"/>
<asp:ContentPlaceHolder id="PlaceHolderLeftNavBar" runat="server"/>
<asp:ContentPlaceHolder ID="PlaceHolderPageImage" runat="server"/>
<asp:ContentPlaceHolder ID="PlaceHolderBodyLeftBorder" runat="server"/>
<asp:ContentPlaceHolder ID="PlaceHolderNavSpacer" runat="server"/>
<asp:ContentPlaceHolder ID="PlaceHolderTitleLeftBorder" runat="server"/>
<asp:ContentPlaceHolder ID="PlaceHolderTitleAreaSeparator" runat="server"/>
<asp:ContentPlaceHolder ID="PlaceHolderMiniConsole" runat="server"/>
<asp:ContentPlaceHolder id="PlaceHolderCalendarNavigator" runat ="server" />
<asp:ContentPlaceHolder id="PlaceHolderLeftActions" runat ="server"/>
<asp:ContentPlaceHolder id="PlaceHolderPageDescription" runat ="server"/>
<asp:ContentPlaceHolder id="PlaceHolderBodyAreaClass" runat ="server"/>
<asp:ContentPlaceHolder id="PlaceHolderTitleAreaClass" runat ="server"/>
<asp:ContentPlaceHolder id="PlaceHolderBodyRightMargin" runat="server" />
</asp:Panel>
    </form>
  </body>
</html>

Select Sql Date / DateTime Formats By Name

2013-03-04T23:14:00.001-08:00

– SQL format datetime by name

– Default format: Oct 23 2006 10:40AM

SELECT [Default]=CONVERT(varchar,GETDATE(),100)

– US-Style format: 10/23/2006

SELECT [US-Style]=CONVERT(char,GETDATE(),101)

– ANSI format: 2006.10.23

SELECT [ANSI]=CONVERT(char,CURRENT_TIMESTAMP,102)

– UK-Style format: 23/10/2006

SELECT [UK-Style]=CONVERT(char,GETDATE(),103)

– German format: 23.10.2006

SELECT [German]=CONVERT(varchar,GETDATE(),104)

– ISO format: 20061023

SELECT ISO=CONVERT(varchar,GETDATE(),112)

– ISO8601 format: 2008-10-23T19:20:16.003

SELECT [ISO8601]=CONVERT(varchar,GETDATE(),126)

————

– SQL Server datetime formats

– Century date format MM/DD/YYYY usage in a query

– Format dates SQL Server 2005

SELECT TOP (1)

      SalesOrderID,

      OrderDate = CONVERT(char(10), OrderDate, 101),

      OrderDateTime = OrderDate

FROM AdventureWorks.Sales.SalesOrderHeader

/* Result

SalesOrderID      OrderDate               OrderDateTime

43697             07/01/2001          2001-07-01 00:00:00.000

*/

How to Create SQL Server Date Formatting function

2013-03-04T23:10:00.002-08:00

In this post we will learn How to create a SQL Server function to display Date in different formats

– SQL Server date formatting function – convert datetime to string

————

– SQL datetime functions

– SQL Server date formats

– T-SQL convert dates

– Formatting dates sql server

CREATE FUNCTION dbo.fnFormatDate (@Datetime DATETIME, @FormatMask VARCHAR(32))

RETURNS VARCHAR(32)

AS

BEGIN

    DECLARE @StringDate VARCHAR(32)

    SET @StringDate = @FormatMask

    IF (CHARINDEX (‘YYYY’,@StringDate) > 0)

       SET @StringDate = REPLACE(@StringDate, ‘YYYY’,

                         DATENAME(YY, @Datetime))

    IF (CHARINDEX (‘YY’,@StringDate) > 0)

       SET @StringDate = REPLACE(@StringDate, ‘YY’,

                         RIGHT(DATENAME(YY, @Datetime),2))

    IF (CHARINDEX (‘Month’,@StringDate) > 0)

       SET @StringDate = REPLACE(@StringDate, ‘Month’,

                         DATENAME(MM, @Datetime))

    IF (CHARINDEX (‘MON’,@StringDate COLLATE SQL_Latin1_General_CP1_CS_AS)>0)

       SET @StringDate = REPLACE(@StringDate, ‘MON’,

                         LEFT(UPPER(DATENAME(MM, @Datetime)),3))

    IF (CHARINDEX (‘Mon’,@StringDate) > 0)

       SET @StringDate = REPLACE(@StringDate, ‘Mon’,

                                     LEFT(DATENAME(MM, @Datetime),3))

    IF (CHARINDEX (‘MM’,@StringDate) > 0)

       SET @StringDate = REPLACE(@StringDate, ‘MM’,

                  RIGHT(’0′+CONVERT(VARCHAR,DATEPART(MM, @Datetime)),2))

    IF (CHARINDEX (‘M’,@StringDate) > 0)

       SET @StringDate = REPLACE(@StringDate, ‘M’,

                         CONVERT(VARCHAR,DATEPART(MM, @Datetime)))

    IF (CHARINDEX (‘DD’,@StringDate) > 0)

       SET @StringDate = REPLACE(@StringDate, ‘DD’,

                         RIGHT(’0′+DATENAME(DD, @Datetime),2))

    IF (CHARINDEX (‘D’,@StringDate) > 0)

       SET @StringDate = REPLACE(@StringDate, ‘D’,

                                     DATENAME(DD, @Datetime))   

RETURN @StringDate

END

GO

– Microsoft SQL Server date format function test

– MSSQL formatting dates

SELECT dbo.fnFormatDate (getdate(), ‘MM/DD/YYYY’)           – 01/03/2012

SELECT dbo.fnFormatDate (getdate(), ‘DD/MM/YYYY’)           – 03/01/2012

SELECT dbo.fnFormatDate (getdate(), ‘M/DD/YYYY’)            – 1/03/2012

SELECT dbo.fnFormatDate (getdate(), ‘M/D/YYYY’)             – 1/3/2012

SELECT dbo.fnFormatDate (getdate(), ‘M/D/YY’)               – 1/3/12

SELECT dbo.fnFormatDate (getdate(), ‘MM/DD/YY’)             – 01/03/12

SELECT dbo.fnFormatDate (getdate(), ‘MON DD, YYYY’)         – JAN 03, 2012

SELECT dbo.fnFormatDate (getdate(), ‘Mon DD, YYYY’)         – Jan 03, 2012

SELECT dbo.fnFormatDate (getdate(), ‘Month DD, YYYY’)       – January 03, 2012

SELECT dbo.fnFormatDate (getdate(), ‘YYYY/MM/DD’)           – 2012/01/03

SELECT dbo.fnFormatDate (getdate(), ‘YYYYMMDD’)             – 20120103

SELECT dbo.fnFormatDate (getdate(), ‘YYYY-MM-DD’)           – 2012-01-03

– CURRENT_TIMESTAMP returns current system date and time in standard internal format

SELECT dbo.fnFormatDate (CURRENT_TIMESTAMP,‘YY.MM.DD’)      – 12.01.03

GO

....

In the following post we will see how to select Sql DATE/DATETIME FORMATS by name, Follow me :)

Formating Datetime & Date in Microsoft Sql Server

2013-03-04T23:04:00.004-08:00

Data formats available in SQL Server.

We will start with the conversion options available for sql datetime formats with century (YYYY or CCYY format). Subtracting 100 from the Style (format) number will transform dates without century (YY). For example Style 103 is with century, Style 3 is without century. The default Style values – Style 0 or 100, 9 or 109, 13 or 113, 20 or 120, and 21 or 121 – always return the century (yyyy) format.

– Microsoft SQL Server T-SQL date and datetime formats

– Date time formats – mssql datetime 

– MSSQL getdate returns current system date and time in standard internal format

SELECT convert(varchar, getdate(), 100) – mon dd yyyy hh:mmAM (or PM)

                                        – Oct  2 2008 11:01AM          

SELECT convert(varchar, getdate(), 101) – mm/dd/yyyy - 10/02/2008                  

SELECT convert(varchar, getdate(), 102) – yyyy.mm.dd – 2008.10.02           

SELECT convert(varchar, getdate(), 103) – dd/mm/yyyy

SELECT convert(varchar, getdate(), 104) – dd.mm.yyyy

SELECT convert(varchar, getdate(), 105) – dd-mm-yyyy

SELECT convert(varchar, getdate(), 106) – dd mon yyyy

SELECT convert(varchar, getdate(), 107) – mon dd, yyyy

SELECT convert(varchar, getdate(), 108) – hh:mm:ss

SELECT convert(varchar, getdate(), 109) – mon dd yyyy hh:mm:ss:mmmAM (or PM)

                                        – Oct  2 2008 11:02:44:013AM   

SELECT convert(varchar, getdate(), 110) – mm-dd-yyyy

SELECT convert(varchar, getdate(), 111) – yyyy/mm/dd

SELECT convert(varchar, getdate(), 112) – yyyymmdd

SELECT convert(varchar, getdate(), 113) – dd mon yyyy hh:mm:ss:mmm

                                        – 02 Oct 2008 11:02:07:577     

SELECT convert(varchar, getdate(), 114) – hh:mm:ss:mmm(24h)

SELECT convert(varchar, getdate(), 120) – yyyy-mm-dd hh:mm:ss(24h)

SELECT convert(varchar, getdate(), 121) – yyyy-mm-dd hh:mm:ss.mmm

SELECT convert(varchar, getdate(), 126) – yyyy-mm-ddThh:mm:ss.mmm

                                        – 2008-10-02T10:52:47.513

– SQL create different date styles with t-sql string functions

SELECT replace(convert(varchar, getdate(), 111), ‘/’, ‘ ‘) – yyyy mm dd

SELECT convert(varchar(7), getdate(), 126)                 – yyyy-mm

SELECT right(convert(varchar, getdate(), 106), 8)          – mon yyyy

In the following post we will create a function to convert datetime to string, follow it

SQL Queries for SharePoint Content Database

2013-01-07T02:52:00.001-08:00

We will begin with some of the basic tables:

Features Table that holds information about all the activated features for each site collection or site.
Sites Table that holds information about all the site collections for this content database.
Webs Table that holds information about all the specific sites (webs) in each site collection.
UserInfo Table that holds information about all the users for each site collection.
Groups Table that holds information about all the SharePoint groups in each site collection.
Roles Table that holds information about all the SharePoint roles (permission levels) for each site.
AllLists Table that holds information about lists for each site.
GroupMembership Table that holds information about all the SharePoint group members.
AllUserData Table that holds information about all the list items for each list.
AllDocs Table that holds information about all the documents (and all list items) for each document library and list.
RoleAssignment Table that holds information about all the users or SharePoint groups that are assigned to roles.
SchedSubscriptions Table that holds information about all the scheduled subscriptions (alerts) for each user.
ImmedSubscriptions Table that holds information about all the immediate subscriptions (alerts) for each user.

Some of the common queries that can be used against the content database:
-- Query to get all the top level site collections
SELECT SiteId AS SiteGuid, Id AS WebGuid, FullUrl AS Url, Title, Author, TimeCreated
FROM dbo.Webs
WHERE (ParentWebId IS NULL)

-- Query to get all the child sites in a site collection
SELECT SiteId AS SiteGuid, Id AS WebGuid, FullUrl AS Url, Title, Author, TimeCreated
FROM dbo.Webs
WHERE (NOT (ParentWebId IS NULL))

-- Query to get all the SharePoint groups in a site collection
SELECT dbo.Webs.SiteId, dbo.Webs.Id, dbo.Webs.FullUrl, dbo.Webs.Title, dbo.Groups.ID AS Expr1,
dbo.Groups.Title AS Expr2, dbo.Groups.Description
FROM dbo.Groups INNER JOIN
dbo.Webs ON dbo.Groups.SiteId = dbo.Webs.SiteId

-- Query to get all the users in a site collection
SELECT dbo.Webs.SiteId, dbo.Webs.Id, dbo.Webs.FullUrl, dbo.Webs.Title, dbo.UserInfo.tp_ID,
dbo.UserInfo.tp_DomainGroup, dbo.UserInfo.tp_SiteAdmin, dbo.UserInfo.tp_Title, dbo.UserInfo.tp_Email
FROM dbo.UserInfo INNER JOIN
dbo.Webs ON dbo.UserInfo.tp_SiteID = dbo.Webs.SiteId
-- Query to get all the members of the SharePoint Groups
SELECT dbo.Groups.ID, dbo.Groups.Title, dbo.UserInfo.tp_Title, dbo.UserInfo.tp_Login
FROM dbo.GroupMembership INNER JOIN
dbo.Groups ON dbo.GroupMembership.SiteId = dbo.Groups.SiteId INNER JOIN
dbo.UserInfo ON dbo.GroupMembership.MemberId = dbo.UserInfo.tp_ID
-- Query to get all the sites where a specific feature is activated
SELECT dbo.Webs.Id AS WebGuid, dbo.Webs.Title AS WebTitle, dbo.Webs.FullUrl AS WebUrl, dbo.Features.FeatureId,
dbo.Features.TimeActivated
FROM dbo.Features INNER JOIN
dbo.Webs ON dbo.Features.SiteId = dbo.Webs.SiteId AND dbo.Features.WebId = dbo.Webs.Id
WHERE (dbo.Features.FeatureId = '00BFEA71-D1CE-42de-9C63-A44004CE0104')

-- Query to get all the users assigned to roles
SELECT dbo.Webs.Id, dbo.Webs.Title, dbo.Webs.FullUrl, dbo.Roles.RoleId, dbo.Roles.Title AS RoleTitle,
dbo.UserInfo.tp_Title, dbo.UserInfo.tp_Login
FROM dbo.RoleAssignment INNER JOIN
dbo.Roles ON dbo.RoleAssignment.SiteId = dbo.Roles.SiteId AND
dbo.RoleAssignment.RoleId = dbo.Roles.RoleId INNER JOIN
dbo.Webs ON dbo.Roles.SiteId = dbo.Webs.SiteId AND dbo.Roles.WebId = dbo.Webs.Id INNER JOIN
dbo.UserInfo ON dbo.RoleAssignment.PrincipalId = dbo.UserInfo.tp_ID

-- Query to get all the SharePoint groups assigned to roles
SELECT dbo.Webs.Id, dbo.Webs.Title, dbo.Webs.FullUrl, dbo.Roles.RoleId, dbo.Roles.Title AS RoleTitle,
dbo.Groups.Title AS GroupName
FROM dbo.RoleAssignment INNER JOIN
dbo.Roles ON dbo.RoleAssignment.SiteId = dbo.Roles.SiteId AND
dbo.RoleAssignment.RoleId = dbo.Roles.RoleId INNER JOIN
dbo.Webs ON dbo.Roles.SiteId = dbo.Webs.SiteId AND dbo.Roles.WebId = dbo.Webs.Id INNER JOIN dbo.Groups ON dbo.RoleAssignment.SiteId = dbo.Groups.SiteId AND
dbo.RoleAssignment.PrincipalId = dbo.Groups.ID

-- Query to get all Files by date

SELECT AllLists.tp_Title AS 'List Name',

AllDocs.LeafName AS 'File Name',

AllDocs.[TimeLastModified] AS 'TimeLastModified',

AllDocs.DirName AS 'URL'

FROM AllDocs

JOIN AllLists

ON AllLists.tp_id = AllDocs.ListId WHERE AllDocs.[TimeLastModified]>='2012-01-01' AND AllDocs.Type <> 1 AND (LeafName NOT LIKE '%.stp') AND (LeafName NOT LIKE '%.aspx') AND (LeafName NOT LIKE '%.xfp') AND (LeafName NOT LIKE '%.dwp') AND (LeafName NOT LIKE '%template%') AND (LeafName NOT LIKE '%.inf') AND (LeafName NOT LIKE '%.css')

Accessing list items using the object model

2012-12-23T00:28:00.003-08:00

There are various ways of accessing the List Items (SPListItem) in a List (SPList).

Accessing list items in the same site
SPList.Items foreach
This SPListItem Collection works directly against the underlying SharePoint List (SPList). Any updates made against List Items are updated on the server.

The below code shows enumerating through all List Items in a List.

using (SPWeb web = siteCollection.AllWebs["webname"])
{
SPListItemCollection items = web.Lists["Document Library"].Items;
foreach (SPListItem item in items)
{
Console.Write(item.Title);
}
}

Iterating on Collection Properties of objects with for loop

Please note that when iterating through a list, to reduce underlying calls to the database, be very careful what property you iterate on. Make sure in this example you do not use:
for(int i; i <= web.Lists["Document Library"].Items.Count; i++)
{
Console.WriteLine(web.Lists["Document Library"].Items[i].Title.ToString());
}
This will cause a new SPListItemCollection object everytime the property is accessed. An example of the performance hit on this would be that if the list had 100 items, you would get 200 hits to the database. By instantiating an SPListItemCollection object outside of the foreach loop reduces this significantly.

SPListItemCollection items = web.Lists["Document Library"].Items;
for(int i; i <= items.Count; i++)
{
Console.WriteLine(items[i].Title.ToString());
}
Source: The wrong way to iterate through SharePoint SPList Items by Andreas Grabner

Accessing List Item instances
The below code shows accessing a List Item by its identifier (Int).

using (SPWeb web = siteCollection.AllWebs["webname"])
{
SPList list = web.Lists["Document Library"];
SPListItem item = list.GetItemById(id);
Console.Write(item.Title);
}

Performance mini Case Study
Gopinath Devadasshad an issue with this code pattern using GetItemById and noticed a 30 second to 3 second difference in performance compared to using SPQuery (see below).

The below code shows accessing a List Item by it's unique identifier (Guid).

using (SPWeb web = siteCollection.AllWebs["webname"])
{
SPList list = web.Lists["Document Library"];
SPListItem item = list.GetItemByUniqueId(guid);
Console.Write(item.Title);
}

MSDN Guidance
Please note that it is advised not to use SPList.Items[System.Guid] and SPList.Items[System.Int32] as mentioned in 'Table 1. Alternatives to SPList.Items on the source referenced below'.
Source: MSDN:Best Practices: Common Coding Issues When Using the SharePoint Object Model

SPList.Items foreach with SPQuery
SPList list = SPContext.Current.Web.Lists["Contracts"];
SPQuery query = new SPQuery();
query.Query = string.Format("<Where><Eq><FieldRef Name='ID' /><Value Type='Counter'>{0}</Value></Eq></Where>","407");
SPListItem item = list.GetItems(query)[0];
SPList.Items.GetDataTable()
SPListItemCollection.GetDataTable Method (Microsoft.SharePoint)
Returns a copy of the list items as an ADO.NET DataTable, any updates to the DataTable do not affect the underlying SharePoint List (SPList).

using (SPWeb web = siteCollection.AllWebs["webname"])
{
SPList list = web.Lists["Document Library"];
DataTable table = list.GetItems(list.DefaultView).GetDataTable();
//TODO: enumerate DataTable
}

SPList.Items.GetDataTable() with SPQuery
Returns a copy of the list items as an ADO.NET DataTable, any updates to the DataTable do not affect the underlying SharePoint List (SPList).

PortalSiteMapProvider.GetCachedListItemsByQuery
Requires Microsoft Office SharePoint Server (not WSS) using the Publishing feature. Returns a copy of the list items, any updates to the DataTable do not affect the underlying SharePoint List (SPList).

PortalSiteMapProvider psmp = PortalSiteMapProvider.CurrentNavSiteMapProviderNoEncode;
SPQuery query = new SPQuery
{
ViewFields = "<FieldRef Name='Title' /><FieldRef Name='ID' />",
Query = "", // replace with your CAML query
RowLimit = 10
};
SPListItemCollection listItemNodes = _portalSiteMapProvider.GetCachedListItemsByQuery(
((PortalSiteMapNode)psmp.CurrentNode).WebNode,
"List Title", query, web);

SPWeb.GetListItem(string url)
The SPWeb.GetListItem method allows you to retrieve a list item using its URL:

SPListItem listItem = SPContext.Current.Web.GetListItem(listItemUrl);
Such approach for retrieving list items is extremely useful while working with Publishing Pages with elevated privileges:

SPSecurity.RunWithElevatedPrivileges(delegate() {
using (SPSite site = new SPSite(SPContext.Current.Site.ID))
{
using (SPWeb web = site.OpenWeb(SPContext.Current.Web.ID))
{
string listItemUrl = SPContext.Current.ListItemServerRelativeUrl;
SPListItem listItem = web.GetListItem(listItemUrl);
// do something with the list item
}
}
});

Keep in mind
In spite of being called in the context of a site (web.GetListItem) the GetListItem(string) method requires a server-relative URL in order to retrieve a list item. Providing a site-relative URL will result in a COMException (more information available @ http://blog.mastykarz.nl/inconvenient-spweb-getlistitem-exception-hresult-0x80070001/

List Web Service
See Lists SharePoint Web Service

Accessing list items in multiple sites
Waldek Mastykarz: Performance of content aggregation queries on multiple lists

SPSiteDataQuery
Returns a copy of the list items, any updates to the DataTable do not affect the underlying SharePoint List (SPList).

Source: Chakkaradeep Chandran

StringBuilder queryBuilder = new StringBuilder();
SPSiteDataQuery oQuery = new SPSiteDataQuery();
oQuery.Lists = "<Lists BaseType='1'/>";
oQuery.RowLimit = 100;
oQuery.Webs = "<Webs Scope=\"Recursive\" />";

queryBuilder.Append("<Where><Eq><FieldRef Name=\"UniqueId\" />");
queryBuilder.Append("<Value Type=\"Lookup\">");
queryBuilder.Append("e5d483ac-1c4a-4699-bcd1-dd0bb0455a71");
queryBuilder.Append("</Value></Eq></Where>");

oQuery.Query = queryBuilder.ToString();

DataTable dtResult = web.GetSiteData(oQuery);

More on SPSiteDataQuery
SPSiteDataQuery Samples for WSS v3.0

CrossListQueryCache
Uses the same caching functionality as the Content Query Web Part and similarly requires Microsoft Office SharePoint Server 2007 Standard minimum. Returns a copy of the list items, any updates to the DataTable do not affect the underlying SharePoint List (SPList).

CrossListQueryInfo clqInfo = new CrossListQueryInfo();
clqInfo.Webs = "<Webs Scope='SiteCollection'/>";
clqInfo.Lists = "<Lists ServerTemplate='101'/>";
clqInfo.ViewFields = "<FieldRef Name='Title' /><FieldRef Name='ID' />";
clqInfo.Query = ""; // replace with your CAML query
clqInfo.RowLimit = 10;
clqInfo.UseCache = true;

CrossListQueryCache clqCache = new CrossListQueryCache(clqInfo);
DataTable resultsTable = clqCache.GetSiteData(SPContext.Current.Site);

Query context
David Crabbe explains that only the current site collection can be queried using CrossListQueryCache.

Caching
Jeff Dalton has found that only GetSiteData methods using SPSite parameters are cached (not SPWeb).

MSDN references
CrossListQueryInfo
CrossListQueryCache

Search
Returns a copy of the list items, any updates to the DataTable do not affect the underlying SharePoint List (SPList).

External Links
White Paper: Working with large lists in Office SharePoint® Server 2007 - Extremely good white paper showing the differences in performance of various methods of accessing lists with graphs to prove it!
Measure 48,000 times; Cut once by Scott Singleton Great post on performance based on method used to access List Items.

Original Post by: Jeremy Thake

Convert column data type from multiline to single line in SharePoint 2010

2012-11-19T21:34:00.000-08:00

If you create a SharePoint list by importing a spreadsheet you will find that in SharePoint 2010 all free text columns are converted to the multiline data type by default.

This is a problem if you want to filter the multiline columns in a list by clicking on the column heading because column filtering will only work if the column is a single line data type.

So to change a multiline data type column to a single line do this:

1. Browse to the "List Settings" for the list.

2. Click on the multiline column:

3. Change the Rich Text property to Plain text and press OK. Press OK again when warned:

4. Select the same column again as in step 2.

5. You should now see an option to change the data type to Single line of text. Press OK when done and press OK to the warning:

You can also do this in SharePoint 2010 Designer but you must first change the Rich text setting to Plain text and save the changes, then change from multiline to single line, click off the column, OK the warning then save again.

How to get database records for last 7 days date or last week only

2012-11-08T02:08:00.001-08:00

To get the records for the last 7 days, it would be something like:

select RecordDate, Id
from your_table
where RecordDate > DATEADD(day, -7, GETDATE())

To get the records for the last week only (within the last week not last 7 days)

select RecordDate, Id
from your_table
where RecordDate > DATEADD(day, -7, GETDATE())
and DATEPART(week, RecordDate) = DATEPART(week, GETDATE())

This query will return all records having a date later than 7 days before current date/time.

If you don't want the hours to be taken into account, then try something like this (works only on 2008 due to date datatype cast):

select RecordDate, Id
from your_table
where RecordDate > DATEADD(day, -7, cast(GETDATE() as date))
and DATEPART(week, RecordDate) = DATEPART(week, GETDATE())

Here's the version without the hours for 2005:

select RecordDate, Id
from your_table
where RecordDate > DATEADD(day, -7, CONVERT(datetime, CONVERT(char(10), GETDATE(),
101)))
and DATEPART(week, RecordDate) = DATEPART(week, GETDATE())

That's it :)

Column and View Permissions in SharePoint 2010

2012-11-04T02:25:00.001-08:00

Recently I ran into a codeplex webpart that allows you to specificy column and view permissions for SharePoint 2010.

View permissions disable access to some views on a SharePoint Library or list, and the column permissions hide or set columns to ReadOnly for specified groups. Column permissions work on normal list views, where authenticated users will see columns. Column permissions also apply on the three default SharePoint aspx pages:

EditForm.aspx
NewForm.aspx
DisplayForm.aspx

This feature can be downloaded from http://spcolumnpermission.codeplex.com/

Install instructions and a more in depth description is given on the site. Below is a screenshot from list settings page where the view and the column permission for a list/library can be set up/configured

This Solution is only for SharePoint 2010!

Features:
Column Permission
- Hide or Read Only Columns in a List Forms (New/Edit/Display)
- Hide Columns in Views
- Hide Columns in Alert Me Emails
- Specify the permission for Users, SharePoint Groups or Active Directory Groups

View Permission
- Disable Views
- Hide Views in Context Menus
- Automatically Disable Views in Custom WebPart Zones
- Specify the permission for Users, SharePoint Groups or Active Directory Groups

Column Permission:
1. After successful Installation and Activation on Site Collection you will see two new links in your List/Document Library Settings page.

Top 10 SEO tips for bloggers

2012-10-03T23:03:00.004-07:00

From years of experience in operating mainly WordPress-based blogs, I have learned valuable lessons on how to optimize blogs for search engines and increase traffic to the sites. Here are my Top 10 SEO tips for bloggers; I hope these insightful tips can help improve your blog’s SEO.

1. Conduct proper keyword research and use keywords in your title and content. The title in your home page is the most important place to feature your most important keywords. When you post new articles, keep in mind that most blog platforms will make your article title the HTML title tag as well. Therefore, create your titles with keywords you want to target.

2. Be familiar with your blogging platform to use built-in SEO features. Install additional SEO pluggins. For WordPress, "All in One SEO" or "Platinum SEO" is recommended. They offer many settings that help to create a more SEO-friendly site.

3. Use SEO-friendly URLs. Basically adding keywords in your URLs is a good idea. In WordPress, this is done by turning on a function called "Permalinks."

4. Write original content. Do not copy content from other sites, and if you do, make sure to rewrite it completely to make it your own. More often than not, duplicate content gets filtered by the search engines.

5. Write blog posts on a regular basis and cover the latest topics and trends, which tend to get more traffic while they are hot. Fresh content is part of Google's algorithm.

6. Optimize your image names and alt tags to include keywords for better placement in the image search portion of the search engines.

7. Publish links to your posts on social media sites like Facebook, Twitter and LinkedIn. Also, submit them to social bookmarking sites such as StumbleUpon and Reddit. Social media involvement and links are good for SEO purposes.

8. Build links to your main page and internal posts. If you own several blogs, try to find similar posts and link them to each other.

9. Write guest blog posts on similar sites for link building purposes. A good way to do this is to ask other bloggers to exchange articles, with guest blog credits. You can also participate in link exchange with other bloggers from blogrolls, but in general try to not have too many outgoing links from your own blogroll, as it may reduce the value of your website.

10. Go easy on importing RSS feeds into your blog. While it could be a good source for additional content, you want the majority of your content to be original. If you’re going to use RSS feeds, I recommend keeping it to less than 10 percent of your overall content. If your regular content does not keep up with that ratio, then remove old RSS posts regularly. There was a time when the "Autobloged" plugin for WordPress was being used by many bloggers, or I should say spammy bloggers, with great success. Sites would receive a massive amount of content in little time and would end up getting hundreds of rankings. However, the Panda update makes this difficult.

While there are many more tips I can share with you, the ones I mentioned are my top ten. I hope you enjoyed the article and that the tips can help you to improve your rankings.

Remove Format when copy paste in rich text editor in SharePoint 2010

2012-07-22T01:23:00.003-07:00

How to avoid the formatting that comes along when you copy paste content from a site or word document to the Rich Text Editor (RTE) field in sharepoint? Ofcourse RTE already have an option Clear Formatting that can be used to clear after pasting the content,, but I do not want the format to be copied at first.

So after digging into SP.UI.RTE.js I have come up with a small script that will not paste the markup but only text.

//Disable the RTE paste option. Restricts to "Paste Plain Text"
function disableMarkupPasteForRTE()
{
Type.registerNamespace("RTE");
if (RTE)
{
if(RTE.RichTextEditor != null)
{
RTE.RichTextEditor.paste = function() { RTE.Cursor.paste(true); }
// Handle Ctrl+V short cut options in rich text editor
RTE.Cursor.$3C_0 = true;
}
}
}

I used the below standard sharepoint javascript function that will run the above or any javascript function on load of page.

_spBodyOnLoadFunctionNames.push("disableMarkupPasteForRTE");

The final script will look like this:

<asp:Content ContentPlaceHolderId="PlaceHolderBodyAreaClass" runat="server">
<script type="text/javascript" id="disableMarkupPasteForRTE">
//Disable the RTE paste option. Restricts to "Paste Plain Text"
function disableMarkupPasteForRTE()
{
Type.registerNamespace("RTE");
if (RTE)
{
if(RTE.RichTextEditor != null)
{
RTE.RichTextEditor.paste = function() { RTE.Cursor.paste(true); }
// Handle Ctrl+V short cut options in rich text editor
RTE.Cursor.$3C_0 = true;
}
}
}
_spBodyOnLoadFunctionNames.push("disableMarkupPasteForRTE");
</script>
</asp:Content>

Four Critical Web Design Rules

2012-06-06T03:18:00.001-07:00

"Content is King! If you want a website to generate back-links and have quality content the search engines love, be sure to make it readable by both people and search engines. Search engines are working to give people quality results. Thus, they are looking for sites with quality content. So - by building site content for people, not only are you getting back to basics (information dissemination to people via the Internet), you are creating a site search engines will love. So, build sites for people - and the search engines will come.

When creating a new website or redesigning an existing site, there are four critical rules which should be followed to make the site effective, functional, loved by search engines - and successful.

1. Easy to Read

When building a website, the first thing you need to be sure of is that your website is easy to read. When you write content, remember that most web site visitors don't read every word of a page - in fact, they only scan pages to find what they want.

Break up Your Content

Break up your pages and use headers between major ideas so people scanning your site can find what they want quickly. Use meaningful headers between each paragraph or major idea - this helps with SEO. Headers should be created with the H1 through H4 tags for SEO. Always use good writing structure. Additionally, avoid long paragraphs that run on. You should break up any long paragraphs.

Color and Fonts

To help readability, use high contrast colors between font and background. Black text against a white background may seem stark, but it is very readable. To make a website easy on the eyes, try an off-white background and a dark gray (almost black) text color.

Things to avoid with content color:

Avoid vibrant background colors like purple or yellow. Such back colors make text difficult to read.

Avoid using an image behind your text.

Avoid using bright text colors on bright backgrounds.

Fonts Matter

One simple statement covers the font issue:

Simple fonts are the best; the more fancy the font, the harder it is to read.

Since many browsers only have the standard font set, use standard fonts. In reality, there is no "standard", but there are certain fonts that are installed on most browsers. These include Arial, Verdana, Tahoma and Times New Roman. Your readers will see something different than you see if you use other fonts.

Standard Compliant Browser for Development

When developing and testing your site, use a Standards compliant browser like FireFox. If you develop your site to be standards compliant, it will work in most browsers, including MS Internet Explorer (IE). It is recommended that you test your site using the latest and last browser versions of IE (IE6 and IE7). To run multiple versions of IE on the same machine, TredoSoft.com has a free installer that will install multiple versions of IE. It works great!

Keywords in Content

Of course, when writing content, not only should it be formatted to be readable, but it must also be consumable by not only people, but by search engines. One way to make the subject of the content known to search engines is to use the keywords that people use to search for your site in your content. Be sure to use keywords in your header tags, your first paragraph and throughout your text. The keyword density should be between 4% and 7% - but any more than that could 1) be hard to read and still make sense and 2) be considered spam by search engines and banned. Keywords should also be used in your TITLE tags and your Meta description.

2. Simplify Navigation

The menus and links make up the navigation that the visitor uses to get from page to page in a site. Always plan a site around how people will get from page to page. A visitor to your site should be able to get to what they want within three clicks of their mouse.

Multiple navigation points makes it easy to find things. Repeat the top menu and at the bottom. Also create a left or right menu.

Using links within your text to other areas on your site. You can create links so that they are good for search engine optimization (SEO). There are generally two ways to create links within your text:

The wrong way: "For search engine optimization techniques, click here."

The right way: "Good techniques for search engine optimization are important to use."

Using link text (anchor text) that describes what the link is about is the best way. Search engine web crawlers (programs that automatically index the contents of websites) visit your site, they "read" links. Spiders can index descriptive links into a subject or keyword category. Spiders have nothing to work with when reading a "click here" until it reaches the linked page.

This is Cross Linking - use it as much as possible when it makes sense to do so when writing your content.

3. Consistent Design

At most, one or two layouts should be used in your site design. As a reader browses your site, they should be able to get used to looking in the same place for your navigation, for your sub-navigation and for your content. That's all there is to say about that.

4. Lower Page Weight is Better

Page weight is the total size of a page on your site in bytes - code, text and images. Your site's page weight makes a big difference to your viewers. Lighter page weight is better for your readers because the page will download faster. The faster a page downloads, the faster they will get to the content.

What is Means to be Light

No large images.

Fewer images are better.

Optimize images for the web at no more than 72 dpi

Use as small an image dimension as possible for the given design.

Use a table td bgcolor attribute or a background-color style attribute for solid color backgrounds.

Make gradients horizontal or vertical (not diagonal) so that you can use a small image "strip" and repeat it.

How "Heavy" Should a Web Page be?

Certain studies show that 64K is a good maximum webpage size. 64K is a maximum, however it is still, in my opinion, really big! The smaller the page, the better. 25K is good, 15K is even better. There is a balance between design and function. It is a good idea to focus more on function.

Try putting pages on your web host server as you build your site so you can test it as you go. For pages online, you can test the page weight at www.quasarcr.com/pageweight/ to be sure you are on track.

Ways to make pages lighter:

Use linked style sheets

Use DIVs instead of TABLEs where possible

Use simple repeating backgrounds for effect

Summary

Visitors to your website should be able to find what they are looking for within about three clicks. Search engines should be able to navigate easily through your site. Making a site easy to read with consistent page design, and easy to navigate will make it easy to find information. When people can find information, they are more likely to refer your site or link to it - which is exactly what you want to encourage. You will be on the way to building a readable and hopefully successful website that is loved by search engines if you follow these principals.

Accepting Credit Cards on Your Website

2012-06-06T03:12:00.003-07:00

Are you thinking of selling things on the web? If so, you will probably also be considering some way in which you can accept credit cards on your site. Since new webmasters who visit thesitewizard.com often ask me about how they can get started accepting payments in this form, this article provides some basic information on adding credit card payment facilities to your website.

(Note: if you do not already have a website, you may also want to read How to Create / Make a Website: The Beginner's A-Z Guide.)

Why Do It?

Credit card payments allow you to take advantage of the following types of customers:

Impulse buyers
After reading your advertisements and hype on your site, buyers would be all fired up about your product. If they have a means of making a purchase immediately, you've secured that sale. If you only allow cheque payments, the additional time it takes for them to get their cheque book and mail out the cheque may be a deterrence. They may also have second thoughts later.
International customers
Credit card payment is a tremendous convenience if your customers are overseas. It automatically takes care of the problems of currency differences as well as the time it takes for a cheque to travel to the vendor. You will lose a large number of overseas customers if cheque payment is the only way you can accept payment.

Methods of Accepting Credit Card Payments

There are actually two ways in which you can accept credit cards on your site.

Using Your Own Merchant Account
To do this, you will need a bank that will allow you to open a merchant account. Requirements for this will vary from country to country, and you should check with your local banks for more information on this.
Through a Third Party Merchant
There are numerous companies around that are willing to accept credit cards payments on your behalf in exchange for various fees and percentages. These are also known as "payment gateways".

Which Method Should You Use?

The initial costs of opening your own merchant account is usually higher than when you use a third party merchant. Indeed, some third party merchants have no setup fee at all.
However, the transaction fee (which is what you pay the bank or third party merchant for each sale) is much higher when you use a third party as compared to when using your own merchant account.
A third party merchant is usually convenient to use when you don't know if you can actually make much out of your product or service. If you just want to test the water to see how things are, this is usually a good way to start. It is also convenient in that the merchant takes care of everything for you. You just get a cheque at the end of each payment period (if you have earned enough) and concentrate on your products, services and customers. Another benefit is that if you use a reputable third party merchant, your visitors may be more willing to buy your goods online since they trust that merchant to keep their credit card numbers safe.
Having your own merchant account lowers your transaction costs. However, you have to be careful to minimize your credit card risks since you'll be processing the credit card payments yourself. This is not to say that there are no risks attendant in using a third party merchant.

Some Third Party Merchants / Payment Gateways

Here's a list of some third party merchants that you might want to consider if you're looking for ways to accept credit card payments. Except for PayPal, I have not actually tried any of them myself (as a vendor). Check them out carefully and use them at your own risk.
Note that rates and stuff that I publish below were correct at the time I investigated these vendors. It will most likely have changed by the time you read this since the merchants tend to modify their rates from time to time according to market conditions. Make sure that you check the current (up-to-date) details from their site before making any decision.
The list is arranged alphabetically.
CCBill: There are no setup fees. Transaction fees vary (I can't find the schedule though) depending on the volume of sales in each accounting period. According to their website, "these fees are never more than 13.5% of revenues charged during this one-week period for CWIE hosting clients and 14.5% for non-hosting clients".
CCNow: This is only for people who ship tangible, physical products. There is no setup fee, and they charge 9% per transaction except in the November and December where the fees are 8% per transaction (yes, lower).
Google Checkout: Google has its own payment gateway that is available for US and UK sellers. It is mainly for use if you are selling tangible and digital goods, although you can also use it to charge for services and subscriptions. Charges range from 1.9% + $0.30 USD to 2.9% + $0.30 USD per transaction, depending on the volume of sales in the previous month. If your buyer is not from your country (ie, not in the US if you are in the US, or not in the UK if you are in the UK), there is also another 1% processing fee.
Kagi: Kagi's fees seem to vary according to the order size, type of item sold and the type of payment (credit card, cash, money order) used by your customer.
PayPal: This well-known service allows you to set up a Premier or Business account (you are subject to certain limits when receiving credit card payments if you use a Personal account, and probably also higher fees per transaction). The charges range between 1.9% + $0.30 USD to 2.9% + $0.30 USD for each transaction if you are in the US. Non-US users are charged different amounts according to the country. From experience, I find this service easy and fast to setup.
ProPay: A new competitor to PayPal (see elsewhere on this page) that currently only caters to US residents. Depending on the type of account you sign up for, you have to pay an annual fee (starting from $34.95) as well as transaction fees of 3.5% + $0.35 USD. However, to accept cards like American Express and Discover, you have to use their more expensive plans.
RegNow: Designed for software authors to sell their ware, this merchant charges a one-time activation fee of $19.95 USD plus a transaction fee of 6.9% plus $1 USD per unit for their commission (minimum $2 USD charge). They also provide you with facilities that allows you to easily set up an affiliate program.

How to Put an Order Form or Shopping Cart on Your Website

Once you have signed up the vendor of your choice, you will be able to put an order form or shopping cart on your site. Each vendor has a different method for this, but most, if not all, will provide you with premade forms that you can customize for your product or service.
(Note: if you use PayPal, and don't know where to start, see my tutorial How to Put an Order Form or Buy Now Button on Your Website Using PayPal for a step-by-step guide.)

Trying It Out

Whichever you choose, if you are selling things on the Internet, you really have not much choice but to accept credit cards. You probably don't know what you missed until you try it out.
All the best for your business!

This article can be found at http://www.thesitewizard.com/archive/creditcards.shtml

Where are the Documents or files we uploaded or attached stored in SharePoint?

2012-06-06T02:44:00.001-07:00

Many of them know, those files are stored under SharePoint Content Database. But on which database table, on which format?

For that, i did a quick research on that, and here i give those results,

The AllDocStreams table in SharePoint Content Database stores the Document Contents.
The Contents of the document are stored in Content Column in the AllDocStream table.
The Content column is the Image Datatype, (stores in the format of Binary).

I provide a simple SQL Query to retrieve the Document List Name,File Name, URL, and the Content (Binary Format)

SELECT AllLists.tp_Title AS ‘List Name’,
AllDocs.LeafName AS ‘File Name’,
AllDocs.DirName AS ‘URL’,
AllDocStreams.Content AS ‘Document Contnt (Binary)’
FROM AllDocs
JOIN AllDocStreams
ON
AllDocs.Id=AllDocStreams.Id
JOIN AllLists
ON
AllLists.tp_id = AllDocs.ListId

How to Choose a Web Host

2012-06-05T00:41:00.000-07:00

by Christopher Heng, thesitewizard.com

What are some of the things you should look for when choosing a web host? The criteria for choosing a free web host and a commercial web hosting solution are slightly different although they do overlap. Since thesitewizard.com caters to people who might be looking for either of these types of hosting, I will deal with each of these in turn. If you are only interested in one of these types, you can simply skip to the appropriate section. I have written these sections to be as independant of the other as possible.

Choosing a Free Web Host

Advertising
Most free web hosts impose advertising on your website. This is done to cover the costs of providing your site the free web space and associated services. Some hosts require you to place a banner on your pages, others display a window that pops up everytime a page on your site loads, while still others impose an advertising frame on your site. There is really no hard and fast rule which is to be preferred: some people hate a pop-up window, other webmasters dislike having to stuff banner codes onto their pages, and many people cannot stand an advertising frame (which may cause problems when you submit your website to search engines). Whichever method is used, check that you're comfortable with the method.
Note that free web hosts without forced advertisements aren't necessarily good news. Without a viable means to recover the costs of running their server, such hosts close with alarming frequency.
Amount of web space
Does it have enough space for your needs? If you envisage that you will expand your site eventually, you might want to anticipate future expansion. Most sites use less than 5MB of web space. Indeed, at one time, one of my other web sites, thefreecountry.com, used less than 5MB of space although it had about 150 pages on the site. Your needs will vary, depending on how many pictures your pages use, whether you need sound files, video clips, etc.
FTP access
FTP is the most common method used by people to transfer their web pages and other files from their computer to their web host's computer, so that it can be viewed by anyone in the world.
Some free hosting providers only allow you to design your page with their online site builder. While this is useful for beginners, do you have the option to expand later when you become experienced and their online page builder does not have the facility you need? Online site builders also have significant disadvantages, a subject which I discuss at length in my article comparing online site builders with standalone web editors.
FTP access, or at the very least, the ability to upload your pages by email or browser, is needed. Personally, I feel FTP access is mandatory, except for the most trivial site.
File type and size limitations
Watch out for these. Some free hosts impose a maximum size on each of the files you upload (including one with a low of 200KB). Other sites restrict the file types you can upload to HTML and GIF/JPG files. If your needs are different, eg, if you want to distribute your own programs on your pages, you will have to look elsewhere.
Reliability and speed of access
This is extremely important. A site that is frequently down will lose a lot of visitors. If someone finds your site on the search engine, and he tries to access it but find that it is down, he'll simply go down the list to find another site. Slow access is also very frustrating for visitors (and for you too, when you upload your site). How do you know if a host is reliable or fast? If you can't get feedback from anyone, one way is to try it out yourself over a period of time, both during peak as well as non-peak hours. After all, it is free, so you can always experiment with it.
PHP and/or Perl
(In case you're wondering: What is PHP and Perl?)
It's quite possible for a website to work even without PHP or Perl access. For example, you can always use one of the many free script hosting services available that provide counters, search engines, forms, polls, mailing lists, etc, without requiring you to dabble with Perl or PHP scripts.
However if you really want to do it yourself, with the minimum of advertising banners from these free providers, you will need either PHP or Perl access. Note that it is not enough to know they provide PHP or Perl access: you need to know the kind of environment your scripts run under: is it so restrictive that they are of no earthly use? For PHP scripts, does your web host allow you to use the mail() function, which allows your scripts to send email? For Perl scripts, do you have access to sendmail or its workalike?
Bandwidth allotment
Nowadays, many free web hosts impose a limit on the amount of traffic your website can use per day and per month. This means that if the pages (and graphic images) on your site is loaded by visitors beyond a certain number of times per day (or per month), the web host will disable your web site (or perhaps send you a bill). It is difficult to recommend a specific minimum amount of bandwidth, since it depends on how you design your site, your target audience, and the number of visitors you're able to attract to your site. In general, 100MB traffic per month is too little for anything other than your personal home page and 1-3GB traffic per month is usually adequate for a simple site just starting out. Your mileage, however, will vary.

Choosing a Commercial Web Host

Reliability and speed of access
Not only should the web host be reliable and fast, it should guarantee its uptime (the time when it is functional). Look for a minimum uptime of 99%. In fact, even 99% is actually too low — it really should be 99.5% or higher. The host should provide some sort of refund (eg prorated refund or discount) if it falls below that figure. Note though that guarantees are often hard to enforce from your end — especially if the host denies there was any downtime. However, without that guarantee, the web host will have little incentive to ensure that its servers are running all the time.
Data Transfer (Traffic/Bandwidth)
Data transfer (sometimes loosely referred to as "traffic" or "bandwidth") is the amount of bytes transferred from your site to visitors when they browse your site.
Don't believe any commercial web host that advertises "unlimited bandwidth". The host has to pay for the bandwidth, and if you consume a lot of it, they will not silently bear your costs. Many high bandwidth websites have found this out the hard way when they suddenly receive an exorbitant bill for having "exceeded" the "unlimited bandwidth". Always look for details on how much traffic the package allows. I personally always stay clear of any host that advertises "unlimited transfer", even if the exact amount is specified somewhere else (sometimes buried in their policy statements). Usually you will find that they redefine "unlimited" to be limited in some way.
In addition, while bandwidth provided is something you should always check, do not be unduly swayed by promises of incredibly huge amounts of bandwidth. Chances are that your website will never be able to use that amount because it will hit other limits, namely resource limits. For more details, see the article The Fine Print in Web Hosting: Resource Usage Limits.
To give you a rough idea of the typical traffic requirements of a website, most new sites that are not software archives or provide video or music on their site use less than 3 GB of bandwidth per month. Your traffic requirements will grow over time, as your site becomes more well-known (and well-linked), so you will need to also check their policy when you exceed your data transfer limit: is there a published charge per GB over the allowed bandwidth? Is the charge made according to actual usage or are you expected to pre-pay for a potential overage? It is better not to go for hosts that expect you to prepay for overages, since it is very hard to forsee when your site will exceed its bandwidth and by how much.
Disk space
For the same reason as bandwidth, watch out also for those "unlimited disk space" schemes. Many new sites (that don't host videos or music) need less than 20 MB of web space, so even if you are provided with a host that tempts you with 100 GB (or "unlimited space"), be aware that you are unlikely to use that space, so don't let the 100 GB space be too big a factor in your consideration when comparing with other web hosts. The hosting company is also aware of that, which is why they feel free to offer you that as a means of enticing you to host there. As a rough gauge, thefreecountry.com, which had about 150 pages when this article was first written, used less than 5 MB for its pages and associated files.
Technical support
Does its technical support function 24 hours a day, 7 days a week (often abbreviated 24/7), all year around? Note that I will not accept a host which does not have staff working on weekends or public holidays. You will be surprised at how often things go wrong at the most inconvenient of times. Incidentally, just because a host advertises that it has 24/7 support does not necessarily mean that it really has that kind of support. Test them out by emailing at midnight and on Saturday nights, Sunday mornings, etc. Check out how long they take to respond. Besides speed of responses, check to see if they are technically competent. You wouldn't want to sign up for a host that is run by a bunch of salesmen who only know how to sell and not fix problems.
FTP, PHP, Perl, SSI, .htaccess, telnet, SSH, MySQL, crontabs
If you are paying for a site, you really should make sure you have all of these.
Note that some commercial hosts do not allow you to install PHP or Perl scripts ("What is PHP and Perl?") without their approval. This is not desirable since it means that you have to wait for them before you can implement a feature on your site. ".htaccess" is needed if you are to do things like customize your error pages (pages that display when, say, a user requests for a non-existent page on your site) or to protect your site in various ways (such as to prevent bandwidth theft and hotlinking, etc).
Telnet or SSH access is useful for certain things, including testing certain scripts (programs), maintaining databases, etc. MySQL ("What is MySQL?") is needed if you want to run a blog or a content management system. Cron is a type of program scheduler that lets you run programs at certain times of the day (eg, once a day). Check to see if these facilities are provided.
SSL (secure server), Shopping Cart
If you are planning on doing any sort of business through your website, you might want to look out to see if the host provides these facilities. These facilities normally involve a higher priced package or additional charges. The main thing is to check to see if they are available at all before you commit to the host. You will definitely need SSL if you want to collect credit card payments on your site.
Email, Autoresponders, POP3, Mail Forwarding
If you have your own site, you would probably want to have email addresses at your own domain, like sales@yourdomain.com, etc. Does the host provide this with the package? Does it allow you to have a catch-all email account that causes any email address at your domain to be routed to you? Can you set an email address to automatically reply to the sender with a preset message (called an autoresponder)? Can you retrieve your mail with your email software? Can it be automatically forwarded to your current email address?
Control Panel
This is called various names by different hosts, but essentially, they all allow you to manage different aspects of your web account yourself. Typically, and at the very minimum, it should allow you to do things like add, delete, and manage your email addresses, and change passwords for your account. I would not go for a host where I have to go through their technical support each time I want to change a password or add/delete an email account. Such chores are common maintenance chores that every webmaster performs time and time again, and it would be a great hassle if you had to wait for their technical support to make the changes for you.
Multiple Domain Hosting and Subdomains
For those who are thinking of selling web space or having multiple domains or subdomains hosted in your account, you should look to see if they provide this, and the amount extra that they charge for this (whether it is a one-time or monthly charge, etc).
Server
Is the type of operating system and server important? Whether you think so or not on the theoretical level, there are a few practical reasons for looking out for the type of server.
In general, if you want to use things like write/use ASP programs, you have no choice but to look for a Windows server.
Otherwise my preference is to sign up for accounts using the often cheaper, more stable and feature-laden Unix systems running the Apache server. In fact, if dynamically generated pages that can access databases (etc) is what you want, you can always use the more portable (and popular) PHP instead of tying yourself down to ASP. Another reason to prefer Unix-based web hosts (which include web hosts using systems like Linux, FreeBSD, OpenBSD, Solaris, etc) using the Apache web server is that these servers allow you to configure a lot of facilities that you typically need on your site (error pages, protecting your images, blocking email harvesters, blocking IP addresses, etc) without having to ask your web host to implement them. Knowledge about configuring Apache servers is also widely available, and can be found on thesitewizard.com's Configuring Apache and .htaccess pages as well.
For those interested, you can read another discussion on the matter in the "Should You Choose a Linux or a Windows Web Hosting Package? Is There Such a Thing as a Mac Web Host?" article.
Price
I was actually hesitant to list this, but I guess it's futile not to. However, I would caution that while price is always a factor, you should realise ("realize" in US English) that you often get what you pay for, although it's not necessarily true that the most expensive hosts are the best.
Monthly/Quarterly/Annual Payment Plans
Most web hosts allow you to select an annual payment plan that gives you a cheaper rate than if you were to pay monthly. My current personal preference is to pay monthly with all new web hosts until I'm assured of their reliability and honesty. Paying monthly allows me to switch web hosts quickly when I find that the current host does not meet my requirements: this way, I'm not tied down to a bad web host because I have prepaid for an entire year. I do this even if the new web host guarantees that they will refund the balance if I'm dissatisfied, since at the point I sign up, I have no assurance that they will honour their guarantee. Later (usually after a couple of years), when I'm satisfied with the host, I may change payment plans to the discounted annual plans.
Resellers?
Not all hosting companies own or lease their own web servers. Some of them are actually resellers for some other hosting company. The disadvantage of using a reseller is the possibility that you are dealing with people who don't know much about the system they are selling and who take longer to help you (they have to transmit your technical support request to the actual hosting company for it to be acted upon). However, this also depends on both the reseller and the underlying hosting company. It is thus wise not to rule out all resellers; there are a number of reliable and fast ones who are actually quite good and cheap. In fact, a number of resellers sell the same packages cheaper than their original hosting company. If you find out that a particular company is a reseller, you will need to investigate both the reseller and the real hosting company.
International
If you don't stay in the USA, you have the option of hosting your site with some local provider. The advantage here is the ease of dealing with them (they are after all easily accessible by phone call or a visit), your familiarity with the local laws and easy recourse to those laws should it be necessary. It should be your choice if your target audience is local (eg a local fast food delivery service). On the other hand, hosting it in USA has the advantage of faster access for what is probably the largest number of your overseas visitors (particularly if you have an English-speaking audience). You also have a large number of hosting companies to choose from, and as a result, cheaper prices too.
Others' Reviews
You should make it a point to check out what others have to say about the web host. Some of the places you can do this include:
- The newsgroup news:alt.www.webmaster. As you should always do when reading reviews (of anything), read the reviews posted here with a pinch of salt. Some glowing reviews may come from people working for the web host itself, disguised as multiple satisfied customers. Likewise, negative reviews of a particular host can sometimes come from unscrupulous competitors of that host.
- thesitewizard.com's review, "Which Web Host Would You Recommend? (FAQ)", found at http://www.thesitewizard.com/archive/webhosting.shtml
- Although not often, I sometimes make comments about a particular web host in my Budget Web Hosts page on thefreecountry.com as well.
Don't skip this step, or you might find yourself being suckered by a host that everyone else is steering clear of.

The Myth of the Perfect Commercial Host

In general, I doubt that there are any "perfect" web hosting companies around. Note that even if you are prepared to pay a huge price for your hosting needs, it does not guarantee that your host is any good. This is an interesting industry where a high price does not necessarily yield quality hosting and support.

On the other hand, one thing you can probably be sure of is that you will not get top-notched support if you only pay (say) $5 a month. At that price, which company can afford to hire enough good help to cater to all its users?

Like me, you'll probably end up settling for a trade-off between price, reliability and features that you're willing to live with.

Capacity Planning for Windows SharePoint Services

2012-06-04T23:27:00.002-07:00

This topic describes performance and scalability guidelines for Microsoft Windows SharePoint Services. The goal is to provide administrators with the information they need to purchase hardware, choose a server configuration, and manage the capacity of their Windows SharePoint Services deployments.

There are two kinds of capacity guidelines for Windows SharePoint Services:

Throughput — The approximate number of transactions per second that a given server configuration for Windows SharePoint Services can handle. This guideline helps you determine how many simultaneous users can use a given server resource without negatively affecting performance.
Scale — The approximate number of objects that can be created in a given scope, for example, the number of documents per folder. This guideline helps you determine the server configuration required to host a given number of objects.

About Capacity and Throughput Guidelines

The goal of the throughput testing is to measure the number of transactions per second that a server running Windows SharePoint Services can handle. The measured throughput is then used to extrapolate the number of simultaneous users by using a model of typical user behavior.

A rough rule of thumb is that 1 transaction per second maps to 1000 users. This rule of thumb is derived by applying the following model for user behavior:

1000 users

10% peak concurrency

100 simultaneous users (10% of 1000)

100 seconds per request per user (36 requests per hour per user)

100 simultaneous users/100 seconds per user per transaction
1 transaction/second

CAPACITY TESTING METHODOLOGY

The Windows SharePoint Services team tests throughput by using automated load generation tools that work in machine time, not user time. In other words, real user behavior is not modeled in the test lab; server capacity is measured using fictitious "super users" who issue requests as fast as the server can respond. This is done to ensure that we’re measuring the capacity of the server, not the capacity of the load generation tool.

There are two main variables in the throughput testing:

Transaction mix — The mix of user transactions, such as browse home page, save document, and edit list item, and so on.
Server configuration — The configuration, such as a single server or a server farm with two Web servers, and so on.

About the Transaction Mix

The transaction mix defines the types and frequency of operations seen by the server, such browse home page, edit document, and so on. This topic contains two different transaction mixes:

Read/write — This is the typical SharePoint site operation mix. Most of the load is browsing to pages and documents in the site, but there is a substantial amount of list and document authoring as well. For details on the read/write operation mix, see Tested Read/Write Transaction Mix.
Read only — This is the typical load of a reference site where the data on the server is changing very slowly. For this mix, the entire test load is on the home page of the site. The home page is one of the most expensive pages to render, so this is a fairly conservative read-only load.

About the Server Configuration

The server configuration describes how computers are configured to run the site. Windows SharePoint Services supports a server farm design where multiple Web servers can be used to serve the same content, as in the following illustration.

Administrators can add capacity to both the Web server and database server tiers by adding more server computers to the server farm. The total capacity of the server farm depends on the number of Web servers, the number of database servers, and the ratio of Web servers to database servers.

The following configurations were tested:

Single computer — One computer running both the Web server and database server.
N-by-one server farm — One to eight computers running the Web server and a separate computer running the database server. This covers the most common server farm scenarios. These tests determine the marginal throughput increase for each additional Web server and the optimum ratio of Web servers to database servers. As the test results show, adding Web servers to the server farm adds capacity linearly until the fourth or fifth Web server. Beyond five Web servers for each database server, the system bottleneck becomes the database server. To add even more capacity you need to add a database server to the server farm.
Eight-by-two server farm — Eight Web servers and two database servers. This test validates the database scale out. An 8x2 server farm has roughly twice the total throughput as a 4x1 server farm. Extending the scale out model to 12x3 and 16x4 becomes a matter of providing sufficient network bandwidth for the server farm.

For the test hardware specifications, see Tested Hardware and Software.

About Throughput to Users

The Windows SharePoint Services performance lab found the peak throughput for each combination of transaction mix and server configuration. The throughput is measured in transactions per second. These transactions-per-second measurements can be converted to the total number of users using a model of typical end-user behavior. Like many human behaviors, there is a broad range of "typical" behavior. The user model for Windows SharePoint Services has two variables:

Concurrency — The maximum percentage of the total user base who will be using the system simultaneously. The Windows SharePoint Services models all use 10% concurrency.
Request rate — The number of requests per hour an active user generates on average. Windows SharePoint Services uses four models for user behavior:

Light — 20 requests per hour. An active user will generate a request every 180 seconds. Each response per second of throughput supports 180 simultaneous users and 1,800 total users.
Typical — 36 requests per hour. An active user will generate a request every 100 seconds. Each response per second of throughput supports 100 simultaneous users and 1,000 total users.
Heavy — 60 requests per hour. An active user will generate a request every 60 seconds. Each response per second of throughput supports 60 simultaneous users and 600 total users.
Extreme — 120 requests per hour. An active user will generate a request every 30 seconds. Each response per second of throughput supports 30 simultaneous users and 300 total users.

THROUGHPUT DATA

The following table shows the throughput results for each transaction mix, server configuration, and user model. The peak throughput point is highlighted in bold.

	TRANSACTIONS PER SECOND		TOTAL USER COUNT
			Light		Typical		Heavy		Extreme
Configuration	Mix	Read	Mix	Read	Mix	Read	Mix	Read	Mix	Read
Single Server	34	43	61,200	77,400	34,000	43,000	20,400	25,800	10,200	12,900
1 by 1	65	70	117,000	126,000	65,000	70,000	39,000	42,000	19,500	21,000
2 by 1	121	132	217,800	237,600	121,000	132,000	72,600	79,200	36,300	39,600
3 by 1	156	194	280,800	349,200	156,000	194,000	93,600	116,400	46,800	58,200
4 by 1	161	256	289,800	460,800	161,000	256,000	96,600	153,600	48,300	76,800
5 by 1	164	279	295,200	502,200	164,000	279,000	98,400	167,400	49,200	83,700
6 by 1	157	278	282,600	500,400	157,000	278,000	94,200	166,800	47,100	83,400
7 by 1	163	280	293,400	504,000	163,000	280,000	97,800	168,000	48,900	84,000
8 by 1	153	279	275,400	502,200	153,000	279,000	91,800	167,400	45,900	83,700
8 by 2	-	462	-	831,600	-	462,000	-	277,200	-	138,600

The following chart shows that adding additional Web servers to a single database server farm increases the capacity of the server farm, but only to a certain point. For the read-only transaction mix, the capacity of the server farm increases steadily for up to four Web servers and stops increasing at six Web servers. For the read/write mix, the capacity does not increase significantly beyond three Web servers.

Total capacity does not increase because the throughput is now limited by the one database server computer. Extending capacity beyond this point requires adding another database server to the server farm.

The following chart shows that adding an additional database server to the farm can extend the total capacity of the farm if there are sufficient web servers to handle the load.

About Capacity and Scale Guidelines

The capacity of Windows SharePoint Services is also affected by scalability (how many objects can be created in a given scope, such as number of documents per folder). There are very few hard limits in Windows SharePoint Services. Most of the scale guidelines are determined by performance. In other words, you can exceed these guidelines, but you may find the resulting performance to be unacceptable.

One of the most important scale dimensions is site collections per database. This scale dimension depends on the number of indexes on the database. As the number of site collections increases, the performance of the system degrades as it serves more and more different site collections. As you can see in following chart, there is no hard limit where performance becomes unacceptable, but performance does degrades faster beyond 10,000 site collections and drops below 100 responses per second beyond 50,000 site collections.

The other scale guidelines are shown in the following table. None of these are hard limits enforced by the system. They are guidelines for designing a server that has good overall performance.

OBJECT	SCOPE	GUIDELINE FOR OPTIMUM PERFORMANCE	COMMENT
Site collections	Database	50,000	Total throughput degrades as the number of site collections increases.
Web sites	Web site	2,000	The interface for enumerating subsites of a given Web site does not perform well much beyond 2,000 subsites.
Web sites	Site collection	250,000	You can create a very large total number of Web sites by nesting the subsites. For example, 100 sites each with 1000 subsites is 100,100 Web sites.
Documents	Folder	2,000	The interfaces for enumerating documents in a folder do not perform well beyond a thousand entries.
Documents	Library	2 million	You can create very large document libraries by nesting folders.
Security principals	Web site	2,000	The size of the access control list is limited to a few thousand security principals, in other words users and groups in the Web site.
Users	Web site	2 million	You can add millions of people to your Web site by using Microsoft Windows security groups to manage security instead of using individual users.
Items	List	2,000	The interface for enumerating list items does not perform well beyond a few thousand items.
Web Parts	Page	100	Pages with more than 100 Web Parts are slow to render.
Web Part personalization	Page	10,000	Pages with more than a few thousand user personalizations are slow to render.
Lists	Web site	2,000	The interface for enumerating lists and libraries in a Web site does not perform well beyond a few thousand entries.
Document size	File	50 MB	The file save performance degrades as the file size grows. The default maximum is 50 MB. This maximum is enforced by the system, but you can change it to any value up to 2 GB (2047 MB) if you have applied Windows SharePoint Services Service Pack 1. For more information, see Configuring large file support in Installing and Using Service Packs for Windows SharePoint Services.

Tested Read/Write Transaction Mix

The following table describes the mix of operations that make up the read/write transaction mix. The Windows SharePoint Services team counted only meaningful end-user operations in the throughput numbers, but the load on the server includes supporting transactions as well, such as getting the images, style sheets, and JavaScript files for the home page.

END USER OPERATION	PERCENTAGE
Get home page	9.0%
Get list page (HTML)	9.0%
Get list page (grid)	9.0%
Get list form	6.0%
Get static document	15.0%
Insert list item	1.5%
Edit list item	1.5%
Delete list item	1.5%
Insert document	1.5%
Open document for edit	1.5%
Save document	1.5%
Delete document	1.5%
List URLs	1.5%
Short term check-out	15.0%
Get cached document	15.0%
404 errors	10.0%

NOTE There are roughly two supporting transactions for each end-user transaction. In other words, the end-user operations make up about a third of the total transaction load on the server.

Tested Hardware and Software

The following hardware was used to gather the performance and scalability data in this topic.

WEB SERVERS

The Web server computers were Compaq DL360s with two 1 GHz Pentium 3 processors and 1 GB of memory. The computers were running a prerelease version of Microsoft Windows Server 2003, Enterprise Edition, build 3718.

NOTE The single computer tests were run on Web server hardware.

DATABASE SERVERS

The database server computers were Compaq DL380s with two 1 GHz Pentium 3 processors and 2 GB of memory. The computers were running Microsoft SQL Server 2000 SP2 and a prerelease version of Windows Server 2003, Enterprise Edition, build 3718.

Reference: http://office.microsoft.com/en-us/windows-sharepoint-services-it/capacity-planning-for-windows-sharepoint-services-HA001160774.aspx

Work with multiple Exchange and SharePoint calendars in one SharePoint calendar

2012-02-14T01:04:00.003-08:00

A SharePoint calendar enables you to work with multiple Exchange and SharePoint calendars at the same time. For example, a group calendar is helpful when you schedule a team meeting, because you can see the Exchange calendars of team members and SharePoint calendars of resources, such as conference rooms, in one group calendar view.

Add multiple SharePoint and Exchange calendars to a SharePoint calendar

Use the following procedure to create a view of multiple SharePoint and Exchange calendars for a SharePoint calendar. A view for a calendar can display a maximum of ten calendars.
Note To change calendar settings, you must have at least the design permission level for the site.

In a SharePoint calendar, in the ribbon, on the Calendar tab, click Calendar Overlays.
In the Calendar Overlay Settings page, click New Calendar.

To add a SharePoint calendar

In the Name and Type section, type the Calendar Name and then select SharePoint.
In the Calendar Overlay Settings section, type a Description for the calendar (optional), and change the Color theme for the calendar (optional).

Tip Selecting different colors for different calendars makes it easier to distinguish which calendar an event is from.

Type the Web URL for the SharePoint site that the calendar is in, such as https://contoso.com/TWGroupWorkSite/calendar, and then click Resolve. If the calendar is in the same site as the group calendar, Web URL will already be populated accurately.
Click the List drop-down arrow and select the calendar that you want to add to the calendar.
Click the List View drop-down arrow and select the view that you want to use for the calendar.
If you want this SharePoint calendar to always display in the SharePoint group calendar, select Always Show.

To add an Exchange calendar

In the Name and Type section, type the Calendar Name and select Exchange.
In the Calendar Overlay Settings section, type a Description for the calendar (optional), and change the default Color theme for the calendar (optional).

Tip Selecting different colors for different calendars makes it easier to distinguish which calendar an event is from.

Click Find. Outlook Web Access URL and Exchange Web Service URL will be filled in automatically. If Find does not work in your environment, type the URLs manually
If you want this Exchange calendar to always display with the SharePoint group calendar, select Always Show.

Click OK and then click OK again.

Following is an example of the day view of the Team group calendar, overlaying Aamir and Connie’s calendars.

Reference: http://office.microsoft.com/en-us/sharepoint-foundation-help/work-with-multiple-exchange-and-sharepoint-calendars-in-one-sharepoint-calendar-HA101777171.aspx?CTT=1

SharePoint Server, MOSS, SharePoint Development, Collaboration

Correct Permissions to Update WordPress installed on IIS

How to fix: Cannot connect to WMI provider. You do not have permission or the server is unreachable

Change the Display Order for a User Property in SharePoint User Properties with PowerShell

Fixed: Unable to start User profile sync service ,stuck at Starting - in SharePoint server 2013

PLESK: How-to change subscription expiry to unlimited via command line in

How to Activate Subscription via command line in PLESK for windows

How to update year only in a date datatype

Fixing a SharePoint 2010 Stuck Timer Job

How to Create a Minimal Master Page

To create a minimal master page

Select Sql Date / DateTime Formats By Name

How to Create SQL Server Date Formatting function

Formating Datetime & Date in Microsoft Sql Server

Data formats available in SQL Server.

SQL Queries for SharePoint Content Database

Accessing list items using the object model

Convert column data type from multiline to single line in SharePoint 2010

How to get database records for last 7 days date or last week only

Column and View Permissions in SharePoint 2010

Top 10 SEO tips for bloggers

Remove Format when copy paste in rich text editor in SharePoint 2010

Four Critical Web Design Rules

Accepting Credit Cards on Your Website

Why Do It?

Impulse buyers

International customers

Methods of Accepting Credit Card Payments

Using Your Own Merchant Account

Through a Third Party Merchant

Which Method Should You Use?

Some Third Party Merchants / Payment Gateways

How to Put an Order Form or Shopping Cart on Your Website

Trying It Out

Where are the Documents or files we uploaded or attached stored in SharePoint?

How to Choose a Web Host

by Christopher Heng, thesitewizard.com

Choosing a Free Web Host

Advertising

Amount of web space

FTP access

File type and size limitations

Reliability and speed of access

PHP and/or Perl

Bandwidth allotment

Choosing a Commercial Web Host

Reliability and speed of access

Data Transfer (Traffic/Bandwidth)

Disk space

Technical support

FTP, PHP, Perl, SSI, .htaccess, telnet, SSH, MySQL, crontabs

SSL (secure server), Shopping Cart

Email, Autoresponders, POP3, Mail Forwarding

Control Panel

Multiple Domain Hosting and Subdomains

Server

Price

Monthly/Quarterly/Annual Payment Plans

Resellers?

International

Others' Reviews