Internal names of columns in SharePoint list

To find internal name of a column in a list you can use Visual Studio 2010 or SharePoint Manager 2010 (spm.codeplex.com) To get to Server Explorer CTRL W L and Select sharepoint connections and you can navigate down to the list in question. When running SharePoint Manager 2010 run as administrator and again you can navigate down to the list in question and determine the InternalName property of the column.

Exam 70-667: TS: Microsoft SharePoint 2010, Configuring

Today I passed the first half of the MCITP qualification, Exam 70-667: TS: Microsoft SharePoint 2010, Configuring

More details here.

Update 17 June 2011, I've now passed the other half of the MCITP qualification, Exam-70-668 PRO: Microsoft SharePoint 2010, Administrator.

I'm now MCITP SharePoint Administrator 2010.

More details here.

I'm now MCPD Microsoft SharePoint 2010

Today I passed this exam - Exam 70-573 -Microsoft SharePoint 2010, Application Development. More details here.

Together with the 70-576 exam I passed last month, I'm now MCPD Microsoft SharePoint 2010.

Exam 70-576 - Designing and Developing Microsoft SharePoint 2010 Applications

Today I passed this exam - Exam 70-576 - Designing and Developing Microsoft SharePoint 2010 Applications. More details here.

SharePoint 2010 upgrade

Some Useful stsadm/PowerShell

Pre upgrade audit

1. stsadm -o enumcontentdbs –url http://server01
2. stsadm -o enumallwebs
3. stsadm -o enumallwebs –includewebparts
4. stsadm -o enumsolutions
5. stsadm -o preupgradecheck
6. Test-SPContentDatabase -Name dbname -WebApplication http://server01

other

• stsadm -o setsitelock -url http://server01 -lock none
• stsadm -o addcontentdb -url -databasename
  make sure you spell databasename correctly

Some Useful links

Technet/Microsoft links

• Test-SPContentDatabase
• Attach databases and upgrade to SharePoint Server 2010
• Checklist for database attach upgrade (SharePoint Server 2010)
• Upgrade process overview (SharePoint Server 2010)
• Attach databases and upgrade to SharePoint Foundation 2010
• Upgrading to Microsoft SharePoint Server 2010 - Manual

Tools

• WssRemoveFeatureFromSite
• Upgrading to 2010: Feature and WebPart Inventory Reports

Blog posts

• SharePoint 2010 Upgrade: Test-SPContentDatabase - Key to Successful Upgrade
• SharePoint 2010 PreUpgradeCheck - Web Part Whack-a-Mole
• SharePoint 2010 Upgrade Simplified - Q & A
• SharePoint 2010 Upgrade: Test-SPContentDatabase - Key to Successful Upgrade
• Extracting dll’s out of the GAC
• Upgrading your Content Database to SharePoint 2010 – Database Attach method
• Checking for broken links in SharePoint
• Fix Pre-Upgrade Check errors
• List of all Windows SharePoint Services and SharePoint Server Pre-Upgrade Checker knowledge base articles

Windows Azure Training

I have just attended a 2-day partner training @ Saxons training centre in Sydney.
Instructor: Ryan CrawCour - Intergen NZ
@RyanCrawCour

The course was taken from presentations and labs within the Windows Azure Platform Training Kit. The kit includes a lot of Labs, Presentations, Videos and Demos. It also has a dependency checker to ensure local environment has all it needs to do Azure development.

The following powerpoint presentations were shown over the two days (they were 95% the same as the ones in the training kit)

1. Windows Azure Platform
2. Windows Azure Compute
3. Windows Azure Storage
4. Intro to SQL Azure
5. Windows Azure App Fabric
6. Storage Strategies
7. High Performance Applications
8. Advanced Web and Worker Roles and the Windows Azure VM Role
9. Windows Azure connect

Links - mentioned during course

• Windows Azure Platform Training Kit

Two recommended blogs

• Steve Marx
• Wade Wegner

Azure management links

• Azure Management Portal
• Azure database management
• Developer preview of App Fabric Labs
• App Fabric Labs

Other sites/articles

• Azure tools from LOKAD
• LOKAD on codeplex
• Windows Azure Market place - DataMarket
• Windows Azure Market place - Applications
• Azure Pricing
• Differences Between the Storage Emulator and Windows Azure Storage Services
• Smarx on Channel 9
• Sync Framework - SQL Server to SQL Azure Synchronization
• Ground to SQL Azure migration using MS SQL Server Integration Services
• Azure tools (Not free) - Cerebrata.com
• Windows Azure Table Storage – Not Your Father’s Database
• Partitioning Scheme (Azure Table Service)
• Shared Access Signatures Are Easy These Days
• Using the New Windows Azure CDN with a Custom Domain
• Programmatically Changing the AppPool Identity in a Windows Azure Web Role
• Windows Azure Connect from scratch video
• Windows Azure Virtual Network
• Channel 9 - Cloud Cover

JQuery Posts Updated to use JQuerify

• JQuery Predicates - Attribute contains
• JQuery Predicates - Attribute starts with
• JQuery Predicates - Attribute ends with
JQuery Predicates - Attribute equals
• JQuery - Count Paragraphs
• JQuery - Basic Show and Hide
• Learning Simple JQuery - Part 4. - There are many plugins developers have created to use with JQuery, including this one "tablesorter"
• Learning Simple JQuery - Part 3. - This example demonstrates using JQuery selectors to add css classes to specific html table row elements.
• Learning Simple JQuery - Part 2. - This example uses JQuery to set the background-color of input text boxes, and attaches the focus/blur events to those text boxes with a "required" class.
• Learning Simple JQuery - Part 1. - This example demonstrates using an jQuery id selector on anchor tags to attach a click event. It also uses an id selector to attach the slideDown and slideUp JQuery functions to a html div element.

• Here is a blog post from encosia.com on how to learn JQuery with FireBug

Prince2 Foundation Exam Success

Last week I went on PRINCE2 training in Sydney, I found it pretty interesting all in all at the end of which I took the PRINCE2 foundation exam and passed.

C# - yield

The yield keyword was introduced with C# 2.0.

Here is some further reading;

• from C# reference -yield (C# Reference)
  
• from stackoverflow - C# - Proper Use of yield return?
• from stackoverflow - What does “yield break;” do in C#?
• from stackoverflow - Yield keyword value added?
• from C# in Depth - Sample Chapter 6 - Implementing iterators the easy way

Visual Studio 2008 Shortcuts

Following on from earlier post - Visual Studio Keyboard Shortcuts

CTRL W S - Solution Explorer
CTRL W L - Server Explorer
CTRL W E - Error Explorer
CTRL W X - Tool Box
CTRL W O - Output Window

CTRL D I - Immediate Window
CTRL D C - Call Stack
CTRL D W - Watch Window

CTRL E F - Format Selection
CTRL E \ - Delete white space
CTRL E S - View white space
CTRL E C - comment selection
CTRL E U - uncomment selection

CTRL U - To Lower
CTRL Shift U - To Upper

CTRL + \ D - Code Definition Window
CTRL + \ M - Team Explorer

CTRL ALT B - Breakpoints window
CTRL ALT ↓ - Files Open List