Installing SharePoint 2010 on SQLSERVER 2012

If you are using SQL Server 2012 features with a SharePoint farm, you must apply SharePoint Server2010 Service Pack 1 (SP1) to the farm before adding SQL Server 2012 features. Pre-SP1 version of SharePoint 2010 uses a deprecated feature that was removed in Microsoft SQL Server 2012 . Applying SP1 adds a new methodology for connecting to SQL Server 2012 features.

This section describes the errors that will occur if SP1 is not installed. Errors are most likely to occur when you create a farm or update information in the configuration database. The following list summarizes the more common ways you will encounter this error.

• In ULS logs, you will find the following error: Could not find stored procedure 'sp_dboption'.
• In the SharePoint Products Configuration wizard, the wizard fails to create the configuration database.

What's New for SharePoint Development in Visual Studio 11 Beta

The SharePoint developer tools in Visual Studio 11 Developer Preview contain new designers and templates to facilitate SharePoint development, as well as new options for deploying and testing SharePoint sites. See the following descriptions to learn about these and other new features.
This topic contains the following sections.

• Create Lists and Content Types by Using New Designers
• Create Site Columns
• Create Silverlight Web Parts
• Publish SharePoint Solutions to Remote SharePoint Servers
• Test SharePoint Performance by Using Profiling Tools
• Create Sandboxed Visual Web Parts
• Improved Support for Sandboxed Solutions.
• Support for JavaScript Debugging and IntelliSense for JavaScript
• Streamlined SharePoint Project Templates

What's New for SharePoint Development in Visual Studio 11 Beta

SharePoint Server 2010 OOTB Web Parts

To cover the web parts available with SharePoint Server 2010 for a comparison of the two versions. With the server version there are 11 categories but in SharePoint Foundation there are only 5 which is very understandable when you compare a free version to a fully featured server application that can support millions of users.
This list of web parts is based on the enterprise edition the next time I do a standard install I will also list those.



The categories and web parts are as follows:-

List and Libraries

• Announcements – Use this list to track upcoming events, status updates or other team news
• Calendar – Use the Calendar list to keep informed of upcoming meetings, deadlines, and other important events
• Links - Use the Links list for links to Web pages that your team members will find interesting or useful
• Shared Documents – Share a document with the team by adding it to this document library
• Site Assets – Use this library to store files which are included on pages within this site, such as images on Wiki pages
• Site Pages – Use this library to create and store pages on this site
• Tasks – Use the Tasks list to keep track of work that you or your team needs to complete
• Team Discussions – Use the Team Discussion list to hold newsgroup-style discussions on topics relevant to your team

Business Data

• Business Data Actions – Displays a list of actions from Business Data Connectivity
• Business Data Connectivity Filter – Filters the contents of Web Parts using a list of values from the Business Data Connectivity
• Business Data Item – Displays one item from a data source in Business Data Connectivity
• Business Data Item Builder – Creates a Business Data item from parameters in the query string and provides it to other Web Parts
• Business Data List – Displays a list of items from a data source in Business Data Connectivity
• Business Data Related List – Displays a list of items related to one or more parent items from a data source in Business Data Connectivity
• Chart Web Part – Helps you to visualize your data on SharePoint sites and portals
• Excel Web Access – Use the Excel Web Access Web Part to interact with an Excel workbook as a Web page
• Indicator Details – Displays the details of a single Status Indicator. Status Indicators display an important measure for an organization and may be obtained from other data sources including SharePoint lists, Excel workbooks, and SQL Server 2005 Analysis Services KPIs.
• Status Lists – Shows a list of Status Indicators. Status Indicators display important measures for your organization, and show how your organization is performing with respect to your goals.
• Visio Web Access – Enables viewing and refreshing of Visio Web Drawings

Content Rollup

• Categories – Displays categories from the Site Directory
• Content Query – Displays a dynamic view of content from your site
• Relevant Documents – Displays documents that are relevant to the current user
• RSS Viewer – Displays an RSS feed
• Site Aggregator – Displays sites of your choice.
• Sites In Category – Displays sites from the Site Directory within a specific category
• Summary Links – Allows authors to create links that can be grouped and styled
• Table Of Contents – Displays the navigation hierarchy of your site
• Web Analytics web Part – Displays the most viewed content, most frequent search queries from a site, or most frequent search queries from a search center
• WSRP Viewer – Displays portlets from web sites using WSRP 1.1
• XML Viewer – Transforms XML data using XSL and shows the results

Filters

