Microsoft certifications on SharePoint 2010

Microsoft SharePoint Server Certification Overview
Many companies are investing in collaborative technologies like those offered by Microsoft SharePoint Server to help manage and share vast quantities of valuable information. With a Microsoft SharePoint Server certification, you can assist them. Get certified to build and configure web portals, integrate business applications, and manage administration and deployment of collaborative solutions.


Microsoft Certified Technology Specialist certification
The Microsoft Certified Technology Specialist (MCTS) certification highlights your area of expertise and helps validate that you have the knowledge and skills required to deploy and administer an enterprise SharePoint Server environment.


Review the requirements for MCTS certifications
Microsoft Professional certifications
When you earn a Microsoft Certified IT Professional (MCITP) or a Microsoft Certified Professional Developer (MCPD) certification, you help demonstrate your expertise in using Microsoft SharePoint Server 2010 to excel in a specific job role. Professionals who earn an MCITP or a MCPD certification typically have at least two to three years of experience in using the technologies covered in the exam and have already earned the MCTS certification.


Review the requirements for Microsoft Professional certifications
Microsoft Certified Master program
Differentiate yourself as the technical expert. The Microsoft Certified Master (MCM) program helps the best professionals in the IT industry become even better. Whether you want to enhance and validate your advanced skills or take your career to the next level, achieving a Microsoft Certified Master certification will help differentiate you from others in the competitive ranks of senior IT professionals.
This unique program consists of three weeks of mandatory, hands-on training led by experts, and extensive written and lab-based testing. Candidates' practical product knowledge, technical acumen, knowledge of best practices, personal and professional stamina, and communication skills are constantly challenged as they work toward attaining this premier Microsoft technical certification.


Learn about the MCM certification for SharePoint Server
Microsoft Certified Architect certification
Validate your capability to translate business problems into technology solutions. Individuals who earn the Microsoft Certified Architect (MCA) certification have achieved the capstone certification from Microsoft, proving their ability to architect large-scale complex solutions with Microsoft technologies. As such they can be recognized by Microsoft and the IT industry worldwide as an expert who holds the highest level of professional certification from Microsoft.


MCITP and MCPD for SharePoint Server

The Microsoft Certified IT Professional (MCITP) and Microsoft Certified Professional Developer (MCPD) certifications help you demonstrate your ability to use Microsoft SharePoint Server 2010 to excel in a specific, market-relevant job role. We offer two paths: each builds on MCTS prerequisites and is relevant to professional roles in today's technology marketplace. Use the following table to identify the certification that best fits your current role and career goals.

Note The MCITP and MCPD certifications will be retired when Microsoft discontinues mainstream support for the related technologies.

Microsoft Professional certification	Prerequisite MCTS certification	Exam
MCITP: SharePoint Administrator 2010	MCTS: SharePoint 2010, Configuration	Exam 70-668: PRO: Microsoft SharePoint 2010, Administrator
MCPD: SharePoint Developer 2010	MCTS: SharePoint 2010, Application Development	Exam 70-576: PRO: Designing and Developing Microsoft SharePoint 2010 Applications

Advanced Certifications for SharePoint Server

Microsoft Certified Master (MCM)

The Microsoft Certified Master (MCM) for SharePoint Server 2010 certification is developing the next generation of technical leaders in this dramatically growing business. A combination of in-depth technical instructor-led training, whiteboard discussions, goal-based labs, and thorough exam testing delivers the most comprehensive training available today for Microsoft SharePoint Server 2010 delivered by top SharePoint experts. Successful completion of this program demonstrates knowledge of SharePoint products and technologies at a deeper level than has ever been assessed before. Graduates of this program are recognized by Microsoft as the top SharePoint experts in the world. To be accepted into the MCM program, applicants must meet or exceed the prerequisites, which include:

1. A thorough understanding of Microsoft SharePoint Server 2010 design and architecture.
2. A thorough understanding of Microsoft ASP.NET, Windows Server, Internet Information Services, and other core technologies related to SharePoint products and technologies.
3. The ability to speak, understand, and write fluent English.
4. The following experience:
   
   • Hands-on experience via early adoption programs with Microsoft SharePoint Server 2010: installing, configuring, troubleshooting, and custom development
   • Three or more years of hands-on experience with Microsoft Office SharePoint Server 2007: installing, configuring, troubleshooting, and custom development
