Eamon Barker's eb.NET

Not quite vb.NET, but getting close!

Filter by APML
RSS Feed

Search

Profiles/Groups

Google Ads

Top Posts

Tags

Categories

Archive

Calendar

<<  March 2010  >>
SuMoTuWeThFrSa
28123456
78910111213
14151617181920
21222324252627
28293031123
45678910

Blogroll

Disclaimer

All postings are provided AS IS with no warranties, and confer no rights.

The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

© Copyright Eamon Barker 2010

CC License

Visitor Map

Locations of visitors to this page
Welcome to eb.NET... a place that I can keep the things that help me in my day, that might help you in your's!

UNPLUGGED MSDN update & HP-Microsoft SBS Road Show

Road show for the latest and greatest from MSFT & HP in the Small Business and Cloud-Based Services space

This post is for anyone in New Zealand that is interested in the latest and greatest from MSFT & HP in the Small Business and Cloud-Based Services space... If you haven't already done so, check out the following two events:

Both events are being run on the same day in most centres, with the HP-MSFT session in the morning and the unplugged session in the afternoon. For more details on both the events visit the NZ SBSC (Small Business Specialist Community) blog.

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5


System Administration Tools for SharePoint

A list of things I use to keep on top of SharePoint and its day to day running.

To follow on from my Development Tools for SharePoint post, I thought I would throw together a list of things I use to keep on top of SharePoint for its day to day running and making sure it is going to be able to cope after an install/upgrade.

Tool's Name Description
STSADM This would be the tool that I use the most when administering SharePoint.
STSADM is the command line utility that allows you to do any configuration/install/migration/anything task that you need to perform on your deployment. STSADM is more powerful than the Web UI and can perform some tasks that the Web UI can't.
Want to schedule a nightly SP back up? Using the STSADM command in a batch file attached to a scheduled task will give you that functionality!
A really good source for all the STSADM commands is Jose Barreto's blog on all the operations and parameters for STSADM
stsadmWin This was suggested in another post of mine, and I have had to add this to the list of tools I use to manage SP. STSADM is cool, this makes it a lot cooler! It is a must for any SP admin!
SharePoint Capacity Planning Tool This isn't a tool for monitoring a SharePoint deployment, but it is fantastic for planning a deployment and as such is a must in the tool kit! MSFT have done a good job on this tool and is something you should run if there is ever a company expansion or a shift in the way you use SP.
Best Practices Analyzer for SharePoint Where would we be without best practice's? This tool runs over your farm, applies best practice rules and produces a report giving you a heads up on where to improve the performance of your deployment. There is more information about the BPA on the SharePoint Team's blog.
SharePoint SUSHI

SUSHI = SharePoint Utility with a Smart, Helpful Interface

SUSHI is a powerful, user-friendly SharePoint application enabling you to accomplish common SharePoint administrative and development tasks. You can think of SUSHI as a Swiss army knife for SharePoint.

Microsoft SQL Server Manager I use this to "take care" of the SharePoint Databases. I use MSSM to manage the size of the database's for the various sites in an given farm.

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5


SharePoint Tip: Creating Multiple Sub-Sites with STSADM

Using STSADM to create multiple copies of one site!

In this post I will go cover the creation of a site using the STSADM tool. If you want to clone a few sites and re-create several copies of them this is the easiest way to do it. This is really handy if you have a base Project Management or Team Site that you want to use for a few different areas of your business!

STSADM Export - Exporting the base site

The first step of the process is to create a "template" for us to re-use when creating the copies. To do this we use the STSADM -o export command. Below is the syntax to do this. As always, I put this into a batch file so I have to change the directory to the 12 hive so I can run STSADM.

   1: cd %COMMONPROGRAMFILES%\Microsoft Shared\web server extensions\12\bin 
   2: REM Export the base site to a folder on the file system
   3: stsadm -o export -url http://yoursite/demosite/ -filename c:\SiteBase\ -includeusersecurity -versions 4 -nofilecompression -quiet 

Creating the Site and Importing the base template

The next part of the process is to create a base site and then import the "template" we exported above.

Note: Make sure you use the same site template for the createweb command as you used to create the base template! not doing so will cause an error and the import process will not work.

