Collaboration, Technology, and New York

The blog for SharePoint, InfoPath, and Designer, along with business and technology insight….. plus a little NYC

You are currently browsing the Microsoft category.

10 things a SharePoint Architect should know before they go contracting

This was a presentation that I did at SharePoint Saturday Boston 2016

SharePoint – How to go contracting from Peter Ward


Add a comment

Microsoft SharePoint 2013 Disaster Recovery Guide

The name of the game in of this SharePoint book is SharePoint Disaster Recovery (DR), which also falls into the category of business continuity or high availability. The depth and breadth of the SharePoint DR can be quite daunting because often the reader is new to SharePoint and does not quite know how the pieces of the puzzle all fit together and is facing the challenge of determining how to implement a DR within their organization.

This book is structured to fill in the SharePoint knowledge gaps of how to apply a SharePoint DR approach that is documented, easy to understand and is executable.

By applying knowledge from each chapter, this book will demystify the DR process and you will learn how to identify risk and appropriate DR approaches, and out of the box SharePoint tools for your DR plans.

Add a comment

2012: A Year of Microsoft Milestones

Add a comment

Changing the URL in a Links list: How To


You’ve just copied a link list template to another site collection, or performed a 2007 to 2010 migration and have realized that the all the urls in the list point to an old site and a mega cut and paste is required

So you think the data sheet can do the trick…. No

And MS Access can help….. Well no

I was surprised at this as well.

This post explains how to dump the list into Excel and run a macro to change the URL and then paste the new links into the list. This is easier than you think by using Excel a tool that you already have.

I’m not an Excel expert and there could be more elegant ways of doing this in Excel

Much of what is explained is in this Excel file: Example file


Dump the list into Excel.

  1. Click on the Export to Excel from the Ribbon in Excel.


  1. Create a macro in Excel.

See short video. To see how to create a macro. This could be anything. What is key is to create a macro that you can edit. See figure below:




  1. Edit the macro. Click the edit button on the dialog.

And paste in the following, macro code.

Sub ReplaceText()

‘ ReplaceText Macro

‘ Keyboard Shortcut: Ctrl+r


Call ReplaceHyperlinkURL(“”, “com”)

End Sub

The code above when run will replace the “” part of a URL with “com”. This could be anything really.

  1. Run the macro from the dialog box


All the cells will be searched and if there’s a match, it will replace the text.

Now that the URL’s have been changed.


  1. Copy and paste the URL’s in Excel back into SharePoint, using the datasheet view.

You just need to paste the URL column.

Add a comment

Alternate Access Mapping- explained

From technet

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 SharePoint podcasts, demonstrates how to configure and make use of the this feature under different scenarios, including extending an existing site collection

Add a comment

Useful technet resources

Services architecture planning for SharePoint Server 2010

Add or remove a service application connection to a Web application (SharePoint Server 2010)

 Logical architecture components for SharePoint Server 2010

Services architecture planning for SharePoint Server 2010

Add or remove a service application connection to a Web application (SharePoint Server 2010)

xtranet topologies for SharePoint 2010 Products: Model for SharePoint Server 2010

Hardware and software requirements for SharePoint Server 2010

Plan for backup and recovery in SharePoint Server 2010 (

Add a comment

SharePoint ECM- Going green event- ppt deck

Add a comment

Microsoft Monday

The publisher of my book sent me an email with what looks like a good promotion:

On Monday the 24th January, 2011 Packt Publishing is issuing five brand new Microsoft Books on a range of different subject matters:

  • Microsoft SQL Server 2008 High Availability
  • Microsoft Application Virtualization 4.5
  • Microsoft Forefront UAG 2010 Administrator’s Handbook
  • Dynamics AX 2009 Administration
  • Microsoft Dynamics Sure Step 2010
  • (Microsoft SharePoint 2010 Administration Cookbook)

A 25% discount when you purchase two or more Microsoft books throughout January.  

Of course I’m not sure why they sent me this email, when there’s only 5 days left in Jan and one Monday left in January!!!!!!

Click here for details.

Add a comment

Where Are the Original PC Programmers Now?


This article came across my in box. Today

In 1986, Susan Lammers did a series of interviews with 19 prominent programmers in a Microsoft Press book, Programmers at Work. These interviews give a unique view into the shared perceptions of accomplished programmers, the people who invented the tools you use today. In Programmers Who Defined The Technology Industry: Where Are They Now?, I tracked down the fate of these prominent developers — from Robert Carr (Framework) to Dan Bricklin (VisiCalc) to Toru Iwatani (author of Pac Man, I’m glad you asked). The article quotes the developers’ 1986 views on programming, the business, and the future of computing. In two cases (Bricklin and Jonathan Sachs, author of Lotus 1-2-3) I spoke with them to learn if, and how, their views had changed. One meaty example: In 1986, Bill Gates said, on Microsoft’s future: ‘Even though there’ll be more and more machines, our present thinking is that we won’t have to increase the size of our development groups, because we’ll simply be making programs that sell in larger quantities. We can get a very large amount of software revenue and still keep the company not dramatically larger than what we have today. That means we can know everybody and talk and share tools and maintain a high level of quality.’ At the time, Microsoft had 160 programmers.”

Bill Gates quote!!!!!! . How Microsoft keeps 30,000 programmers merely busy, let alone productive, creative, entrepreneurial is a challenge.

But look at the photo in the article. They don’t make them like this:

Add a comment

Microsoft by the numbers

From an official MS blog post. I think Apple and Google still have a long way to go.


Number of Windows 7 licenses sold, making Windows 7 by far the fastest growing operating system in history.

7.1 million

Projected iPad sales for 2010.

58 million

Projected netbook sales in 2010.

355 million

Projected PC sales in 2010.

100% Percent chance that CEO will mention Microsoft in a speech, panel, interview, or blog post.

MS have a bit of humour here 🙂

173 million Global Gmail users.

284 million Global Yahoo! Mail users.

360 million Global Windows Live Hotmail users.

299 million Active Windows Live Messenger Accounts worldwide.

Rank of Windows Live Messenger globally compared to all other instant messaging services.

$8.2 Billion Apple Net income for fiscal year ending Sep 2009.

$6.5 Billion Google Net income for fiscal year ending Dec 2009.

$14.5 Billion Microsoft Net Income for fiscal year ending June 2009.

$23.0 billion Total Microsoft revenue, FY2000.

$58.4 billion Total Microsoft revenue, FY2009.

Looks impressive, however as the NY Times pointed out :

Bing, its search engine, attracted 21.4 million new users in one year, Mr. Shaw says. Very well, but he does not mention the following: in 2007, the company’s online services group lost $604 million; in 2008, $1.2 billion; and in 2009, the year of Bing’s introduction, $2.25 billion.

Add a comment