How to Enable Document IDs in SharePoint 2010

The document ID feature creates identifiers that can be used to retrieve items independent of their current location. The document ID service that supports it generates and assigns document IDs.

Microsoft explains:

-Document ID’s are automatically assigned to uploaded documents and this ID will follow the item throughout its entire life cycle. Document IDs can also be assigned to Document Sets.

- Document ID’s are automatically assigned to uploaded documents and this ID will follow the item throughout its entire life cycle. Document IDs can also be assigned to Document Sets.

How to activate it:

1.   Open the site that you are referring to

2.   Site actions

3.   Site settings

4.   Site collection administration

5.   Site collection features

6.   Activate the service named as ‘Document ID’

Note: it will be activated for the complete site collection.

How to enable it:

1.   Go to the site collection

2.   Site actons

3.   Site settings

4.   Site collection administration

5.   Document ID settings

6.   On the Document ID settings page, in the Assign Document IDs section, make sure there is a checkmark in the Assign Document IDs, check box.

7.   As soon as you enable the assignment of Document IDs for the first within a site collection, a message appears: Configuration of the Document ID feature is scheduled to be completed by an automated process. This means that a timer job is responsible for completing the assignment of the Document IDs to all documents in the site collection.

8.   To set a custom string of characters or numbers that are automatically appended to the beginning of each Document ID, enter the string under Begin IDs with…

Example:

a)   Begin ID’s with the following charators section, type the text as per your requirement. For example purpose, I am using SharePoint2010

b)   Click OK

c)   Open Word 2010 and create a new document and save it as follows:

·         Document Name: SharePoint hits.docx

·         Document Content: SharePoint Sample Text

·         Save Document to Desktop

d)   Navigate to the document library now

e)   Click upload document now

f)    Click the Upload Document button on the page and browse to the location of the SharePoint hits document on the desktop and click OK.

g)   In the Managed Keywords type Rocks, then click Save

h)   Make sure that the document is checked in

i)     Click Refresh

Select the Reset all Document IDs… check box if you want to automatically add the prefix to all existing Document IDs in your site collection.

Click OK and that’s it-Document ID has been successfully enabled for the site collection.

If you have any Queries |Questions |Doubts regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, thank you J J

Reference:
http://www.sharepointanalysthq.com/2010/04/document-id-feature

http://sharepointrecordsmanagement.com/2010/06/02/sharepoint-2010-document-ids

This workbook cannot be opened because it is not stored in an Excel Services Application trusted location

One of our user has opened a ticket with us by mentioning that he is getting an error while editing the date in excel. the error message is mentioned below:

This workbook cannot be opened because it is not stored in an Excel Services Application trusted location.
To create an Excel Services Application trusted location, contact your system administrator
Now its quite obvious that you need to add the document library path inside excel trusted file location.

Please refer following article and your issue will be resolved J
http://sharepointknowledgebase.blogspot.com/2011/12/excel-services-sharepoint-2010-trusted.html

If you have any queries/questions/doubts regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank youJ

excel services sharepoint 2010 trusted location

Workbooks that you want to access must be placed in a trusted location. If they are not, calls to open the workbooks will fail.

How to add a file to trusted file location:

1.On the Start menu, click All Programs.
2.Point to Microsoft SharePoint 2010 Products, and then click SharePoint 2010 Central Administration.
3.On the SharePoint 2010 Central Administration page, under Application Management, click Manage service applications.
4.On the Manage Service Application page, click Excel Services Application.
5.On the Manage Excel Services Application page, click Trusted File Locations.
6.On the Excel Services Application Trusted File Locations page, click Add Trusted File Location.
7.On the Excel Services Application Add Trusted File Location page, in the Address text box, type the location to save your workbook—for example, http://sp2007/sites/test/Shared%20Documents.
8.Under Location type, click the appropriate location type. In this example, select SharePoint Foundation.
9.Under Trust Children, select Children trusted if you want to trust child libraries or directories.
10.Click OK.

Microsoft has published a very good article on this which will be very usefull to configure remaining parameters regarding the same:
http://technet.microsoft.com/en-us/library/ff191194.aspx

1. The above mentioned link covers default parameters for trusted file locations
2. How to edit a trusted file location
3. How to delete a trusted file location

You can also trust a location by using Windows PowerShell:
http://technet.microsoft.com/en-us/library/ee428287.aspx

References:
http://blogs.technet.com/b/wbaer/archive/2007/02/14/configuring-trusted-file-locations-for-excel-services.aspx

http://www.stickyglue.co.za/index.php/archives/83

http://blogs.msdn.com/b/team_foundation/archive/2010/03/06/configuring-sharepoint-server-2010-beta-for-dashboard-compatibility-with-tfs-2010-beta2-rc.aspx

sql interview questions and answers

What is sql?
-Structured Query Language (SQL) is a language that provides an interface to relational database systems.

Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
-Data Definition Language (DDL)

Which TCP/IP port does SQL Server run on? How can it be changed?
-SQL Server runs on port 1433. It can be changed from the Network Utility TCP/IP properties.