Below is the syntax to create the site and import the exported "template".

   1: cd %COMMONPROGRAMFILES%\Microsoft Shared\web server extensions\12\bin
   2: REM Create a site base
   3: stsadm -o createweb -url http://yoursite/NewSite -title "Demo Site Name" -sitetemplate STS#0 
   4: REM Import the template we exported 
   5: stsadm -o import -url http://yoursite/NewSite -filename c:\SiteBase\ -includeusersecurity -nofilecompression -quiet 

Now that we have this we can reproduce it to create multiple instances of the same site!

Currently rated 5.0 by 1 people

  • Currently 5/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5


SharePoint Tip: Upgrading a SharePoint (SP0) Content Database to SP1

Moving a SharePoint content database from SP0 to a deployment with SP1

If you have installed SharePoint (SP0) and you want to move a content database to a deployment running SP1 without upgrading the whole farm, read on!

First off, create a blank team site (Central Administration > Application Management > Create or extend Web application) and then follow the steps below.

When you attempt to attach the database through the central admin web interface, you might get hit with the following error:

Attaching this database requires upgrade, which could time out the browser session.  You must use the STSADM command 'addcontentdb' to attach this database.

To get around this, do what the error says...

  1. RDP to your SharePoint server
  2. Open the Command Prompt (Start > Run >CMD)
  3. Paste the following line into the prompt "cd %COMMONPROGRAMFILES%\Microsoft Shared\web server extensions\12\bin", this will take you to the 12 Hive
  4. Type the following command:
    stsadm -o addcontentdb -url http://SiteName -databasename WSS_Content_DATABASENAME -databaseserver DOMAIN\DATABASESERVER
  5. Hit enter, and all going to plan you will get: Operation completed successfully

To make sure, go to Central Administration > Application Management > Content Databases and it should be there. Take the origional database (the one created when you created the site) offline and make sure this one is the only one online. Navigate to your site and again, make sure it is all there!

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5


Differences between SharePoint Services and Office SharePoint Server Presentation Explained

A summary of the BoP SPUG presentation on the differences between WSS 3.0 and MOSS 2007.

I have had some comments from people that would like some explanation about the presentation I posted last week. So here are the main points of the presentation:

The Stack

WSS 3.0 can be thought of as the base of the whole solution. Everything that MOSS 2007 offers is built on WSS 3.0. I will go into what WSS 3.0 offers later in the post. The next layer in the stack is the MOSS 2007 Standard licence, again I will cover this later. At the top of the stack is the MOSS 2007 Enterprise licence. If you have WSS 3.0 and you require enhanced search, you can bolt in SharePoint Server 2007 for Search, giving you the features outlined in the Search section of MOSS 2007 Standard below. Also, if you need online forms, Forms Server 2007 can be bolted alongside MOSS 2007 Standard and WSS 3.0.

WSS 3.0

WSS 3.0 is your one-stop project/team portal, offering a lot in the way of team collaboration... features such as:

  • Wikis - Collaboratively create, edit, link, and organise the content of a web site
  • Blogs - Regular entries of commentary, descriptions of events, or other material such as graphics or video
  • Forums - Team Discussions, replacement for team e-mail discussions
  • Task and issue management
  • Presence and communication - Knowing who is online and how to get hold of them

WSS 3.0 also offers a much enhanced survey solution (as opposed to what was in 2.0), with branching logic and a nicer output screen. This is great for user surveys, feedback etc.

WSS 3.0 offers a bit in the way of search, but not much. It is fairly basic search and will return fairly relevant results. There is no ability to optimise the search or crawl other data sources.

Finally, WSS 3.0 integrates very tightly with the Office 2007 suite. As the image below shows, I have my tasks in Outlook, offering me a one stop shop for task, calendar and email management. As I work on several projects at the same time, it is really handy to see all of these in one place. As there may be several PMs on the different projects, they just need to log into the project site and they will see the progress of my tasks!

image

WSS 3.0 comes with a standard group of templates (Meeting, Team site, Document Sites), but there is a pack called the Fantastic 40 that can add some great sites to your WSS 3.0 deployment. Check out Ian Morrish's site for more details on the Fantastic 40.

