SharePoint Saturday NYC July 30 2011

Speaking at SharePoint Saturday NYC on 07/30/2011

image

 

I have included the full agenda above and a syllabus of the session I will presenting below

Ivan Sanders (MVP)

Session Speaker

A Microsoft SharePoint Server MVP that is results-driven, team-oriented certified software development professional with more than 15 years of broad-based experience with hands-on development experience of high-level projects, mission-critical implementations, and innovative information management strategies … Read More

The new sessions I will be delivering starting next month are hybrid solutions using Office 365 (SharePoint  2010 Online) and SharePoint 2010 on Premise a seamless transition with all navigation allowing you to meet the needs of enterprise collaboration in the cloud and Business intelligence hosted on Premise…

 

-Ivan

 

Digg This

SharePoint Connections Coast to Coast Tour

ORIGINAL POST DATE 04/23/2011

The SharePoint coast-to-coast tour officially kicked off in Las Vegas Monday, April 18 and I was lucky enough to attend  a few of the sessions with Paul Stubbs and Dan Holmes, along with the Keynote by Steve Fox.

Next week the SharePoint tour will be in Boston so if you live in the New England area don’t miss out because we know you love SharePoint don’t miss your chance to attend the Developer Bootcamp…

image

If you live in the Orange County / San Diego area, the SharePoint tour will be coming to you on May 2nd @ the Hyatt San Diego Manchester and I will be delivering sessions on enterprise content management, business intelligence, and migrating your SharePoint 2007 solutions to SharePoint 2010. Don’t miss out sign up today for your chance to attend the Developer Bootcamp for free…

image

I Had to repost this due to the great work by the Microsoft and SharePoint Connections teams for putting this and many more together…. Steve Fox, Paul Andrews, Paul Stubbs, Donovan Follete, Bruno Nowak and of course Nancy DeBrizzi and Erik Ruthruff

image

And Don’t forget there is still one more coming up in Chicago I hope to see everyone there……

image

Thank you all for inviting me to be a part of the team

 

-Ivan

 

Exclusive Offer at Mondrian SoHo, Mondrian South Beach and Mondrian Los Angeles

10% off best available room rate, two complimentary drinks

View on Mobile Device or View in Web Browser

 

Mondrian Los Angeles, Mondrian South Beach and Mondrian SoHo. Receive 10% off best available room rate, 2 complimentary cocktails per stay, $30 hotel credit per stay.* Click here for more information or to reserve: http://www.morganshotelgroup.com/en-us/email-special-offers/mondrian-hotel-offer?cid=2011MONBRAND www.morganshotelgroup.com Connect: www.morganshotelgroup.com/social


Or you may write to us at:
Morgans Hotel Group
Attn: Interactive Marketing
475 10th Avenue 11th Floor New York, New York 10018

Copyright © 2011 Morgans Group LLC. All rights reserved.
Boston Ames London Sanderson St Martins Lane Los Angeles Mondrian
New York Hudson Mondrian Morgans Royalton San Francisco Clift
South Beach Delano Mondrian Shore Club 
http://www.morganshotelgroup.com

 

One of My Favorite Hotel Groups and my preferred residence when away from home…

 

-Ivan

SharePoint Saturday New York City 2011

Saturday, July 30, 2011 from 7:30 AM – 6:00 PM (ET)

Microsoft Manhattan 1290 Avenue of the Americas New York NY

SharePointSaturdayNYC

Join SharePoint architects, developers, and other professionals that work with Microsoft Office SharePoint Server 2007 and SharePoint Server 2010 for ‘SharePoint Saturday’, on Saturday, July 30th, 2011 in the Microsoft Manhattan Office. SharePoint Saturday will be an educational, informative & lively day filled with sessions from respected SharePoint professionals & MVPs, covering a wide variety of SharePoint-oriented topics. SharePoint Saturday is FREE, open to the public and is your local chance to immerse yourself in SharePoint!

We will have 10 tracks, 50 sessions, ask the experts/open spaces, giveaways, and more!

Our tracks for this year, and our track anchors for each:

Please register  on the waitlist with Event Brite before choosing a ticket, otherwise you will be unable to cancel your ticket in the event that you cannot attend. http://spsnyc2011.eventbrite.com/

