Jul29
Categories: I made it to Seattle eventually. Had to go via Vancouver in the end and only just managed to check in for my connecting flight to Seattle with 1 minute to spare. There is no direct baggage transfer so I couldn't use the transfer lounge. Had to clear Canadian customs, wait for bag, exit agriculture (very lax compared to NZ where everyone's luggage gets scanned), lug it to the Air Canada ticketing counter to get a boarding pass then go through USA customs (in Canada – that was kind of cool), drop bags off, go through security, get on plane, never going that way again unless I stay a day or two in Vancouver.
For the last 3 nights I have not been able to sleep, not even a wink. I felt like I was going to fall asleep during the presentation I was giving at TechReady first thing this morning though and it probably showed.
Anyway, here are the links to some public resources I talked about in my session for any MSFT's who were there and wanted them.
Rather than letting SharePoint create sub-optimal databases, you can have a DBA create them in advance
http://technet.microsoft.com/en-us/library/cc262869.aspx
Plan for administrative and service accounts (yes, you need a minimum of 5 AD account to setup MOSS)
http://technet.microsoft.com/en-us/library/cc263445(TechNet.10).aspx
White paper: Planning and Monitoring SQL Server Storage for Office SharePoint Server: Performance Recommendations and Best Practices
http://go.microsoft.com/fwlink/?LinkID=105623&clcid=0x409
White paper: Database maintenance for Office SharePoint Server 2007
http://go.microsoft.com/fwlink/?LinkId=111531&clcid=0x409
Predeployment I/O Best Practices, SQL Server Best Practices Article
http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/pdpliobp.mspx
Single content db with many site collections and sub-sites can get badly fragmented user data and documents table index's.
See http://support.microsoft.com/kb/943345/ to REORGANIZE or REBUILD them
New SharePoint Central Administration UI tool to schedule locking/moving of Site Collections between content databases
http://www.microsoft.com/downloads/details.aspx?FamilyID=263cd480-f6eb-4fa3-9f2e-2d47618505f2
P.S. Hotel wireless sucks when there are 400 MSFT's trying to use it simultaneously. 1Kb transfer rate for me L
Jul25
Categories: One that I have been involved with for many years is still trucking along. I think I shared some numbers for this site back when wssdemo.com was running WSS 2.0.
This SPS 2003 Medium Server farm has 6 virtual server extended with WSS and a portal site that is only used for searching and the site directory. There are 16 content databases.
| |
Total Number of In-Use Sites: 1408 |
Total Number of Unused Sites: 328 |
Percent Large (250MB+): 28% |
Percent Medium (5-250MB): 35% |
Percent Small (5MB-): 37% |
|
Percent Frequently Visited (100+ visits per day): 15% |
Percent Rarely Visited (< 1 visit per day): 24% |
Percent Increasing in Popularity: 51% |
Percent Decreasing in Popularity: 49% |
Average Number of Visits per Site (in the past Month): 2777 |
Percent of Visits made to the Home Page: 15% |
|
Percent with a Customized (Unghosted) Home Page: 2% |
Percent that are Top-Level Sites: 59% |
.doc |
Total Documents: 243292 |
Average number in Version History: 1 |
Average Size: 511KB |
Average number of Visits per Document: 7 |
Percent of all Documents: 31% |
Percent of all Document Visits: 7% |
.xls |
Total Documents: 132471 |
Average number in Version History: 1 |
Average Size: 855KB |
Average number of Visits per Document: 11 |
Percent of all Documents: 17% |
Percent of all Document Visits: 6% |
.pdf |
Total Documents: 67929 |
Average number in Version History: 1 |
Average Size: 584KB |
Average number of Visits per Document: 10 |
Percent of all Documents: 9% |
Percent of all Document Visits: 3% |
Jul24
Categories: I have done that twice now. If you don't know what I'm talking about then all the better.
Both times I have done this when adding an entry in a rush before heading to the airport. For my punishment, the Wellington airport closed today just after I checked in due to bad weather and it was the first of 3 flights to get me to Seattle for TechReady. Tomorrow I set out again but via a different route. Wlg/AKL/YVL/SEA (22 hours start to finish, praying for an upgrade so that I don't have to endure economy)
Jul19
Categories:
Jul16
Categories:
Jul16
Categories: Tip: don't forget to tell the outsourcer that it is an Intranet site where you want to use all the collaboration features of SharePoint otherwise they might assume that you also want a master page based on the minimal master template which was intended for Web Content Management site only, removing all tables and using 100% CSS for layout. Wrong!
Jul14
Categories: I had set my W2K8 server that hosts the WSSDemo.com virtual farm (4 virtual servers) to automatically install Windows Updates including recommended updates. Looks like the WFE server didn't update before the host OS updated and the network adapter in the WFE virtual machine was no longer valid so it couldn't connect to Windows Update to get the latest Integration Services.
The solution is to add the Legacy Network Adapter to the VM so that you can get back to Windows Update.
For forward planners, the solution is to update all guests first and shut them down before updating the host as the save state files from the RC1 version are not compatible with RTM.
Anyway, this is why WSSDemo.com was down while I was asleep...
Jul13
Categories: SharePoint Designer is used to create page layouts but you must use the browser to create web pages based on a page layout. I found this rather frustrating with page layouts that include web part zones and trying to use Data View's in these pages.
A Data View could be created in a normal Web Part page, exported to a .webpart file and then imported onto the page layout page but every time you want to edit the data view you would have to go through this process. It is for this reason that I was never a big fan of Page Layouts on Intranet sites and just stuck with Content Editor Web parts (forgoing the versioning capability of a page based on a page layout).
Today I learnt something new about SharePoint Designer; it allows you to disconnect a page from its page layout so that you can edit the page.
This will copy all of the content from the page layout into the publishing page...
You can even reattach the page content to the page layout...
Although the warning dialog box says that all markup in the page will be deleted, content inside field controls and web parts still remains.
I just read the funniest thing on CMSWire with regards to rights management solutions.
"Microsoft SharePoint does have some digital rights capabilities built in to the platform but they certainly wouldn't be as robust as a third party solution."
What do you think?
Jul8
Categories:
If you are lucky enough to have Office Communicator deployed with telephony integration enabled you will have already seen the SharePoint functionality to initiate a telephone call with a document author or from the user profile page.
You can create a hyperlink in a web page or email message to initiate a call by using the tel: protocol. You can also enable this functionality in a SharePoint Contacts lists with the Data View web part. Just replace the <xsl:value-of select="@WorkPhone" /> with
Click to call: <a href="tel:{@WorkPhone}" ><xsl:value-of select="@WorkPhone" /></a>
While updating one of my Virtual Earth demos because Microsoft had turned off the older pre v6 map control API's, I decided to add this "click to call" functionality to the Office Locations contact list here http://www.wssdemo.com/demo . The map pin also allows you to initiate a call...
I will also be incorporating this into my Meeting Room demo that is about to be updated to provide maps with floor plans.
I don't know if this works with MSN Messenger or other VOIP products. Trry my number tel:+652068883209 but don't expect me to pay your phone bill (SharePoint rich text field doesn't like tel: hyperlinks :-(