• Choice Filter – Filters the contents of Web Parts using a list of values entered by the page author
• Current User Filter – Filters the contents of Web Parts by using properties of the current user
• Date Filter – Filter the contents of Web Parts by allowing users to enter or pick a date
• Filter Actions – Use the Filter Actions Web Part when you have two or more filter Web Parts on one Web Part Page, and you want to synchronize the display of the filter results
• Page Field Filter – Filters the contents of Web Parts using information about the current page
• Query String (URL) Filter – Filters the contents of Web Parts using values passed via the query string
• SharePoint List Filter - Filters the contents of Web Parts by using a list of values
• SQL Server Analysis Services Filter – Filters the contents of Web Parts using a list of values from SQL Server Analysis Services cubes
• Text Filter – Filters the contents of Web Parts by allowing users to enter a text value

Forms

• HTML Form Web Part – Connects simple form controls to other Web Parts
• InfoPath Form Web Part – Use this Web Part to display an InfoPath browser-enabled form

Media and Content

• Content Editor – Allows authors to enter rich text content
• Image Viewer – Displays a specified image
• Media Web Part – Use to embed media clips (video and audio) in a web page
• Page Viewer - Displays another Web page on this Web page. The other Web page is presented in an IFrame
• Picture Library Slideshow Web Part – Use to display a slideshow of images and photos from a picture library
• Silverlight Web part – A web part to display a Silverlight application

Outlook Web App

• My Calendar – Displays your calendar using Outlook Web Access for Microsoft Exchange Server 2003 or later
• My Contacts – Displays your contacts using Outlook Web Access for Microsoft Exchange Server 2003 or later
• My Inbox – Displays your inbox using Outlook Web Access for Microsoft Exchange Server 2003 or later
• My Mail Folder – Displays your mail folder using Outlook Web Access for Microsoft Exchange Server 2000
• My Tasks – Displays your tasks using Outlook Web Access for Microsoft Exchange Server 2003 or later

PerformancePoint

• PerformancePoint Filter – This web part displays PerformancePoint filters. Filters may be linked to other web parts to provide an interactive dashboard experience. Filter types include lists and trees based on a variety of data sources
• PerformancePoint Report – This web part displays PerformancePoint reports. Reports may be linked to other web parts to create an interactive dashboard experience. Report types include: Analytic charts & grids, Strategy Maps, Excel Services, Reporting Services, Predictive Trend charts, and web pages
• PerformancePoint Scorecard – This web part displays a PerformancePoint scorecard. Scorecards may be linked to other web parts, such as filters and reports, to create an interactive dashboard experience.
• PerformancePoint Stack Selector – This web part displays a PerformancePoint Stack Selector. All PerformancePoint web parts, such as filters and reports, contained in the same zone will be automatically stacked and selectable using this web part.

Search

• Advanced Search Box – Displays parameterized search options based on properties and combinations of words.
• Dual Chinese Search – Used to search Dual Chinese document and items at the same time.
• Federated Results – Displays search results from a configured location
• People Refinement Panel – This webpart helps the users to refine people search results
• People Search Box – Presents a search box that allows users to search for people
• People Search Core Results – Displays the people search results and the properties associated with them.
• Refinement Panel – This webpart helps the users to refine search results
• Related Queries – This webpart displays related queries to a user query
• Search Action Link – Displays the search action links on the search results page
• Search Best Bet – Displays high-confidence results on a search results page.
• Search Box – Displays a search box that allows users to search for information.
• Search Core Results – Displays the search results and the properties associated with them
• Search Paging – Display links for navigating pages containing search results.
• Search Statistics – Displays the search statistics such as the number of results shown on the current page, total number of results and time taken to perform the search.
• Search Summary – Displays suggestions for current search query
• Search Visual Best Bet – Displays Visual Best Bet
• Top Federated Results – Displays the Top Federated result from the configured location

Social Collaboration

• Contact Details – Displays details about a contact for this page or site.
• Note Board – Enable users to leave short, publicly-viewable notes about this page.
• Organization Browser – This Web Part displays each person in the reporting chain in an interactive view optimized for browsing organization charts.
• Site Users – Use the Site Users Web Part to see a list of the site users and their online status.
• Tag Cloud – Displays the most popular subjects being tagged inside your organization
• User Tasks – Displays tasks that are assigned to the current user.
• What’s New – This Web part shows new information from specified lists and libraries
• Whereabouts – Use to display Whereabouts information

Developing Applications for SharePoint 2010

Patterns & Practices Developer Center for SharePoint 2010 introduces rich new areas of functionality that create more choices and fresh opportunities for developers and solution architects. Sandboxed solutions, new options for data modeling and data access, and new client programming models with Silverlight and Ajax integration offer a step change in what you can accomplish with SharePoint applications.
http://msdn.microsoft.com/en-us/library/ff770300.aspx

 

The documentation is divided into four core sections.