Ya gotta love NYC I cant wait to see everyone… Smile

-Ivan

 

Technorati Tags: ,

Restoring a Certificates Private Key without the CertReq

I had a client issue a CertReq awhile ago and forgot to publish this post from a SharePoint 2007 created IIS Virtual Server being used for Staging and when the WebApp was removed, the choice to delete the IIS Virtual Server was chosen though the Content Db was not.

Since IIS had lost the link to the CertReq and it had to be reestablished in order to mark the private keys as exportable… You can still use the Cert from the response but without the keys it’s not exportable to another server.

Best practice would be to use the Default IIS Virtual Server, since it should never be removed and on a system where there is not activity, import the response, export and protect with a password to be used again.

To assign the existing private key to a new certificate, you must use the Microsoft Windows Server 2003 version of Certutil.exe.

There are two ways to recover the certificate:

  • KRT.EXE & CERTUTIL

CERTUTIL is the built-in Command Line tool to administer a Windows 2003 CA from the command line. CERTUTIL has several switches for CA administration and Key Recovery.

KRT.EXE  The Key Recovery Tool (KRT.EXE) is a new tool which is part of the Windows Server 2003 Resource Kit Utilities. KRT is a GUI extension for the builtin Windows 2003 CA tool CERTUTIL. In this article, we will use the Key Recovery Tool (KRT).

CertUtil

  • 1. Log on to the computer that issued the certificate request by using an account that has administrative permissions.
  • 2. Click Start, click Run, type mmc, and then click OK.
  • 3. On the File menu, click Add/Remove Snap-in.
  • 4. In the Add/Remove Snap-in dialog box, click Add.
  • 5. Click Certificates, and then click Add.
  • 6. In the Certificates snap-in dialog box, click Computer account, and then click Next.
  • 7. In the Select Computer dialog box, click Local computer: (the computer this console is running on), and then click Finish.
  • 8. Click Close, and then click OK.
  • 9. In the Certificates snap-in, expand Certificates, right-click the Personal folder, point to All Tasks, and then click Import.
  • 10. On the Welcome to the Certificate Import Wizard page, click Next.
  • 11. On the File to Import page, click Browse.
  • 12. In the Open dialog box, click the new certificate, click Open, and then click Next.
  • 13. On the Certificate Store page, click Place all certificates in the following store, and then click Browse.
  • 14. In the Select Certificate Store dialog box, click Personal, click OK, click Next, and then click Finish.
  • 15. In the Certificates snap-in, double-click the imported certificate that is in the Personal folder.
  • 16. In the Certificate dialog box, click the Details tab.
  • 17. Click Serial Number in the Field column of the Details tab, highlight the serial number, and then write down the serial number.
  • 18. Click Start, click Run, type cmd, and then click OK.
  • 19. At the command prompt, type the following:

certutil -repairstore my serial# from item 17

Note: KRT works with a Microsoft CA. By default CertUtil defaults to using a CA and not the local Store. I haven’t tried to use the certutil -store command then using KRT this may work?

-Ivan

Technorati Tags: ,,

SharePoint 2010 How Do I Podcast Series with Hilton Giesenow

How Do I: Create a New Web Application and Site Collection in SharePoint 2010?

To get started with creating SharePoint sites for our users, we need to understand how to create the most basic containers for actual content – a Web Application and one or more Site Collections inside of it. Join Hilton Giesenow, host of http://www.themossshow.com/ SharePoint podcasts, as he demonstrates how to go about creating both of these and having a look at the IIS website it creates as well.

Podcast Series:
SharePoint Server: Connect People, Processes, and Information Subscribe Now WMA | MP3
The Future of Productivity: IT Professional Solutions Subscribe Now WMA | MP3

Download:
WMA | MP3 (13) To save to your computer, right click and choose ‘Save Target As…’.

How Do I: Use SharePoint 2010’s Health and Monitoring Features?

This video provides an overview of the health and monitoring features of SharePoint 2010.Demonstrates how to:Configure the Unified Logging Service Specify which events to log Specify how severe an event must be to be logged View the results of the Health Analyzer and use the information to resolve issues Enable the Developer Dashboard