What is the difference between UNION and UNION ALL in SQL?
-UNION is an SQL keyword used to merge the results of two or more tables using a Select statement, containing the same fields, with removed duplicate values. UNION ALL does the same, however it persists duplicate values.

What operator performs pattern matching?
-LIKE operator

What are the difference between clustered and a non-clustered index?
-A clustered index is a special type of index that reorders the way records in the table are physically stored.
-A non clustered index is a special type of index in which the logical order of the index does not match the physical stored order of the rows on disk.

What is the difference between IN and BETWEEN, that are used inside a WHERE clause?The BETWEEN clause is used to fetch a range of values, whereas the IN clause fetches data from a list of specified values.

What are the wildcards used for pattern matching?
_ for single character substitution and % for multi-character substitution

What is Online Transaction Processing (OLTP) ?
-Online transaction processing systems relational database design use the discipline of data modeling and generally follow the Codd rules of data normalization in order to ensure absolute data integrity.

What are the privileges that can be granted on a table by a user to others?
Insert, update, delete, select, references, index, execute, alter, all

Whats the capacity of the image data type in MS SQL?
-Variable-length binary data with a maximum length of 2^31 - 1 (2,147,483,647) bytes.

What is difference between DELETE and TRUNCATE commands?
-Delete command removes the rows from a table based on the condition that we provide with a WHERE clause. Truncate will actually remove all the rows from a table and there will be no data in the table after we run the truncate command.

What command is used to get back the privileges offered by the GRANT command?
-REVOKE

What are the authentication modes in SQL Server?
-Windows mode and Mixed Mode - SQL and Windows. How 2 change it-To change authentication mode in SQL Server click Start, Programs, Microsoft SQL Server and click SQL Enterprise Manager to run SQL Enterprise Manager from the Microsoft SQL Server program group. Select the server then from the Tools menu select SQL Server Configuration Properties, and choose the Security page.

What’s the difference between a primary key and a unique key?
-Both Primary key and Unique key enforce the uniqueness of a column on which they are defined. However, a Primary key does not allow nulls, whereas unique key allow nulls.

What is a transaction and ACID?
-Transaction - A transaction is a logical unit of work. All steps must be committed or rolled back.
ACID - Atomicity, Consistency, Isolation and Durability, these are the unique entities of a transaction.

References:
http://www.pinaldave.com/sql-download/SQLServer2008InterviewQuestionsAnswers.pdf

http://r4r.co.in/sql/sql_Interview_Questions_and%20Answers/SQL_Interview_Questions_And_Answers.php

http://www.allinterview.com/Interview-Questions/SQL-PLSQL.html

http://blog.sqlauthority.com/2007/04/21/sql-server-interview-questions-and-answers-complete-list-download/

http://www.techinterviews.com/sql-interview-questions-and-answers

dot net interview questions and answers

1. What's the difference between Response.Write() and Response.Output.Write()?
-Both Response.Write() and Response.Output.Write() are used to display output on the Screen. But Using Reponse.Output.Write() you can display formattable output while Response.Write() can only display single character line.

2. Which control cannot be placed in MDI?
-The controls that do not have events.All the controls that cannot be placed on the MDI. Only certain controls can be pleced on the MDI they are Picture Box, Tool Strip, Status Bar, Timer, Progressvie Bar.

3. How many classes can a single .NET DLL contain?
-Many class store in single dll (unlimited)

4. Briefly explain what user controls are and what server controls are and the differences between the two.
-An ASP.NET control (sometimes called a server control) is a server-side component that is shipped with .NET Framework. A server control is a compiled DLL file and cannot be edited. server controls are asp.net controls it is not editable it is in compiled dll, user controls are collections of server controls which is use in application with saperate copy of controls

5. Does ViewState affect performance? What is the ideal size of a ViewState? How can you compress a viewstate?
-Viewstate stores the state of controls in HTML hidden fields. At times, this information can grow in size. This does affect the overall responsiveness of the page, thereby affecting performance.

6. What is CLR?
-CLR is .NET equivalent of Java Virtual Machine (JVM). It is the runtime that converts a MSIL code into the host machine language code, which is then executed appropriately. The CLR is the execution engine for .NET Framework applications.

7. What is the difference between VB6 and VB.Net?
-VB is a Object-based Language, does not supports threading, Not powerful Exception handling mechanism
-VB.net is a Object-oriented Language, supports threading, powerful in exception handling

8. How do you turn off cookies for one page in your site?
-It can be turned off by mentioning cookie state= false in web.config file

9. How can you detect if a viewstate has been tampered?
-By setting the EnableViewStateMac to true in the @Page directive.

10. Can you change a Master Page dynamically at runtime?
-Yes. To change a master page, set the MasterPageFile property to point to the .master page during the PreInit page event.

Reference:
http://www.questpond.com/

http://p2p.wrox.com/net-framework-2-0/31636-dot-net-interview-questions-answers.html

http://www.globalguideline.com/interview_questions/Questions.php?sc=Basic_Dot_Net_Programming_Interview_Questions_and_Answers

http://dotnetprojectninterviewquestions.blogspot.com/