5. Candidates must have passed the following certification exams prior to applying to the MCM program:

Microsoft Certification exams on SharePoint 2010 (available mid-year 2010):

• Exam 70-573: TS: Microsoft SharePoint 2010, Application Development
• Exam 70-576: PRO: Designing and Developing Microsoft SharePoint 2010 Applications
• Exam 70-667: TS: Microsoft SharePoint 2010, Configuring
• Exam 70-668: PRO: SharePoint 2010, Administrator

or

All Microsoft Certification exams on SharePoint 2007 (for rotations starting before December 31, 2010):

• Exam 70-631: TS: Windows SharePoint Services 3.0, Configuring
• Exam 70-630: TS: Microsoft Office SharePoint Server 2007, Configuring
• Exam 70-541: TS: Microsoft Windows SharePoint Services 3.0 – Application Development
• Exam 70-542: TS: Microsoft Office SharePoint Server 2007 – Application Development

Learn more about the MCM: Microsoft Office SharePoint Server

Microsoft Certified Architect (MCA)

The Microsoft Certified Architect (MCA) certification is designed for architects who specialize in using Microsoft technologies to provide solutions for enterprise customers. MCAs are recognized by Microsoft and the IT industry worldwide as individuals who hold the highest level of professional certification on Microsoft server products.

• Find out more about the MCA program and MCA: Microsoft SharePoint Server

Microsoft SharePoint Foundation 2010

Overview
SharePoint Foundation 2010 is the new version of Microsoft Windows SharePoint Services. It is the essential solution for organizations that need a secure, manageable, web-based collaboration platform. ​SharePoint helps teams stay connected and productive by providing easy access to the people, documents, and information that they need to make well-informed decisions and get work done. Use SharePoint Foundation to coordinate schedules, organize documents, and participate in discussions through team workspaces, blogs, wikis, and document libraries on the platform that is the underlying infrastructure for SharePoint Server. 


Search Server 2010 Express: If you’re using SharePoint Foundation, you can easily add search capabilities to your collaboration environment across SharePoint sites, file shares, web sites, Exchange Public Folders, and third party repositories using Microsoft Search Server 2010 Express. Click here to download. ​

Microsoft SharePoint Foundation 2010 is for smaller organizations or departments looking for a low-cost entry-level or pilot solution for secure, Web-based collaboration.​

Quick details

Version:	1	Date Published:	4/22/2010
Change Language:	Arabic                                                                                  Chinese (Simplified)                                                                                  Chinese (Traditional)                                                                                  Czech                                                                                  Danish                                                                                  Dutch                                                                                  English                                                                                  Finnish                                                                                  French                                                                                  German                                                                                  Greek                                                                                  Hebrew                                                                                  Hindi                                                                                  Hungarian                                                                                  Italian                                                                                  Japanese                                                                                  Korean                                                                                  Norwegian (Bokmål)                                                                                  Polish                                                                                  Portuguese (Brazil)                                                                                  Portuguese (Portugal)                                                                                  Russian                                                                                  Spanish                                                                                  Swedish                                                                                  Thai                                                                                  Turkish

File Name	Size
SharePointFoundation.exe	169.6 MB	DOWNLOAD

Microsoft SharePoint 2010, Application Development

About this Course
This course provides existing .NET developers with practical information and labs that enables them to build solutions on the Microsoft SharePoint 2010 platform.


Audience Profile
This course is intended for professional developers who use Microsoft SharePoint 2010 in a team-based, medium-sized to large development environment. Members of the audience are experienced users of Microsoft Visual Studio 2008 SP1. The audience understands how to use the new features of SharePoint 2010 and Visual Studio 2010.


