Debugging 101: A SharePoint Developer's Guide to Learn and Prepare for interviews

Problem We have SharePoint server 2007 connected to the production environment with the SQL Data base name WSS_Content_P. Due to some technical changes we by mistake triggered the Production Front end to the Test environment Database that is WSS_Content_T . Here the Test database was just the replica of the production database with difference of 2 days. Now after some days we got to know that such a problem has been created. We found that business data of 2 days was missing from the database. Solution : In the End we came to solution to any how sync the two databases. Now we needed the best database comparison tool to check the data from the two database server. Tool Used :  VISUAL STUDIO Internal Tool : SQL > DATA COMPARE ·          Click the Data compare option in visual studio. ·          Provide the connection to both the databases, one will be source and other will be the destination. · ...

Health Analyzer Review problems and solutions  Here we can check for the problem in the SharePoint server. These problems may include the details of low memory, high memory usage .There are many different ways by which these problems can be resolved. Review rule definitions  Here we can see different rules that are used to manage the rule definition. Timer Jobs   Review job definitions  Here we can review job definition i.e. hoe different jobs are scheduled with details of on which web application which timer job is running .these job can be clean up of logs list, trimming of log details, deletion of dead sites in web application.   Check job status    It is divided into three section scheduled, running and history .It shows when and how different services are executed on the server.   Reporting View administrative reports  Default document library of SharePoint used for managing the administrative reports. These reports may include da...

Central administration is a graphical interface utility to perform various functions related to SharePoint. These functions are classified as: 1. Application Management: Enables  user to manage web application, service application , create site collection and content database. 2. System Setting: Enables user to manage server, services and farm features. It also enables to configure alternate access mapping. 3. Monitoring: Enables user to review problems and solutions, web analytic report and check Job status. 4. Backup and restore: Backup and Restore enables user to perform backup, Restore from a backup and a site collection backup. 5. Security: Security enables user to manage the farm administrators group and Configure service accounts. 6. Upgrade and Migration: Upgrade and Migration enables user to convert farm license type, Check product and patch installation status And Check upgrade status 7. General Application Settings: General Application Settings enables...

SharePoint is very easy to install, just click few next buttons and it`s installed. To perform the SharePoint installation easily, various activities prior to installation needs to be performed. These activities are part of “Capacity Planning and management” activity.   SharePoint installation/deployment scenarios can be classified as: 1.  Standalone Installation : Most of the small enterprises prefer standalone installation scenario. This scenario enables user to install, SharePoint and SQL database on one physical server or virtual machine. 2.  Complete Installation : Most of the mid or large size, enterprise prefer farm installation scenario. The server farm installation can be performed as: ·            Multiple Server Installation : Add all the components installed on different servers with ability to add more servers as per need. Single Server Installation : Install all the components on single server  ...