08 December, 2012

Migrating From SharePoint 2007 to SharePoint 2013, Part 1 & Part 2

Migrating From SharePoint 2007 to SharePoint 2013, Part 1
Business and technical reasons for skipping SharePoint 2010 by SharePoint expert Dan Holme who shares tips, how-to's, ideas, and news about all things SharePoint, and more
Migrating from SharePoint 2007 to SharePoint 2013, Part 2
Skipping 2013? You might want to reconsider that strategy  by SharePoint expert Dan Holme shares tips, how-to's, ideas, and news about all things SharePoint, and more.
ü  Microsoft planning SharePoint version 15
ü  Reduce the pain of upgrading
ü  Aim for a logical architecture
The Essential Guide to Achieving High Availability for SharePoint Data: Download Now:
Reference: SharePointpromag.

07 December, 2012

Webpart Chrome type is not working or Webpart Title is not working: SharePoint

Webpart Chrome type is not working or  Webpart Title is not working: SharePoint
Today one of my user complained that she was not able to set the title of her web parts on various pages on her site.  When setting the chrome type to ‘Title’ it set it back to none, when we hit apply and Ok o the web part page. Hence leading to a problem of Webpart Chrome type is not working as expected.
- We tried setting chrome type to other types. No luck.
- We tried changing the various properties of the Webpart, but no luck.
- While researching on the internet I came across an article which says that forcibly changing the
we implemented the same on the effected page and it doesn’t correct the problem.
- One of the article talks about the problem with the webpart zone, when comparing the webpart zone of the webpart with other webpart on the other sites, it was showing only one webpart zone= main.
This article talks about the resolution but doesn’t show how to do it. http://www.novolocus.com/2009/05/29/webpart-titles-not-shown-in-webpartzone
To do this, Open the site in SPD, go to faulty page, and open the page in the coding mode. Look for the webpart page main property.

Change the ID of the webpart to anything other than “Main”. It would bring back the tittles on the webpart. I am not sure why this issue problem had occurred but now it has corrected the problem.

Another Post which talks about the same issue: http://stackoverflow.com/questions/5455893/override-chrome-type-webpart
If you have questions/queries, do let me know. I would be more happy to help you.

05 December, 2012

Back up customizations in SharePoint Server 2010

Customizations are of different kinds when it comes to SharePoint, below is small descriptions.

  • Customizations packaged as solutions (.wsp files). Solutions contain developed site elements, and are typically created by developers. Developed site elements include the following:
    • Web Parts
    • Workflows
    • Site and list definitions
    • Document converters
    • Event receivers
    • Timer jobs
    • Assemblies
  • Authored site elements, which are typically created by Web designers, are not explicitly compiled and reside in a content database. Authored site elements include the following:
    • Master pages
    • Cascading style sheets
    • Forms
    • Layout page

  • Changes to the Web.config file
  • Third-party solutions and their associated binary files and registry keys, such as IFilters
  • Changes to sites created by direct editing through the browser
  • Developed customizations that are not packaged as solutions
Each of these kinds of customizations requires a different type of backup.
In this article:
Ref: technet.microsoft.com

cloud computing tutorials

cloud computing training

Cloud computing interview questions

What is cloud computing?
The cloud computing is the computing which is completely based on the Internet. It can also be defined as the next stage in the evolution of the Internet. It is a service-based model of providing software as a service, where the customer does not have to implement, install or maintain the necessary hardware for using a software. It is sold as a service - much like how we use a taxi or a hotel room without owning it.

What are the concerns prevailing around cloud computing?
Security of data is the topmost concern in the consumers' minds.

How can these concerns be addressed?
By offering a more expensive - private cloud - solution, a customer's data is isolated from the public. Virtual private clouds can also be implemented. Lastly, a poorest measure against security is client-partitioning in a public cloud.

Please refer the following references which will help you to get the knowledge on Cloud Computing:

sharepoint developer interview questions

Explain the WebPart life cycle.
WebPart life cycle also same as asp.net life cycle. Here you can find some additional events like CreateChildControls, RenderContents etc.

·         OnInit
·         OnLoad
·         CreateChildControls
·         OnPreRender
·         Render (RenderContents, etc)

What are Site Columns?
Site columns are pre-defined data columns (along with default values) which are re-used in various content types. A Content type is usually a collection of site columns.