At Course Completion
After completing this course, students will be able to:
Describe the SharePoint 2010 development platform and the benefits and features that it offers to developers.
Use development tools that are integrated with the SharePoint 2010 development platform, such as Visual Studio 2010 and SharePoint Designer 2010.
Develop Web Parts for SharePoint 2010 solutions.
Develop code that uses the server-side objects provided by the SharePoint 2010 development platform.
Develop event receivers and manipulate application settings for SharePoint 2010 solutions.
Develop solutions that access external data by using Business Connectivity Services.
Develop workflows as part of SharePoint 2010 solutions.
Develop code that uses the client-side objects provided by the SharePoint 2010 development platform.
Develop server ribbon controls and client dialogs for the new user interface platform of SharePoint 2010.
Develop Microsoft Silverlight applications that are integrated with SharePoint 2010 data and solutions.
Develop sandboxed solutions for SharePoint 2010.
Develop code that uses the taxonomic and user profile services of the SharePoint 2010 development platform.
Develop code that uses the content management services of the SharePoint 2010 development platform.


Course Outline
Module 1: Introduction to the SharePoint 2010 Development Platform
This module describes the SharePoint 2010 development platform and the benefits and features that it offers to developers.
Lessons
Lesson 1: SharePoint 2010 as a Development Platform
Lesson 2: SharePoint 2010 Object Hierarchy
Lesson 3: Working with SharePoint 2010 Objects
Lab : Developing with the SharePoint 2010 Object Hierarchy
Exercise 1: Creating SharePoint 2010 Application Pages by Using Visual Studio 2010
Exercise 2: Enumerating SharePoint 2010 Farm Hierarchies
Exercise 3:  Manipulating Properties of Objects in the SharePoint Farm
After completing this module, students will be able to:
Describe SharePoint 2010 as a development platform.
Describe the SharePoint 2010 object hierarchy from the perspective of a developer.
Work with SharePoint 2010 objects programmatically.
Module 2: Using SharePoint 2010 Developer Tools
This module describes how to use development tools that are integrated with the SharePoint 2010 development platform, such as Visual Studio 2010 and SharePoint Designer 2010.
Lessons
Lesson 1: Developing SharePoint Sites by Using SharePoint Designer 2010
Lesson 2: Developing SharePoint Solutions by Using Visual Studio 2010
Lesson 3: Packaging and Deploying SharePoint 2010 Solutions
Lab : Using SharePoint 2010 Developer Tools
Exercise 1: Creating Document Libraries by Using SharePoint Designer 2010
Exercise 2: Creating SharePoint List Definitions and Instances by Using Visual Studio 2010
Exercise 3:Packaging Features and Solutions by Using Visual Studio 2010
After completing this module, students will be able to:
Develop SharePoint sites by using SharePoint Designer 2010.
Develop SharePoint solutions by using Visual Studio 2010.
Package and deploy SharePoint 2010 solutions.


Module 3: Developing SharePoint 2010 Web Parts
This module describes how to develop Web Parts for SharePoint 2010 solutions.
Lessons
Lesson 1: Developing Standard Web Parts
Lesson 2: Developing Connected Web Parts
Lesson 3: Developing Visual Web Parts
Lab : Creating SharePoint 2010 Web Parts by Using Visual Studio 2010
Exercise 1: Creating, Deploying, and Debugging a Simple Web Part by Using Visual Studio 2010
Exercise 2: Using SharePoint Components in a Web Part
Exercise 3: Creating a Visual Web Part by Using Visual Studio 2010
After completing this module, students will be able to:
Develop standard Web Parts.
Develop connected Web Parts.
Develop Visual Web Parts.


Module 4: Working with SharePoint Objects on the Server
This module describes how to develop code that uses the server-side objects provided by the SharePoint 2010 development platform.
Lessons
Lesson 1: Working with SharePoint Sites Programmatically               
Lesson 2: Working with SharePoint Lists Programmatically
Lesson 3: Working with List Data Programmatically
Lab : Creating and Manipulating Server-Side Objects
Exercise 1: Creating and Securing Sites Programmatically
Exercise 2: Creating Lists Programmatically
Exercise 3: Retrieving Secured Data
After completing this module, students will be able to:
Create and manipulate SharePoint sites.
Create and manipulate SharePoint lists.
Retrieve, add, update, and delete SharePoint list data.


