Dear All if you are facing and issue for out of memory in sharepoint because of wss_logging database here is a script Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue Set-SPUsageDefinition -Identity "Sandboxed Requests" -DaysRetained 3 Set-SPUsageDefinition -Identity "Content Import Usage" -DaysRetained 3 Set-SPUsageDefinition -Identity "Workflow" -DaysRetained 3 Set-SPUsageDefinition -Identity "Clickthrough Usage" -DaysRetained 3 Set-SPUsageDefinition -Identity "Content Export Usage" -DaysRetained 3 Set-SPUsageDefinition -Identity "Page Requests" -DaysRetained 3 Set-SPUsageDefinition -Identity "Feature Use" -DaysRetained 3 Set-SPUsageDefinition -Identity "Search Query Usage" -DaysRetained 3 Set-SPUsageDefinition -Identity "Site Inventory Usage" -DaysRetained 3 Set-SPUsageDefinition -Identity "Sandboxed Requests Monitored Data" -DaysRetained 3 Set-SPUsageDefinit...

Dear All,  Here is a way to make the custom content type in SharePoint Designer  Regards  Rashid Imran Bilgrami 

Dear All, Some time I hate the IE because of pathetic behavior  If you are facing an issue that when you edit the sharepoint page in client with IE you will not able to see the page layout structure with the Webpart zones than make sure the URL will register under the compatible list for registering please follow the following step 1) Open IE 2) Click on the Setting wheel icon and select Compatible view settings 3) Add the URL in the list Refresh your page That's it Regards Rashid Imran Bilgrami  

Dear All,  If you miss the Page Layout Go to Site Actions -> Site Settings in the upper left corner. Under "Site Collection Administration" click on "Site Collection Features". Look for "SharePoint Server Publishing Infrastructure" and activate it. It might take a moment to load. Next return to "Site Settings" and click on "Manage Site Features" Look for "SharePoint Server Publishing" and activate it. It might take a moment to load. Regards Rashid Imran Bilgrami 

Dear All Below are the steps for the Exporting & importing list from development to deployment machine How to export the list from development enviroment Open the list  Go to list settings Click on " Save list as template " Define the File Name, Template Name and description (If you want data click on include checkbox)  One you save click on the "list template gallery" Select the export list and click on "Download As a Copy" under document tab  Save the file How to import the list in deployment enviroment Go to Parent site settings  Click on List Templates Under Galleries Section Click on Upload Document under " Documents " Tab Upload and save Click on "View All Site Content" (SP 2010) ...for (SP 2013) Go to settings > Site Content Click "Create" button  And Select the Imported Template  I hope it save your time  Regards  Rashid Imran Bilgrami    

here is the way that you can get the view in your list using (SPSite site = new SPSite(yoursiteUrl)) { if (site != null) { using (SPWeb web = site.OpenWeb()) { SPList list = web.Lists["ListName"]; if (list != null) { SPListItemCollection coll = web.Lists["ListName"].GetItems(web.Lists["ListName"].Views["ViewName"]); foreach (SPListItem item in coll) { //do something //if you are testing on console application Console.WriteLine(item.Title.ToString()); } } web.Close(); } site.Close(); } } Regards  Rashid Imran Bilgrami 

Dear All,  Here is a solution for initialize control error while compiling or building the solution through VS... The solution is not using an existing or valid URL, by checking the SharePoint URL please make sure that the URL is valid and exists, try to map the URL and build your solution and check the result if the error still exists. Regards Rashid Imran Bilgrami

Dear All,  If you are facing a problem to deploy SharePoint through one way, Than Here I am writing different  ways to deploy the Customized Web Part Under SharePoint Portal Here we go....  When you are done developing a WebPart, you need to deploy it to the SharePoint server. However, depending on your server setup, you may have to use specific deployment methodology and that is why it is important to know your options. This post describes different ways to achieve this goal. Basic understanding Whatever method you use to develop your WebPart, you will always end up with a WebPart DLL and in some cases you will have WSP file (both of these files are in debug folder of your project). It is the DLL file that plays a key role in getting your WebPart inside SharePoint server. Ways to deploy a WebPart There are more ways but i mentioned here four ways we can deploy a WebPart on SharePoint server that I will cover in this post: Using Visual Studio to dep...

Dear All, Today i got an issue that Problem Assemblies that implement asp .net web parts and are installed in partially trusted location which is some how like that Here is a solution  Go to Your Visual studio project  Go to Project "Properties" folder  Click on the AssemblyInfo.cs  and add the following line [assembly:AllowPartiallyTrustedCallers]  Rebuild & Deploy Your Solution  Regards  Rashid Imran Bilgrami

Dear All,  I found a very nice CAML query builder it makes your like very easy to identify the column names  http://www.u2u.be/Software   http://www.camldesigner.com/?p=594  The another tool for advance query writing i found https://www.biwug.be/resources Regards  Rashid Imran Bilgrami

I tried to open document library with explorer in SharePoint 2013 that already enabled but when click on it. The following Warning message shown ! To enable the open with explorer please follow the bit steps mentioned below: Open Server Manager –> Manage –> Add Roles and Features Select Features form the left step navigation –> User Interfaces and Infrastructure –> Desktop Experience Click Next then Install Restart Server Go to Services by click Run –> Services.msc –> Start WebClient Service. Go back to your doucment library   The following dialog will appear to you click don’t show it again then Allow Great it’ working Enjoy :)