Podcast Series:
SharePoint Server: Connect People, Processes, and Information Subscribe Now WMA | MP3
The Future of Productivity: IT Professional Solutions Subscribe Now WMA | MP3

Download:
WMA | MP3 (15) To save to your computer, right click and choose ‘Save Target As…’.

How Do I: Use the SharePoint 2010 Managed MetaData Service?

This video shows how to setup a Managed Metadata Service within SharePoint 2010.Demonstrates how to:Create a new Managed MetaData Service. Specify a site collection as a content hub How to configure other site collections to subscribe to the hub’s meta data. How to create metadata term sets using the Taxonomy Term Set tool. How to create a content type the utilizes term sets.How to publish a content type to make it available to subscribing sites. How to force propagation of meta data updates

Podcast Series:
SharePoint Server: Connect People, Processes, and Information Subscribe Now WMA | MP3
The Future of Productivity: IT Professional Solutions Subscribe Now WMA | MP3

Download:

WMA | MP3 (17) To save to your computer, right click and choose ‘Save Target As…’.

How Do I: Configure SMS Text Message Alerts in SharePoint 2010?

The alerting features in SharePoint allow users to be notified when items are added, changed or deleted from lists. In the past this has been in the form an email alert, but with SharePoint 2010 we can now receive SMS text message alerts directly to our mobile phones. In this video, Hilton Giesenow, host of http://www.themossshow.com/ SharePoint podcasts, demonstrates how to configure SharePoint to communicate via an external third-party’s OMS SMS services.

Podcast Series:
SharePoint Server: Connect People, Processes, and Information Subscribe Now WMA | MP3
The Future of Productivity: IT Professional Solutions Subscribe Now WMA | MP3

Download:
WMA | MP3 (7) To save to your computer, right click and choose ‘Save Target As…’.

How Do I: Configure Document Conversions in SharePoint 2010?

SharePoint Server includes the capability for SharePoint to convert user documents from one file type to another. In this video, Hilton Giesenow, host of http://www.themossshow.com/ SharePoint podcasts, demonstrates how to configure and monitor this Document Conversions feature, focusing on the out-of-box DOCX to ASPX file convertor.

Podcast Series:
SharePoint Server: Connect People, Processes, and Information Subscribe Now WMA | MP3
The Future of Productivity: IT Professional Solutions Subscribe Now WMA | MP3

Download:
WMA | MP3 (12) To save to your computer, right click and choose ‘Save Target As…’.

How Do I: Extend an Existing SharePoint 2010 Web Application?

This video shows how to extend an existing SharePoint 2010 Web Application to use an additional URL. Demonstrates how to: Extend an existing web site, Configure the extended site to use an additional URL, Remove the extended website from the web application.

Podcast Series:
SharePoint Server: Connect People, Processes, and Information Subscribe Now WMA | MP3
The Future of Productivity: IT Professional Solutions Subscribe Now WMA | MP3

Download:
WMA | MP3 (6) To save to your computer, right click and choose ‘Save Target As…’.

How Do I: Email Enable SharePoint 2010 Lists?

SharePoint’s incoming email system allows lists to receive email directly on unique email addresses and have these translate into new list items. In this video, Hilton Giesenow, host of http://www.themossshow.com/ SharePoint podcasts, demonstrates how to enable these settings in your farm and to configure your lists to be able to receive e-mails.

Podcast Series:
SharePoint Server: Connect People, Processes, and Information Subscribe Now WMA | MP3
The Future of Productivity: IT Professional Solutions Subscribe Now WMA | MP3

Download:
WMA | MP3 (15) To save to your computer, right click and choose ‘Save Target As…’.

How Do I: Configure an Alternate Access Mapping in SharePoint 2010?

Alternate Access Mappings (AAM) is a feature of SharePoint that allows a website to function correctly under different URL scenarios, including, reverse proxies and load balancing. In this video, Hilton Giesenow, host of http://www.themossshow.com/ SharePoint podcasts, demonstrates how to configure and make use of the this feature under different scenarios, including extending an existing site collection.