Module 5: Creating Event Receivers and Application Settings
This module describes how to develop event receivers and manipulate application settings for SharePoint 2010 solutions.
Lessons
Lesson 1: Creating Event Receivers
Lesson 2: Working with Web.Config Programmatically
Lab : Creating Event Receivers and Web.Config Modifications
Exercise 1: Creating List Event Receivers
Exercise 2: Creating Feature Receivers to Modify Web.Config
Exercise 3: Creating Web Event Receivers
After completing this module, students will be able to:
Create event receivers for SharePoint 2010 solutions.
Add, modify, and retrieve Web.config settings programmatically for use in your SharePoint solutions.


Module 6: Developing Solutions by Using Business Connectivity Services
This module describes how to develop solutions that access external data by using Business Connectivity Services.
Lessons
Lesson 1: Business Connectivity Services Overview
Lesson 2: Developing External Content Types and Lists by Using SharePoint Designer
Lesson 3: Developing Business Connectivity Services Solutions by Using Visual Studio 2010
Lab : Building Business Connectivity Services Solutions
Exercise 1: Creating External Content Types and Lists by Using SharePoint Designer 2010
Exercise 2: Creating Business Data Catalog Models by Using Visual Studio 2010
After completing this module, students will be able to:
Describe Business Connectivity Services.
Develop external content types and lists by using SharePoint Designer 2010.
Develop Business Connectivity Services solutions by using Microsoft Visual Studio 2010.


Module 7: Developing SharePoint 2010 Workflows
This module describes how to develop workflows as part of SharePoint 2010 solutions.
Lessons
Lesson 1: Creating Workflows with SharePoint Designer
Lesson 2: Creating Workflows with Visual Studio 2010
Lab : Creating Workflows for SharePoint 2010
Exercise 1: Creating Workflows by Using SharePoint Designer
Exercise 2: Creating a Sequential Workflow by Using Visual Studio 2010
After completing this module, students will be able to:
Create workflows for SharePoint by using SharePoint Designer 2010.
Create workflows for SharePoint by using Microsoft Visual Studio 2010.


Module 8: Working with Client-Based APIs for SharePoint 2010
This module describes how to develop code that uses the client-side objects provided by the SharePoint 2010 development platform.
Lessons
Lesson 1: Overview of the SharePoint 2010 Client Object Model
Lesson 2: Working with the SharePoint 2010 Client Object Model in .NET Applications
Lab : Developing .NET Applications by Using the SharePoint Client Object Model
Exercise 1: Creating a SharePoint 2010 Site, List, and List Items Using the Client Object Model
Exercise 2: Building and Using the Console Application
After completing this module, students will be able to:
Describe the SharePoint 2010 Client Object Model.
Work with the SharePoint 2010 Client Object Model in Microsoft .NET Framework applications.


Module 9: Developing Interactive User Interfaces
This module describes how to develop server ribbon controls and client dialogs for the new user interface platform of SharePoint 2010.
Lessons
Lesson 1: Creating Menu Items and Ribbon Controls
Lesson 2: Creating Client-Side Dialogs
Lab : Developing User Interface Components for SharePoint 2010 Solutions
Exercise 1: Creating a Site Actions Menu Item
Exercise 2: Creating a Ribbon Item
Exercise 3: Creating a Client-Side Dialog
After completing this module, students will be able to:
Create menu items and ribbon controls.
Create client-side dialogs.


Module 10: Developing Silverlight Applications for SharePoint
This module describes how to develop Silverlight applications that are integrated with SharePoint 2010 data and solutions.
Lessons
Lesson 1: Creating Silverlight Applications for SharePoint 2010
Lesson 2: Deploying and Debugging Silverlight Applications for SharePoint 2010
Lab : Developing Silverlight Applications by using the SharePoint Client Object Model
Exercise 1: Creating a Silverlight Application
Exercise 2: Developing the Silverlight Application
After completing this module, students will be able to:
Develop Silverlight applications for SharePoint 2010.
Deploy and debug Silverlight applications for SharePoint 2010.


Module 11: Developing Sandboxed Solutions
This module describes how to develop sandboxed solutions for SharePoint 2010.
Lessons
Lesson 1: Sandboxing and User Solutions
Lesson 2: Restrictions for Sandboxed Solutions
Lab : Creating Sandboxed Solutions for SharePoint 2010
Exercise 1: Creating a Sandboxed Solution by Using Visual Studio 2010
Exercise 2: Investigating Allowed and Disallowed Operations in Sandboxed Solutions
After completing this module, students will be able to:
Develop sandboxed solutions.
Describe what is allowed and what is not allowed in sandboxed solutions.