WSS 3.0 has document management baked into it, something that was lacking in 2.0. All standard DMS functionality is out-of-the-box, including version control, check-in/out and the ability (linking with Outlook 2007) to take documents offline. WSS 3.0 also introduces Content Types, which are a great way to manage different types of documents, templates and metadata.

MOSS 2007 Standard

As mentioned above, MOSS 2007 Standard comes with all the features of WSS 3.0, but builds on it offering the following.

Portal

MOSS 2007 offers a portal environment as a replacement for the corporate intranet. Portals allows different groups of users the ability to publish information to the various divisional sites, taking the onus off the IT department to maintain sites.

Portals also give individuals their own space with the concept of a "My Site" being introduced. My Sites can be a total replacement for users' personal shared drives, giving them the ability to access their documents wherever they are. My Sites also allow users to publish information about themselves, which will increase the social network within an organisation (discussed more in collaboration).

MOSS 2007 offers a great deal more templates than WSS 3.0, including publishing portals and records repositories.

Search

MOSS 2007 allows us to crawl across multiple sources for information. For example, this means we can point the search crawler at a shared drive and let it index all the items on there. They would then appear along-side the items that are stored within SharePoint. Also, we can point the crawler at external Web sites. This means we can index industry-specific sites for information that will appear alongside our items.

MOSS 2007 offers increased relevance, meaning we can find the documents or items of data we want faster than with a WSS 3.0 deployment.

Another great feature MOSS 2007 has to offer is the People Search. This is a replacement for the corporate phone directory... think of it like a directory on steroids (see the collaboration section). As long as your AD is nice and tidy, the people search can be a great feature in MOSS 2007.

Collaboration

With the ability for users to enter information about themselves, this means more information is available to find people with. For example, on my site I have that I am an ASP.NET (web) developer, I use UML for modelling and I understand SQL. If a project manager was looking for a web developer that can understand the UML diagrams an architect has created, they can search for those traits in the people search and would come up with a list of people including me. Rather than hunting through IT for someone that understands UML they search and can fire me an email, or if we had Unified Communication Server, they could click on my name and give me a call.

Content Management

MOSS 2007 comes with several document workflows straight out-of-the-box. These include the feedback and approval workflows. These are great for cutting down the amount of documents being sent around an organisation. Instead this assigns a task to the reviewer and e-mails them a link to the document.

Document Management in MOSS 2007 has been aided with document policies and document management templates. Document policies allows record managers to set up retention periods for different content types, essentially managing the deletion and movement of a document through its life.

Finally, as mentioned in the portal section, content authoring and publishing in MOSS 2007 allows other business units to control the information on their sites. Content approval initiates a workflow to gain approval of a specified person or group before the content is published.

MOSS 2007 Enterprise

MOSS 2007 Enterprise is aimed at larger organisations, and gives the features mentioned above and builds on them with the following.

Business Process

The enterprise version offers Forms Server 2007 for publishing InfoPath forms on the web. Completed forms can be stored in forms libraries, where data from within that form can be displayed in columns. Completed forms can initiate workflow, meaning an application for leave can be completed online, a task assigned to the persons manager (AD lookup) and depending whether approval is given can proceed to HR.

Business Intelligence

A big thing to come in this version of SharePoint is the Business Data Catalogue (BDC). This allows SharePoint to look into other data sources (SAP, Oracle Financial, you HR system, etc) for information. This information can be displayed in search results, integrated into forms or documents or be used in a dashboard (see below).

MOSS 2007 Enterprise comes with a feature called Excel Services, which basically gives users the ability to publish their spreadsheets to the Web. If you have a spreadsheet that has a complex formula, you can keep that hidden and only allow others to enter information in the required fields. Excel services also allows graphs and table data to be published to the Web without any effort.

Business Data Web Parts and Dashboards give a great summary of information drawn from multiple sources, including Excel Services, Data warehouse Cubes and the BDC. An example of a dashboard is:

image

So which solution is best for you? I have a slide in my presentation that has  a good summary and needs matrix (page 26 and 27), but as a basic summary for MOSS, if you need any of the items in the right hand side, you'll need enterprise!

image

I hope that answers all the questions, if you want to know any more, post a comment and I should be able to answer it!

Currently rated 3.7 by 3 people

  • Currently 3.666667/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5