When should you dispose SPWeb and SPSite objects? And even more important, when not?
You should always dispose them if you created them yourself, but not otherwise. You should never dispose SPContext.Current.Web/Site and you should normally not dispose SPWeb if IsRootWeb is true.

How does Client object model works?
When we use SharePoint client API’s to perform a specific task, the SharePoint Foundation 2010 managed client object model bundles up these uses of the API into XML and sends it to the server that runs SharePoint Foundation. The server receives this request, and makes appropriate calls into the object model on the server, collects the responses, forms them into JavaScript Object Notation (JSON), and sends that JSON back to the SharePoint Foundation 2010 managed client object model. The client object model parses the JSON and presents the results to the application as .NET Framework objects (or ECMAScript objects for ECMAScript).

What is difference between Load() and LoadQuery() methods ?
Load method populates the client object directly with what it gets data from the server i.e. a collection object like ListItemCollection etc. but LoadQuery returns the data as a completely new collection in  IEnumerable format. Other major difference is that the Collections that you load using the Load() method are eligible for garbage collection only when the client context variable itself goes out of scope where as, in  these collections go out of scope at the end of  IEnumerable<List> list.

What is Business Data Catalog or BDC?
It is a shared service that enables Office SharePoint Server 2007 to display business data from various back-end servers into a SharePoint page. Business Data Catalog or BDC provides built-in support for displaying data with various web parts and list\list columns that can help in easy creation of dashboards with data from your SQL, web services, SAP, Siebel, or any other line-of-business (LOB) applications.

Where are Master Pages and Layout Pages located in a SharePoint site?
They are location in master Page(Master Page Gallery) under _catalogs folder of root site.

What is the Difference between Master Pages and Layout Pages in SharePoint.
Master pages and page layouts dictate the overall look and feel of your SharePoint site.

Differences are
·         Master pages contain controls that are shared across multiple page layouts,
such as navigation,search, or language-preference for multilingual sites.
Page layouts contain field controls and Web Parts.
·         Page layouts can be used by all page instances that are based on that
page layout.Master pages can be used by all page instances in a site.

What is a Site definition?
A Site definition is a collection of Files such as ONET.XML which defines the Site template for e.g. Team Sites used to create a Site in SharePoit. All the out-of-box site Templates like Blog,Wiki,Team Site etc can be found in C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\

What is a Site Template?
Any Site along with the content can be saved as a template. If a site is saved as a Template it is stored in Site templates folder as a .stp file. This template is then re-used to create a new site which will have the pre-saved settings.

What are content types?
A content type is a flexible and reusable template of type list item or document that defines the columns and behavior for an item in a list or a document in a document library. For example, you can create a content type for a Requirement document with a columns such LOE,Version,Approver,Date Created,Date Revised etc and this can be re-used in various document libraries.

What are the Authentication methods for your client object model application?

Basically there are three (3) authentication options you can use when you’re working with the Client Object Model in SharePoint 2010:
·         Anonymous
·         Default
·         Forms Authentication

Please let me know in case of any queries/questions. I would be more than happy to help you as well as resolves your issues, Thank you

04 December, 2012

Stored Procedures in SQL Server.

A stored procedure is a group of Transact-SQL statements compiled into a single execution plan. SQL Stored procedures return data in four ways:
  • Output parameters, which can return either data (such as an integer or character value) or a cursor variable (cursors are result sets that can be retrieved one row at a time).
  • Return codes, which are always an integer value.
  • A result set for each SELECT statement contained in the stored procedure or any other stored procedures called by the stored procedure.
  • A global cursor that can be referenced outside the stored procedure
Why to use stored procedures in SQL server:
  • Execution plan retention and reuse
  • Query auto-parameterization
  • Encapsulation of business rules and policies
  • Application modularization
  • Sharing of application logic between applications
  • Access to database objects that is both secure and uniform
  • Consistent, safe data modification
  • Network bandwidth conservation
  • Support for automatic execution at system start-up
  • Enhanced hardware and software capabilities
  • Improved security
  • Reduced development cost and increased reliability
  • Centralized security, administration, and maintenance for common routines