Podcast Series:
SharePoint Server: Connect People, Processes, and Information Subscribe Now WMA | MP3
The Future of Productivity: IT Professional Solutions Subscribe Now WMA | MP3

Download:
WMA | MP3 (9) To save to your computer, right click and choose ‘Save Target As…’.

How Do I: Backup and Restore a SharePoint 2010 Site Collection?

This video explains how to backup and site collection in SharePoint 2010 as well as how to restore a previously backup-up site collection. Demonstrates how to: Use SharePoint 2010 Central Administration to backup a site collection, Use SharePoint 2010 Management Shell to restore a site collection.

Podcast Series:
SharePoint Server: Connect People, Processes, and Information Subscribe Now WMA | MP3
The Future of Productivity: IT Professional Solutions Subscribe Now WMA | MP3

Download:
WMA | MP3 (8) To save to your computer, right click and choose ‘Save Target As…’.

How Do I: Work with SharePoint Solution Packages in SharePoint 2010?

The best practice for deploying SharePoint solutions is in the form of solution packages (WSP files). Once you have the package though, there are a few steps to installing, deploying and managing it as well as various approaches to doing so. In this video, Hilton Giesenow, host of http://www.themossshow.com/ SharePoint podcasts, shows us how to install, deploy and activate a Feature contained with a Solution and looks at 3 different ways to go about doing so.

Podcast Series:
SharePoint Server: Connect People, Processes, and Information Subscribe Now WMA | MP3
The Future of Productivity: IT Professional Solutions Subscribe Now WMA | MP3

Download:
WMA | MP3 (17) To save to your computer, right click and choose ‘Save Target As…’.

How Do I: Configure Business Connectivity Services in SharePoint 2010?

Business Connectivity Services (BCS), the successor to the Business Data Catalog (BDC) in Microsoft SharePoint Server 2007, provides the ability to connect to external systems and data sources and surface this data for use in SharePoint 2010. In this video, Hilton Giesenow, host of http://www.themossshow.com/ SharePoint podcasts, shows how to setup and configure a BCS connection and External Content Type and make use of it within an External List.

Podcast Series:
SharePoint Server: Connect People, Processes, and Information Subscribe Now WMA | MP3
The Future of Productivity: IT Professional Solutions Subscribe Now WMA | MP3

Download:
WMA | MP3 (15) To save to your computer, right click and choose ‘Save Target As…’.

How Do I: Restore Individual List Items in a SharePoint 2010 Site?

This video explains how to restore na individual list items in a SharePoint 2010 web site. Demonstrates how to: Activate & Configure the Recycle Bin, Delete an individual list item, Access the 1st Stage and 2nd Stage Recycle Bins, Restore a deleted item from the 2nd Stage Recycle Bin.

Podcast Series:
SharePoint Server: Connect People, Processes, and Information Subscribe Now WMA | MP3
The Future of Productivity: IT Professional Solutions Subscribe Now WMA | MP3

Download:
WMA | MP3 (7) To save to your computer, right click and choose ‘Save Target As…’.

This series of podcasts were originally published 08/02/2010 and should be of interest if your are new to SharePoint and would like to learn a few of the Basics…

-Ivan

Technorati Tags: ,

Site for Reviews of ThirdParty Software "SharePointReviews.com"

SharePointReviews.com is an independent product directory that provides SharePoint end-users, developers and administrators with objective expert reviews and opinions on SharePoint web parts, applications and development platforms. With searchable product listings, ratings and reviews it will help you find the most suitable SharePoint product within the shortest time. You can browse by categories, vendors, platforms and other parameters.

COMPLETELY INDEPENDENT AND VENDOR NEUTRAL

SharePoint Reviews is not affiliated with any vendor and does not receive any commissions/compensation from product listings or reviews. All operating funds come strictly from advertising, which would be distinctly marked on our site.

——————————————————————————–

There is always a place in my heart for a site of unbiased reviews on the growing number of third party products that exist in the market place. Registration is simple and will allow you to immediately start reviewing products…

I want to join Mike Fitzmaurice in saying: "Do the math: Third party Add-Ons are your friend" . In addition, if you remember when your only source of information on SharePoint were blogs then you know that it matters who writes the review….

