Posts

My Sites Web Part

Image
Here people wanted to see a web part which can show my sites on which current user have access permission. I searched in SharePoint but I didn't find any out of the box web par for the same purpose. So created My Sites Web Part for our internal use. I have created 2 view of the web part with some different kind of settings: 1.    Show My Sites in Tree View 2.    Show My Sites in View Download My Sites Webpart Download Document

WSS_Logging database

Truncate WSS_Logging database with this script : 1. Open SQL Server with "Run as Administrator" 2. Right click on WSS_Logging database & click on New Query. 3. Copy & paste below given script.       DECLARE @TableName AS VARCHAR(MAX) DECLARE table_cursor CURSOR FOR SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME LIKE '%_Partition%' OPEN table_cursor FETCH NEXT FROM table_cursor INTO @TableName WHILE @@FETCH_STATUS = 0 BEGIN DECLARE @SQLText AS NVARCHAR(4000) SET @SQLText = 'TRUNCATE TABLE ' + @TableName EXEC sp_executeSQL @SQLText FETCH NEXT FROM table_cursor INTO @TableName END CLOSE table_cursor DEALLOCATE table_cursor 4. Run this query. 5. Than shrink this database.

PowerShell Command to Export Sub Site

Export site with these option. This will include all customizations, user securities, list & libraries etc. Export-SPWeb -Identity http://sharepoint-demo/IC -Path " c:\bkup\IC.cmp " -Force -IncludeUserSecurity -IncludeVersions All Note : ·          http://sharepoint-demo/IC : You can change this site url. Put url of site which is going to be backed up. ·          C:\backup\IC.cmp : You can change backup path with file name. You have to keep extention .cmp as it is. More information about “Export-SPWeb”

What is Managed Path in SharePoint

Let’s understand what is path first. In SharePoint you have seen some different types of site collection urls within same Web Application like : ·         http://sharepointDemo ·         http://sharepointDemo/subsite ·         http://sharePointDemo/Subsite/SubSubsite ·         http://SharePointDemo/Sites/Contoso ·         http://SharePointDemo/Sites/Contoso/SubSite These different kind of URL structure called path & you can manage these path as per you your organization hierarchy or architecture. Some time you required to create a site collection with name of “Departments” & under this “Department” you might want to create some departments like HR, IT etc. and you want your site collection url should be like http://SharePointDemo/Departments/HR . Managed path is this. Where you can manage site collection path not whole url. Here you can Manage Path for the selected Web Application. In other words, when you creates your first site collection in Web Application you have to provid

Update for Microsoft Project Server 2013 (KB2768001)

Applies: Project Server 2013; SharePoint Server 2013 Due to a change in the package configuration introduced after SharePoint 2013 RTM the March Public update is a mandatory requirement in order to install subsequent SharePoint Updates. Download from Microsoft

Get web.config file in timer job

I was working on timer job & wanted to get data from sql server. To achive this goal, I add my database connection string in web application’s web.config file. Now I used the following code to get web.config setting from timer job : private string getConnectionString()         {             return System.Configuration.ConfigurationManager.AppSettings["MyAppSettingKey"];        } But this code was not able to get the web.config file. Why? I started some R & D on it & found that Time Job runs under OWSTimer.exe & Web Application runs under W3WP.exe. As the context of  Both are different so we have to use WebConfigurationManager to get specific SharePoint Web Application configuration. private string getConnectionString(string webAppName)         {             System.Configuration.Configuration webConfiguration = WebConfigurationManager.OpenWebConfiguration("/", webAppName);             return webConfiguration.App

What is Managed Path

Let’s understand what is path first. In SharePoint you have seen some different types of site collection urls within same Web Application like : http://sharepointDemo http://sharepointDemo/subsite http://sharePointDemo/Subsite/SubSubsite http://SharePointDemo/Sites/Contoso http://SharePointDemo/Sites/Contoso/SubSite These different kind of URL structure called path & you can manage these path as per you your organization hierarchy or architecture. Some time you required to create a site collection with name of “Departments” & under this “Department” you might want to create some departments like HR, IT etc. and you want your site collection url should be like http://SharePointDemo/Departments/HR . Managed path is this. Where you can manage site collection path not whole url. Here you can Manage Path for the selected Web Application. In other words, when you creates your first site collection in Web Application you have to provide site collection url un

Download ebook : SharePoint Designer Tutorial

Download ebook Book Description SharePoint is a web-based collaboration and document management platform from Microsoft.  Microsoft   Office   SharePoint  Designer (SPD) is a WYSIWYG HTML editor and web design program, which has replaced FrontPage, and is the ideal environment for working with pages on a SharePoint site. This book is ideal for people new to SharePoint Designer who need to put together a working SharePoint site as quickly as possible. If you who want to get started, and finished, as quickly as possible, this book is for you. You won't just learn how to use SharePoint Designer; you'll see how to use it to put together a SharePoint site. Book Details Publisher: Packt Publishing By: Mike Poole ISBN: 978-1-84719-442-8 Year: 2008 Pages: 188 Language: English File size: 5.3 MB File format: PDF

Shortcut Keys for Visual Studio

Hi All, You can get shortcut keys of all kind of Visual Studio from Microsoft's site. Here is the link of site : http://msdn.microsoft.com/en-us/library/da5kh0wa.aspx

Download ebook - PMP Training Kit

Download ebook - PMP Training Kit Book Description Ace your preparation for the skills measured by the updated PMP Exam, aligned with the Guide to the Project Management Body of Knowledge (PMBOK Guide), Fifth Edition. Work at your own pace through a series of lessons and reviews that fully cover each exam task. Then, reinforce what you've learned by applying your knowledge to real-world case scenarios and practice exercises. This guide is designed to help make the most of your study time. Book Details Publisher: Microsoft Press By: Sean Whitaker ISBN: 978-0-73565-780-9 Year: 2013 Pages: 544 Language: English File size: 86.1 MB File format: PDF Download ebook - PMP Training Kit