How to create Stored Procedure in SQL:
1.   In Object Explorer, connect to an instance of SQL Server Database Engine and then expand that instance.
2.   Expand Databases, expand the database in which the stored procedure belongs, and then expand Programmability.
3.   Right-click Stored Procedures and then click New Stored Procedure.
4.   On the Query menu, click Specify Values for Template Parameters.
5.   In the Specify Values for Template Parameters dialog box, the Value column contains suggested values for the parameters. Accept the values or replace them with new values, and then click OK.
6.   In the query editor, replace the SELECT statement with the statements for your procedure.
7.   To test the syntax, on the Query menu, click Parse.
8.   To create the stored procedure, on the Query menu, click Execute.
9.   To save the script, on the File menu, click Save. Accept the file name or replace it with a new name, and then click Save.

          -- SET NOCOUNT ON added to prevent extra result sets from
          -- interfering with SELECT statements.
          SET NOCOUNT ON;

          -- Insert statements for procedure here
          SELECT VendorId,VendorFName,VendorLName,VendorCity,VendorState,VendorCountry,PostedDate,
          FROM Vendor Where VendorState = @VendorState ORDER BY PostedDate
There are some different concepts of stored procedures.
  • A stored procedure is one or more SQL statements that have been compiled and stored with database. A stored procedure can be started by application code on the client.
  • Stored procedure can improve database performance because the SQL statements in each procedure are only compiled and optimized the first time they are executed. In contrast SQL statements that are sent from a client to the server have to be compiled and optimized every time there are executed.
  • In addition to SELECT statement, a stored procedure can contain other SQL statements such as INSERT, UPDATE, and DELETE. It also contains control-of-flow language.
  • A trigger is a special type of procedure that executes when rows are inserted, updated or deleted from table.
  • A user defined function (UDF) is a special type of procedure that can return a value or a table. 

03 December, 2012

Plan for disaster recovery (SharePoint Server 2010)

Disaster recovery overview
For the purposes of this article, we define disaster recovery as the ability to recover from a situation in which a data center that hosts SharePoint Server becomes unavailable.
The disaster recovery strategy that you use for SharePoint Server must be coordinated with the disaster recovery strategy for the related infrastructure, including Active Directory domains, Exchange Server, and Microsoft SQL Server. Work with the administrators of the infrastructure that you rely on to design a coordinated disaster recovery strategy and plan.
The time and immediate effort to get another farm up and running in a different location is often referred to as a hot, warm, or cold standby. Our definitions for these terms are as follows:
Hot standby A second data center that can provide availability within seconds or minutes.
Warm standby A second data center that can provide availability within minutes or hours.
Cold standby A second data center that can provide availability within hours or days.
Disaster recovery can be one of the more expensive requirements for a system. The shorter the interval between failure and availability and the more systems you protect, the more complex and costly a disaster recovery solution is likely to be. When you invest in hot or warm standby data centers, costs include:
  • Additional hardware and software, which often increase the complexity of operations between software applications, such as custom scripts for failover and recovery.
  • Additional operational complexity.
Reference: technet.microsoft.com

02 December, 2012

Trick to Fresh Install Of Windows XP in 10 Minutes.

As you all know formatting and fresh Installation of Windows XP or any other MS O.S is a lengthy and boring Process but we all have to do it, sometimes in a month and sometimes in a week. It is a 40-60 minutes long process.
But friends today I will Show You how to format and fresh Install XP in Just 10 minutes.
So Let’s take a look, to perform a clean installation of Windows XP, follow these steps:

Start your computer from the Windows XP CD. To do this, insert the Windows XP CD into your CD drive or DVD drive, and then restart your computer.

Note to boot from your Windows XP CD, the BIOS settings on your computer must be configured to do this.

When you see the "Press any key to boot from CD" message, press any key to start the computer from the Windows XP CD.

At the Welcome to Setup screen, press ENTER to start Windows XP Setup.

Read the Microsoft Software License Terms, and then press F8.

Follow the instructions on the screen to select and format a partition where you want to install Windows XP.

Above all is only a normal process that you all are familiar with. The main part begins from here.
1: After the copy part is over, yours system is rebooted as we all know in general formatting procedure.
2. After reboot an image will appear. Now as the Image appears, you have to press "Shift + F10", this will open the command prompt.
3. Type TASKMGR in command prompt. This will open the Task Manager.
4. After the task manager Opens Go to Processes- &gt; Find "Setup.exe" process and Right click on It-&gt; Set the priority to highest.

