SharePoint By Gaurav Goyal

Hi, Prepare for Exam 70-332 - and help demonstrate your real-world mastery of  Microsoft   SharePoint   Server  2013. Designed for experienced IT Professionals ready to advance their status, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSE level. Download ebook for 70-332

Hi, Prepare for Exam 70-331 - and help demonstrate your real-world mastery of  Microsoft   SharePoint   Server  2013 core solutions. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSE level. Download free ebook for 70-331

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

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.

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”