• Application Foundations for SharePoint 2010.
• Execution Models in SharePoint 2010.
• Data Models in SharePoint 2010. .
• Client Application Models in SharePoint 2010.

SharePoint 15 Features and Resources

“SharePoint 15″ – Its a hot topic in SharePoint world right now and I finally felt a need to write something about it. I am no expert on SharePoint 15 and I have no inside details about what features are included in SharePoint 15 but I have collected few key features that were mentioned by some of the great SharePoint gurus out there. Don’t forget to check the references for them at the end.
Features -
1. SharePoint 15 will include a new SharePoint Apps Marketplace.
2. New App Store Database Provider – App ‘package’ can be configured to use any back-end database that supports the new Database provider interfaces.
3. SharePoint Apps will support multi-tenant installations so that hosting providers can make available the same set of applications to multiple customers.
4. SharePoint 15 gets a new Education module/option.
(Another FYI – Microsoft is also working on making its Office 365 for Education globally available this summer as the successor to Live@Edu. Microsoft plans three pricing/licensing plans for it, namely A2, A3 and A4, the first of them being free for both students and faculty.)
5. SharePoint 15 and Exchange Server 15 are both getting additional built-in information-rights-management (IRM) document-protection functionality as part of the base products.
6. SharePoint Server 15 will also feature Rights Management Services (RMS) integration.
7. SharePoint 15 supports OAuth.
8. MDS or Minimal Download Strategy (MDS allows websites to take much less bandwidth than with traditional technologies.)
9. Project Online: New Project site to manage lightweight projects.
10. Visio cloud service component.
11. SharePoint Duet: A cloud version of the Duet add-on Developed by SAP and Microsoft that allows SharePoint to integrate with SAP applications.
12. Support for viewing business intelligence content on Apple iPad devices.
13. New Versioning – Now you will be also able to version entire parts of SharePoint. An entire site for instance.
14. Improved Client Object Model – The Client Object Model is extended with Search. Also no need to add Form Digest control in your page you can include that in your ClientContext.
References -
http://www.zdnet.com/blog/microsoft/details-begin-to-leak-on-microsoft-sharepoint-online-2013/12184
http://www.zdnet.com/blog/microsoft/microsoft-sharepoint-15-a-2012-release-target-an-app-marketplace-and-more/12002
http://news.softpedia.com/news/Microsoft-SharePoint-Online-2013-Details-Leak-259172.shtml
http://www.microsoft.com/download/en/details.aspx?id=28768&
http://jeffreypaarhuis.com/2012/03/12/whats-new-in-sharepoint-15-sharepoint-2013/
http://www.collaboris.co.uk/blogs/blog-post/mark-jones/2012/01/31/will-sharepoint-15-%282013%29-finally-get-an-app-store-we-think-so

The Industry is Changing—What about Your Skills

You’ve probably noticed that IT Technology cycles continue to compress. The advantages of Microsoft’s private cloud solution mean that it is easier and quicker than ever to develop and deploy new applications in a private cloud datacenter. And the software companies you depend on for your tools and environment—like Microsoft—have compressed their cycles, too. That means new more change, more often, as your work environment updates with new software and technologies.

Microsoft Certification continually updates too, to help you keep your skills up to date in this changing environment. We’re keeping Microsoft Certifications current with more streamlined, solutions-based certification paths covering the latest trends in the industry. For example, in addition to our upcoming Private Cloud certification, a Windows 8 Certification is coming soon.

And having a Microsoft Certification sends a clear message to employers that you have proven skills in the latest technologies. For instance, a 2011 CompTIA study found that IT professionals gain an average 9% salary increase immediately after receiving certification, and 29% over the long term, versus peers who are not certified (channelinsider.com, 2011-10-19). And in a in a 2010 survey of hiring managers, 91% said they consider employee certification as a criterion for hiring (Microsoft Learning, 2010).

http://www.microsoft.com/learning/en/us/default.aspx

Online Free SharePoint 2010 Trainings for Developers

1. Get Started Developing on SharePoint 2010
   Use these ten modules to get started with development for SharePoint 2010 using Visual Studio 2010.
2. Video Center | SharePoint 2010 Development
   Have just a few minutes to learn something new? Watch these short videos about creating custom solutions with SharePoint Online, SharePoint Server, and SharePoint Foundation.
3. SharePoint 2010 Developer Training Kit
   Guidance that provides developers with advanced guidance on how to develop for SharePoint.
4. SharePoint 2010 Advanced Developer Training
   SharePoint 2010 Advanced Developer Training offers technical training as self-paced modules and hosted labs for SharePoint 2007 professionals who want to upgrade their skills to SharePoint 2010.