Module 12: Working with SharePoint Server Profiles and Taxonomy APIs
This module describes how to develop code that uses the taxonomic and user profile services of the SharePoint 2010 development platform.
Lessons
Lesson 1: User Profiles
Lesson 2: Taxonomies
Lab : Working with User Profiles and Taxonomies Programmatically
Working with User Profiles and Taxonomies Programmatically
Exercise 1: Managing User Profiles
Exercise 2: Working with User Profiles Programmatically
After completing this module, students will be able to:
Create, retrieve, and manipulate user profiles and user profile properties.
Create and retrieve taxonomic terms.


Module 13: Developing Content Management Solutions
This module describes how to develop code that uses the content management services of the SharePoint 2010 development platform.
Lessons
Lesson 1: Developing Enterprise Content Management Solutions
Lesson 2: Developing Web Content Management Solutions
Lab : Branding SharePoint Sites
Exercise 1: Customizing Master Pages
Exercise 2: Applying a Theme to a SharePoint Site
After completing this module, students will be able to:
Describe how to develop enterprise content management solutions for Microsoft SharePoint Server 2010.
Describe how to develop Web content management features Microsoft SharePoint Server 2010.


Before attending this course, students must have:
An understanding of the problem-solving techniques that apply to software development
Approximately 12 months experience with ASP.NET 3.5 with Visual Studio 2008 (or later)
Approximately 1 month development experience with SharePoint 2007 or SharePoint 2010 and VS2010 (includes beta releases) creating code that interacts with the SharePoint Server-side APIs
Experience performing end user tasks with SharePoint 2007 or SharePoint 2010 and an understanding of the purpose and use of the following:
Lists
Documents and Libraries
Personalizing an SP page/site
Using MySites
Using SharePoint Designer

Opening HTML Files in Sharepoint 2010

In SharePoint 2010 I have created a Library in which I have placed an Html document and related file system to go with the document.  Under Library Settings / Advance Settings I have selected (Open in Browser). However, when I click on the file to open it in SharePoint it does not open in the browser but opens up a dialogue box to save the file locally.


Requirements: We wanted the ability to open the HTML document directly within the browser. 


Multiple Requirements:

1. upload html files to a sharepoint library: in document library we can add html files, but the problem is when i open that html file in the library a popup message box appears asking to save the file. is there a way to open these html files in a browser like documents are open in word.

2. Asking to save file when try to open it from sharepoint: When I try to open the files(.html,.xml.....) which are uploaded to sharepoint,Its not getting opened directly instead a pop up window to save the file is coming.

3. In a document library when I check out a Word document, I get prompted "You are about to check out ___" with the option to use Local Drafts folder.  I can then open the document from Local Drafts and upon saving, I get prompted to check in.

4. If you have converted Word document to HTML file and uploaded it to SharePoint.  Now I would like to make modification to the new HTML file and save it through SharePoint.  However, it is not possible because it the HTML file doesn't "save" option, only "save as" option. 

Resolution:

By default, Sharepoint 2010 is blocking the ability to open HTML documents directly from a document library. 

However this can be changed by adjusting the browser file handling option. The option is located here:

1. Central Admin\Application Management\Manage Web Applications.
2. Select General Settings for the specified web application
3. For Browser file handling, select permissive. The default is strict​

Detailed Explanation as why it happens:

This is intentional behavior. In SP2010 Microsoft has tightened up security for people with contribute access. Previously, a malicious user could upload a file with script in it that would get run as whoever browses to the page ie. an admin. In 2010 where we have a javascript object model, this would be a big problem if we didn't have this restriction in place.
Browser File Handling  
Specifies whether additional security headers are added to documents served to web browsers. These headers specify that a browser should show a download prompt for certain types of files (for example, .html) and to use the server's specified MIME type for other types of files.
Permissive Specifies no headers are added, which provides a more compatible user experience. 
Strict Adds headers that force the browser to download certain types of files. The forced download improves security for the server by disallowing the automatic execution of Web content that contributors upload

If you have any queries/questions 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

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/