enjoy

-Ivan

SharePoint Search Enhancements available on Codeplex

 

SharePoint sites

You want to crawl the content on a particular site collection on a different schedule than other site collections.

Crawl only the SharePoint site of each start address

clip_image001Note: This option accepts any URL, but will start the crawl from the top-level site of the site collection that is specified in the URL you enter. For example, if you enter http://contoso/sites/sales/car but http://contoso/sites/sales is the top-level site of the site collection, the site collection http://contoso/sites/sales  and all of its subsites are crawled.

In the Crawl Configuration section, select one of the following:

Exclude all items in this path. Select this option if you want all items in the specified path to be excluded from the crawl.

Include all items in this path. Select this option if you want all items in the path to be crawled.

If you chose to exclude all items in this path. Otherwise, you can further refine the inclusion by selecting any combination of the following:

Follow links on the URL without crawling the URL itself. Select this option if you want to crawl links contained within the URL, but not the URL itself.

Crawl complex URLs (URLs that contain a question mark (?)). Select this option if you want to crawl URLs that contain parameters that use the question mark (?) notation.

Crawl SharePoint content as HTTP pages. Normally, SharePoint content is crawled by using a special protocol. Select this option if you want SharePoint content to be crawled as HTTP pages instead. When the content is crawled by using the HTTP protocol, item permissions are not stored. This means that all items that match a particular search query appear on search results pages, regardless of whether the user that initiated the query has access to those items. The purpose of this setting is to enable search administrators to crawl remote SharePoint sites that they do not have explicit control over and therefore cannot enforce that the domain account used to crawl those remote sites has been granted full-read permissions on those sites.

Remember why Codeplex is so cool all of the features / solutions on Codeplex have the source code available..

 

Cheers,

-Ivan

Technorati Tags: ,,

SSIS SharePoint List Adapters

Sometimes even the easy things can be hard… It doesn’t matter how many times I attempt to explain how to use the SSIS Adapters available on Codeplex with source code and documented on MSDN I seem to fail. So this time I will include pictures… However, this post assumes you have read the SharePoint List Adapter Readme and the MSDN article..

This example uses two Calendars; Calendar is the source and Calendar.MSDN is the destination

After Installation and Configuration of VS2008 you should be able to complete the following:

1. Drag a SharePoint List Source & a SharePoint List Destination from your toolbox image

image

2. Fill in the Properties of the SharePoint List Source and drag the green connector to the Destination

    • SiteURL – The URL for the primary site on which the list is found. Do not include any other subfolders or list paths, or the location of an .asmxfile.
    • ListName – The name of the SharePoint list, as seen on the SharePoint list page.
    • ViewName – The name of the SharePoint list view from which you want to retrieve data. You can use a list view to pre-filter rows and eliminate the need to add dynamic CAML queries to your package.

Example List Source SiteURL http://trex-si-11, ListName Calendar, ViewName Calendar

imageimage

Example List Destination SiteURL http://trex-si-11, ListName Calendar.MSDN, ViewName Calendar

3. Next Map the Columns on the List Destination but do NOT Include ID if you want the Source to Create a Row on the Destination, Include an ID if you want the Source to Update the Destination..

imageimage

The rules are:

  • Create a Row (Modification Batch Type). A row is created on the server when you select this batch type and do NOT specify an ID value for a given row of data. Any columns that are not included receive the default values or a NULL value on the server.
  • Update a Row (Modification Batch Type). A row is updated on the server when you select this batch type and You MUST specify the ID of an existing row. Only the columns contained in the data flow are modified. If you specify this batch type, but the data flow does not contain any updated rows, an error is raised.
  • Delete a Row (Deletion Batch Type). A row is deleted on the server when you select this batch type and specify the ID of an existing row. If you specify this batch type, but the data flow does not contain any deleted rows, an error is raised.

Execute the Task and if its green your good to go. However, the rules above mean that you will probably need more than one Data Flow to handle the different scenarios

image

 

The MSDN Article By Kevin Idzi and the Readme should pretty much explain all you need to know so I have to wonder why I am explaining it again, for everyone who did not know the references…

 

 

-Ivan

Technorati Tags: ,,