5. SharePoint 2010 Enterprise Search Developer Training
   The Microsoft SharePoint 2010 Enterprise Search training course provides a series of hands-on labs, presentations, and videos that demonstrate how to enable high-end enterprise search with Microsoft SharePoint Server 2010 for Search and Microsoft FAST Search Server 2010 for SharePoint
6. SharePoint 2010 for Internet Sites Implementers' Course
   This course describes how to implement and brand a SharePoint based public website using SharePoint web content management (WCM).
7. SharePoint 2010 Enterprise Content Management Implementers' Course
   This course teaches implementers how to leverage features in SharePoint Server to implement an Enterprise Content Management (ECM) system.

Keeping Relevant to Evolving Technology

Over the past 20 years, Microsoft Certifications have continually stayed relevant to the needs of technology professionals and the companies that employ them. Let’s look at some of the ways they’re keeping the certifications themselves relevant to changing technologies.

And speaking of changing technologies, IT departments all over the world have heard the news:

A private cloud delivers fundamentally new capabilities that represent a generational paradigm shift in computing.

from the Microsoft Server and Cloud Platform website

By pooling resources across the datacenter and the enterprise and offering an elastic and usage-based self-service model, a private cloud solution simplifies deployment, maintenance, and cost, while increasing agility and power.

And this paradigm shift in computing means a paradigm shift in the skills IT professionals will need to configure, deploy, monitor, and operate private cloud solutions of today—and tomorrow. The increased capacity and capability of Private Cloud solutions means that IT Professionals and Developers will need to have a new and broader set of skills.

Microsoft Learning is addressing this need for new skills by ensuring it offers training and certifications that enable IT Pros and Developers to develop and validate their skill sets across this new range of skills with a focus on specific technology solutions.

One example of this effort is the recently announced private cloud certification. Available as a Beta release in April, the certification starts with the foundation of current Windows Server 2008 exams, and adds two new System Center 2012 exams, currently in beta.

Get started today by heading over to the Microsoft Private Cloud Certification Overview page. That’s where you can prepare and practice for the certification, sign up for our upcoming Private Cloud Jump Start course, and get a head start on your private cloud certification by starting your MCITP Server Administrator certification.

SharePoint 2010 Products: Upgrade and the Fabulous 40 Application Templates

Many of us have used the "Fabulous 40 templates" that were created for Windows SharePoint Services 3.0. Some of these templates were created as site admin templates (.stp files) and some as server admin templates (.wsp files). Microsoft is not releasing new versions of these templates for SharePoint 2010 Products. Also, .stp files are deprecated and can't be used to create new sites when you upgrade to SharePoint Server 2010 or SharePoint Foundation 2010.
So, what do you do when you want to upgrade?
Sites based on these templates should upgrade, but you'll want to try out your upgrade in a test environment before you upgrade your production environment so that you can catch any potential issues. Definitely use the pre-upgrade checker to identify any issues (some people have seen problems with custom workflows or CAML-based views in the templates). However, after upgrade, you won't be able to use STP files to create new templates.

Type of template	Can I upgrade sites based on this template?	Will I be able to use the template after upgrade?
Site admin (.stp file or site template)	Yes	No
Server admin (.wsp file or solution package)	Yes*	Yes*

*There are issues with a few of the .wsp files after upgrade. In particular, after upgrading, some customers are unable to create new sites based on the following templates: Absence Request and Vacation Schedule Management, Call Center, Help Desk, IT Team Workspace, Knowledge Base, and Physical Asset Tracking and Management. If you have trouble using any of these templates, you can post an issue in the SharePoint 2010 – Setup, Upgrade, Administration and Operation TechNet Forum at http://social.technet.microsoft.com/Forums/en-US/sharepoint2010setup/threads, or contact Microsoft Product Support.


So, what do you do if you're using an .stp file and you want to continue using it after upgrade? You can convert the .stp file to a .wsp file manually. To do this, in Windows SharePoint Services 3.0 or Office SharePoint Server 2007, create a site based on the template, and then upgrade the site to 2010. Then, follow this procedure:

1. On the Site Actions menu in the site, click Site Settings.
2. On the Site Settings page, under Site Actions, click Save site as Template.
3. On the Save as Template page, enter a file name and Template name and then click OK.
4. The site template is saved as a WSP file to the Solutions Gallery for that site collection and you can create new sites based on that solution.

TechSolutions has already converted some of these templates to 2010 for you. Take a look at http://techsolutions.net/Blog/tabid/65/EntryId/17/Fab-40-Templates-for-MOSS-2010.aspx.

How to Facilitate Project Collaboration with SharePoint

MSPFM: How to Facilitate Project Collaboration with SharePoint from Dux Raymond Sy on Vimeo.