5. Just wait and watch, the set-up will be completed in 2 minutes to 9 minutes. This varies from system to system performance.
Note: I have not given it a try to MS other O.S such as windows Server 2003, Server 2008, Server 2012, Windows 7 and Windows 8. Try this and share your comments.
If you have any queries/questions regarding the above mentioned information then please let me know, Thank you.

Solution Package retracting stuck: SharePoint 2007

Problem: We were planning to deploy a new solution for one of our web application. However, as we all know we have to first retract the solution from the web application and for that we use the stsadm command line given below,
stsadm -o retractsolution -name solutionName.wsp –immediate
followed by STSADM -o execadmsvcjobs
We have waited for min 20 min, but after refreshing the CA for many times we have seen the solution was stuck in retract state.
Troubleshooting: We checked the status ofWindows SharePoint Services Solution Retraction for’ timer job and It was successful for all of the servers we have in the environment.
To check the status of the above timer service,
1. Go to Central Administration
2. Navigate to Operations &gt; "Global Configuration" &gt; "Timer job status".
3. Look for Jobs name starting with either "Windows SharePoint Services Solution Retraction for".
Resolution: we have tried running ‘execadmsvsjobs’ STSADM command.
STSADM -o execadmsvcjobs ( On all the servers )  
To all of the servers in the env. And refreshing CA the status of the solution package was ‘not deployed’.
Some other things you can also try to resolve the problems are.
Ø  Restarting the OWSTIMER Service.
Ø  Deleting the Job Timer Definition for some reasons resolves it.
Ø  Restarting the machine and try one more time.
If you have any queries/questions regarding the above mentioned information then please let me know, Thank you.

How To Setup Direct LAN Connection Using Bluetooth

You may come in the situation when you’ve two computers but no WiFi adapters in it. In such condition you can try cheap method to share files between two computers using Bluetooth. In this tutorial I am going to teach you how to achieve such heights.
To allow file and Printer sharing names each computer with a unique name but give both computers the same workgroup name. You can do this from the System Properties window. To open System Properties, go to My computer, right click on any blank area and choose properties. Or simply you can right click on my computer icon and choose properties.

In Computer Name tab click Change to input your computer name and workgroup name. You will be asked to restart your computer after the computer name and workgroup change.

The computer name defined in this step becomes the Bluetooth device name for this computer that will be displayed on another computer this computer is discovered.

Now plug in Bluetooth adapters to both of your computer. Make sure that Bluetooth device is properly installed on both of your PC’s properly by going to device manager.

Verify that the Bluetooth adapter is identified as a Bluetooth Network Connection under Personal Area Network with Microsoft’s Bluetooth stack driver while on the second computer with third-party Bluetooth stack driver; it is identified as a Local Area Connection under LAN or High-Speed Internet.

Make the second Bluetooth-enabled computer discoverable by going to Bluetooth settings and configure its “service properties” to include PAN Networking service.

In the first computer, right click on Bluetooth taskbar icon and select “Join a Personal Area Network” to open Bluetooth Personal Area Network window.

You can also do this by going to Network Connections and right-clicking the icon and select “View Bluetooth Network Devices” or clicking View Bluetooth Network Devices link on the left sidebar.

On the Bluetooth Personal Area Network window, click “Add” to open the “Add Bluetooth Device Wizard” if the second computer hasn’t been connected before.

Now we’re done with setting up the basic things. Now we’ll have to pair the devices.
On the Add Bluetooth Device Wizard, tick “My device is set up and ready to be found”. Click Next.

Wizard will search for Bluetooth devices in range.

Select the second computer and click next.

You will be asked to input a passkey or PIN code before starting a connection to the second computer. You can create your own passkey or let Windows create a random passkey for you. Click Next.

On the second computer, you will be prompted to input a passkey. Type the same passkey as the one created on the first computer and cick OK.

If the everything went well, you’ll be welcomed to next page with Finish button enabled. Click Finish. You will be back to the Bluetooth Personal Area Network window. Now the second computer is listed under Direct Connections. Select it and click Connect to start a Personal Area Network connection.

Now, both computers have been directly connected in a Personal Area Network. First computer with Microsoft stack is the Client while the second one with Thirdparty stack is the host.

Now you can share files same like in LAN but with slower bandwidth

Hope this tutorial was helpful.