#SPSVAN – SharePoint Saturday Vancouver 2010 – Successful Community Event

I just want to give a BIG SHOUT OUT to everyone who organized, presented, participated and attended VANSPUG‘s SharePoint Saturday in Vancouver (#SPSVAN). This is honestly one of the most organized, professional community I’ve attended in the last little while. All the sessions I attended were excellent, and yes – you do get that warm touchy-feely feeling after the event that kind of feels like you attended some kind of reunion (saw and talked to @jasonklatt too – we went to BCIT CST in the same batch! Although we were not in the same set, we were in the same labs).

Thank you to our presenters, including Todd Klindt (@toddklindt), Sean McDonough (@spmcdonough), Cathy Dew (@catpaint1) and Yaroslav Pentsarskyy (@spentsarsky) 🙂 who devoted time and energy in coming to Vancouver, and presenting excellent materials to the inquisitive Vancouver techie community.

I know it’s been a lot of work for everyone who made this happen, especially the event chairs Sherman Woo (@SPSherm) and Michal Pisarek (@MichalPisarek). But I can’t say enough that it’s been a GREAT event. They gave out lots of cool prizes:
Telerik Ultimate Suite Licenses
Critical Path Training voucher
– Amazon Kindles
– Dell LCD Monitors
– Microsoft keyboard/mouse
– Bamboo Store Certificate
– KWizcom Store Certificates
– Awesome SharePoint books – including Todd Klindt’s Wrox SharePoint Administration 2010 book, Sean McDonough’s SharePoint 2010 Disaster Recovery book, and Yaroslav Pentsarskyy’s (@spentsarsky) Top 60 Custom Solutions built on Microsoft SharePoint Server 2010 . … (yes, yes, all awesome books but Lady Luck was not with me today so I didn’t win any …)

Generous sponsors include AvePoint, Habanero Consulting Group, K2, Quest Software, WPCG, Colligo Networks, Idera – and in our own little way – Black Ninja Software. Shereen (blog | twitter) and I would have wanted to present as well, but sometimes 24 hours is just not enough in a day 🙂

As someone who is part of the community – thank you again – for making this happen. And I just want to reiterate – this is an excellent community event – to share knowledge and experiences – and I look forward to more in the future. I look forward to being more active myself in the future.

And if you happen to be reading my blog, let’s continue supporting VANSPUG. It’s a great community initiative.

Here’s just a few points worth noting in the sessions I attended:

Upgrading SharePoint 2007 to SharePoint 2010 by Todd Klindt

– Never have your only resume on SharePoint 🙂
– When upgrading, key type should be the same. Ie, Trial 2007 to Trial 2010, or Enterprise 2007 to Enterprise 2010
– Some goofiness even after visual upgrade, for example, broken breadcrumbs
– MySite upgrade is a whole different story. The MySite site collection is upgraded – but the MySite Host is not. Also, links in mysites do get lost ..
– (eherm) .. DBAs are sometimes not gracious hosts, so you need to plan when your DB detach/attach is going to happen.
– DB attach with AAM redirect – option for Terabyte databases/big sites and site collections
– PowerShell, baby! — when you’re upgrading multiple sites.

Saving SharePoint by Sean McDonough

– RPO (Recovery Point Objective), RTO (Recovery Time Objective), RLO (Recovery Level Objective)
– At the end of the day, the questions to ask are what does your business need to be back in the event of the disaster? What is the money you stand to lose if your system is down x amount of hours?
– Content is king. Protect your king.
– When applying Service Packs, patches and hotfixes, do a Central Admin backup before and after the patch.
– Your site collections can be big – terabytes big – SharePoint can handle that, but backup becomes the boundary. You just need to plan your backup and recovery. How long will it take for you to backup the whole thing?
– For big site collections, worth looking at Remote Blob Storage solutions.
– Be careful with VM snapshots and cloning. Always test, test, test. Consistency is key.
– SharePoint 2010 is mirroring aware.
– There is a PowerShell script that can help you document your SharePoint sites. It runs for a long time, but it’s worth it. Here’s the link (http://technet.microsoft.com/en-us/library/ff645391.aspx).
– Have confidence in your solution. And confidence is gained through testing.
– If you need to back up on the cloud, check RackSpace.

Making PowerShell Less Scary for the SharePoint Administrator by Todd Klindt

(I love PowerShell. It rocketh. To the nth degree. (Ok, ok, I know I sound very geeky. I’ll stop))
– Task driven learning is an effective way to learn PowerShell. Have a task at hand. See how that can be done in PowerShell.
– Your friends are Get-Help, Get-Command, Get-Member
– When doing EnumWebs, and you want to see all, use -LIMIT ALL
– Make sure you dispose any SP objects properly, use Start-SPAssignment -Global, then your code, then Stop-SPAssignment
– Few tasks you can do with SP and Powershell:
– Activate features across site collections
– Provisioning of Managed Accounts
– Create new sites
– Backup all site Collections

Creating Reports From SharePoint Lists Using SQL Server Reporting Services (SSRS)

Now that you have collected all your information in your SharePoint lists, your business users will want to see reports off them.

You may want to leverage SQL Server Reporting Services for this (I would! I’d love to use SSRS for all the reports I need to create!), but we know it’s not an easy task.
Your options are:
Continue reading

BlackNinja Posts: Invoking Javascript and Impersonating Users in SharePoint

I just wrote a couple of SharePoint posts at the Black Ninja Software blog:

How to Programmatically Impersonate Users in SharePoint
– this post shows how you can programmatically execute code in another user’s context, and you can do this by getting a handle to that user’s UserToken

How to Invoke Javascript Snippets Without Using RegisterClientScriptBlock
– this post shows how to invoke and change Javascript code without needing to register that code. This approach uses asp:Literal

And in case you missed this one:
SharePoint Readiness Checklist – Reposted

Victoria Code Camp Materials

Sorry I have been sick and out of commission for a week. The past few days, I’ve been drinking the meds the doctor gave me, which just really knocks me right out.

I apologize for the delay, but here are the materials, finally.


SharePoint 101

SharePoint 101 – Slides


SharePoint Web Parts

SharePoint Web Parts 101 – Slides

SharePoint Web Part Sample Projects:

1. Hello World Web Part

2. Simple Web Part with Custom Properties and Verbs

3. Connectable Web Parts

Enjoy! I’ll start blogging more again, as soon as I’m 100% better 🙂

Victoria Code Camp, January 26, 2008

I’m doing a couple of sessions at the Victoria Code Camp on January 26, 2008! Thank you to Nolan Zak for giving me this opportunity.

These are my two sessions:

SharePoint 101
This session will provide a high level overview of Windows Sharepoint Services 3.0 and Microsoft Office Sharepoint Server (MOSS 2007). This session will also cover demos of out-of-the-box Sharepoint components like: sites, lists, document libraries, and web parts.

SharePoint Web Parts
This session will cover Web Part concepts, and will walk you through creating custom ASP.NET Web Parts for SharePoint (MOSS 2007, WSS 3.0). Features will also be introduced towards the end of the session.

Schedule is posted at http://www.victoriacodecamp.com/SessionSchedule.aspx.
The list of speakers can be found at http://www.victoriacodecamp.com/CampSpeakers.aspx

Just posting the schedule here as well for your reference:

Morning Schedule
Victoria Code Camp 2008 - AM Schedule


Afternoon Schedule

Victoria Code Camp 2008 - Afternoon Schedule

As usual, I will be posting the materials I will use at the presentations. Hope to see you there! Beautiful Victoria, here I come!

DEVTEACH/VANTUG 2007 – Sharepoint Integration Presentation Materials

Yaroslav and I did a presentation at VANTUG on November 22, 2007 (Thanks to Graham Jones, President of VANTUG, for inviting us to speak!). As promised, here are the presentation materials. These are the same materials we are going to use for DEVTEACH on November 28, 2007.

As we mentioned in the presentation, we used a real business case as a basis for the demo. The solution in our project involved:
– Sharepoint as portal/framework (specifically MOSS)
– WCF for communication between Sharepoint and backend databases
– Custom Web Part for entry forms and client-side validation
– BDC for search and data display
– SSNS for notification and audit trails

Continue reading

VANTUG (Nov 2007) Sharepoint 2007 Integration Presentation

Here is the invite posted at the VANTUG site!

VANTUG Presentation

I will be posting all the materials soon 🙂

If you are looking for the DEVTEACH/VANTUG files, you can find them in this blog entry: DEVTEACH/VANTUG 2007 – Sharepoint Integration Presentation Materials

DevTeach/VANTUG Sharepoint 2007 Integration Presentation (Nov 2007): Resources

List of useful resources. Most of these I’ve used or read at some point, and revisited in preparation for the VANTUG/DevTeach demo. I hope this becomes useful to someone.

Building Your Dev Environment

Tony Zink. Creating a MOSS VPC Image: The whole 9 yards
http://www.pptspaces.com/sharepointreporterblog/Lists/Posts/Post.aspx?ID=28

Bill English. Installing a New Microsoft Office SharePoint Server 2007 Portal: Step-by-Step Instructions
http://mindsharpblogs.com/bill/archive/2006/06/27/1153.aspx

Sahil Malik. A Single Developer’s SharePoint 2007 Development Environment
http://blah.winsmarts.com/2007-10-A_Single_Developers_SharePoint_2007_Development_Environment.aspx

Custom Web Parts

Developer Introduction to Workflows for Windows SharePoint Services 3.0 and SharePoint Server 2007
http://msdn2.microsoft.com/en-US/library/aa830816.aspx

Sharepoint Web Parts Overview
http://msdn2.microsoft.com/en-us/library/ms432401.aspx

Windows SharePoint Services Web Part Infrastructure
http://msdn2.microsoft.com/en-us/library/ms415560.aspx

Walkthrough: Creating a Basic SharePoint Web Part
http://msdn2.microsoft.com/en-us/library/ms452873.aspx

Walkthrough: Creating Connectable SharePoint Web Parts
http://msdn2.microsoft.com/en-us/library/ms469765.aspx

Creating Web Parts in Windows SharePoint Services
http://msdn2.microsoft.com/en-us/library/ms367238.aspx

Working with the Windows SharePoint Services WebPart Class
http://msdn2.microsoft.com/en-us/library/ms473203.aspx

Channel 9 Video: Building ASP.NET Web Parts for Windows SharePoint Services 3.0
http://channel9.msdn.com/ShowPost.aspx?PostID=192071

15 Seconds: Building Web Parts for Windows SharePoint Services 3.0
http://15seconds.com/issue/060824.htm

15 Seconds: Building an ASP.NET 2.0 Web Part for Deployment to WSS V3.0 and MOSS 2007
http://15seconds.com/issue/060914.htm

Walkthrough: Creating an ASP.NET Web Part for the AdventureWorks Business Data Application Sample
http://msdn2.microsoft.com/en-us/library/ms558854.aspx

SharePoint Products and Technologies: Creating Custom Web Part Page Templates Sample
http://www.microsoft.com/downloads/details.aspx?familyid=48b2c899-db2c-4a93-aa95-af4a37fa8ae8&displaylang=en

Sahil Malik. Writing Custom Webparts for Sharepoint 2007
http://blah.winsmarts.com/2006/05/14/writing-custom-webparts-for-sharepoint-2007.aspx

SQL CLR

CLR Integration in SQL Server 2005
http://aspalliance.com/1081_CLR_Integration_in_SQL_Server_2005.2

Building my First SQL Server 2005 CLR
http://www.simple-talk.com/sql/learn-sql-server/building-my-first-sql-server-2005-clr/

Using Signed Assemblies for SQLCLR: Doing the Safety Dance
http://www.sqljunkies.com/WebLog/ktegels/articles/SigningSQLCLRAssemblies.aspx

BDC

MSDN: Business Data Catalog
http://msdn2.microsoft.com/en-us/library/ms563661.aspx

Business Data Catalog Samples
http://msdn2.microsoft.com:80/en-us/library/aa598181.aspx

Sahil Malik. SharePoint 2007: BDC – The Business Data Catalog
http://blah.winsmarts.com/2007-4-SharePoint_2007__BDC_-_The_Business_Data_Catalog.aspx

TechNet Virtual Lab: Getting Started with the Business Data Catalog in Microsoft Office SharePoint Server 2007
http://msevents.microsoft.com:80/CUI/WebCastEventDetails.aspx?EventID=1032331910&EventCategory=3&culture=en-US&CountryCode=US

OS303 – SharePoint Server 2007 Business Data Catalog: Integrating Line of Business Data and Applications into Enterprise Portals (OS303_Burke.wmv)
http://www.microsoft.com:80/downloads/details.aspx?FamilyID=5ec4193a-8061-4fd8-8ca4-574540049fe9&DisplayLang=en

Microsoft SharePoint Products and Technologies Team Blog: Business Data Catalog
http://blogs.msdn.com:80/sharepoint/archive/2006/04/18/578194.aspx

AdventureWorks SQL Server 2005 BDC Sample
http://msdn2.microsoft.com/en-us/library/ms494876.aspx

Troubleshooting Business Data Clients and Metadata
http://msdn2.microsoft.com/en-us/library/ms499588.aspx

Walkthrough: Using the Business Data Catalog Security Trimmer to Trim Search Results
http://msdn2.microsoft.com/en-us/library/bb447548.aspx

Business Data Catalog in Microsoft Office SharePoint Server 2007 and the Object Model
http://www.developer.com/mgmt/print.php/3705686

BDC Warnings and Error Messages
http://msdn2.microsoft.com/en-us/library/aa587877.aspx

SQL Server 2005 Notification Services

Building Effective SQL Server Notification Applications
http://www.simple-talk.com/sql/sql-server-2005/building-effective-sql-server-notification-applications-part-i/

SQL Server 2005 Notification Services Tutorial.
http://msdn2.microsoft.com/en-us/library/ms170337.aspx

MSDN Webcast: Introducing Notification Services in SQL Server 2005—Level 200
http://msevents.microsoft.com/cui/webcasteventdetails.aspx?eventid=1032263436&eventcategory=5&culture=en-us&countrycode=us

SQL Server 2005 Reporting Services and MOSS

Raju Sakthivel. Microsoft SQL Server Reporting Services – Installation and Configuration Guide for SharePoint Integration Mode (very good resource)
http://blogs.msdn.com/sharepoint/attachment/4194088.ashx

Microsoft SharePoint Products and Technologies Team Blog. Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007.
http://blogs.msdn.com/sharepoint/archive/2007/02/19/microsoft-sql-server-2005-sp2-reporting-services-integration-with-wss-3-0-and-moss-2007.aspx

How to: Configure SharePoint Integration on Multiple Servers
http://technet.microsoft.com/en-us/library/bb677365.aspx

How to: Configure SharePoint Integration on a Standalone Server
http://technet.microsoft.com/en-us/library/bb677368.aspx

Reporting Services Configuration How-to Topics
http://msdn2.microsoft.com/en-us/library/ms157412.aspx

Report Server How-to Topics (SharePoint Integrated Mode)
http://msdn2.microsoft.com/en-us/library/bb283321.aspx

SQL Server 2005 Reporting Services Tutorials.
http://msdn2.microsoft.com/en-us/library/ms170246.aspx

William Li. Service Account Configuration for Reporting Service
http://blogs.msdn.com/williaml/archive/2006/10/21/service-account-configuration-for-reporting-service.aspx

Tools and Utilities

Windows SharePoint Services 3.0 Tools: Visual Studio 2005 Extensions
http://www.microsoft.com/downloads/details.aspx?familyid=19f21e5e-b715-4f0c-b959-8c6dcbdc1057&displaylang=en

.NET Reflector
http://www.aisto.com/roeder/dotnet/

SQL Server 2005 Sample Databases (including AdventureWorksLT)
http://www.codeplex.com/MSFTDBProdSamples

SQL Server 2005 SP2
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/servicepacks/sp2.mspx

MOSS SDK – August 2007
http://www.microsoft.com/downloads/details.aspx?familyid=6d94e307-67d9-41ac-b2d6-0074d6286fa9&displaylang=en

BDC Editor (included in MOSS SDK – August 2007 Release)
http://www.microsoft.com/downloads/details.aspx?familyid=6d94e307-67d9-41ac-b2d6-0074d6286fa9&displaylang=en

BDC Metaman
http://www.bdcmetaman.com/

MOSS BDC Design Studio – Interesting Tool to Check Out for BDCs, and apparently doesn’t require for MOSS to be installed on the same box
http://www.simego.net/Walkthrough.aspx?Walkthrough=/Walkthrough/BDC-SQLServer-Walkthrough/BDC-SQLServer-Walkthrough.xml

Microsoft Virtual Server
http://www.microsoft.com/windowsserversystem/virtualserver/

Windows Powershell
http://www.microsoft.com/windowsserver2003/technologies/management/powershell/download.mspx

SharePoint Products and Technologies: Creating Custom Web Part Page Templates Sample
http://www.microsoft.com/downloads/details.aspx?familyid=48b2c899-db2c-4a93-aa95-af4a37fa8ae8&displaylang=en

Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies
http://www.microsoft.com/downloads/details.aspx?FamilyID=1E53F882-0C16-4847-B331-132274AE8C84&displaylang=en

Additional Resources

Application Templates for Windows SharePoint Services 3.0
http://technet.microsoft.com/en-us/windowsserver/sharepoint/bb407286.aspx

WSS How To’s
http://office.microsoft.com/en-us/sharepointtechnology/FX101494691033.aspx?ofcresset=1

MOSS How To’s
http://office.microsoft.com/en-us/sharepointserver/FX101211721033.aspx

Windows Powershell Script Repository
http://www.microsoft.com/technet/scriptcenter/scripts/msh/default.mspx?mfr=true

DevTeach/VANTUG Presentation: Resources

List of useful resources. Most of these I’ve used or read at some point, and revisited in preparation for the VANTUG/DevTeach demo. I hope this becomes useful to someone.

Building Your Dev Environment
Tony Zink. Creating a MOSS VPC Image: The whole 9 yardshttp://www.pptspaces.com/sharepointreporterblog/Lists/Posts/Post.aspx?ID=28
Bill English. Installing a New Microsoft Office SharePoint Server 2007 Portal: Step-by-Step Instructionshttp://mindsharpblogs.com/bill/archive/2006/06/27/1153.aspx
Sahil Malik. A Single Developer’s SharePoint 2007 Development Environment http://blah.winsmarts.com/2007-10-A_Single_Developers_SharePoint_2007_Development_Environment.aspx

Custom Web Parts
Developer Introduction to Workflows for Windows SharePoint Services 3.0 and SharePoint Server 2007 http://msdn2.microsoft.com/en-US/library/aa830816.aspx
Sharepoint Web Parts Overview http://msdn2.microsoft.com/en-us/library/ms432401.aspx
Windows SharePoint Services Web Part Infrastructurehttp://msdn2.microsoft.com/en-us/library/ms415560.aspx
Walkthrough: Creating a Basic SharePoint Web Parthttp://msdn2.microsoft.com/en-us/library/ms452873.aspx
Walkthrough: Creating Connectable SharePoint Web Partshttp://msdn2.microsoft.com/en-us/library/ms469765.aspx
Creating Web Parts in Windows SharePoint Services http://msdn2.microsoft.com/en-us/library/ms367238.aspx
Working with the Windows SharePoint Services WebPart Class http://msdn2.microsoft.com/en-us/library/ms473203.aspx
Channel 9 Video: Building ASP.NET Web Parts for Windows SharePoint Services 3.0http://channel9.msdn.com/ShowPost.aspx?PostID=192071
15 Seconds: Building Web Parts for Windows SharePoint Services 3.0http://15seconds.com/issue/060824.htm
15 Seconds: Building an ASP.NET 2.0 Web Part for Deployment to WSS V3.0 and MOSS 2007http://15seconds.com/issue/060914.htm
Walkthrough: Creating an ASP.NET Web Part for the AdventureWorks Business Data Application Samplehttp://msdn2.microsoft.com/en-us/library/ms558854.aspx
SharePoint Products and Technologies: Creating Custom Web Part Page Templates Samplehttp://www.microsoft.com/downloads/details.aspx?familyid=48b2c899-db2c-4a93-aa95-af4a37fa8ae8&displaylang=en
Sahil Malik. Writing Custom Webparts for Sharepoint 2007http://blah.winsmarts.com/2006/05/14/writing-custom-webparts-for-sharepoint-2007.aspx

SQL CLR
CLR Integration in SQL Server 2005http://aspalliance.com/1081_CLR_Integration_in_SQL_Server_2005.2
Building my First SQL Server 2005 CLRhttp://www.simple-talk.com/sql/learn-sql-server/building-my-first-sql-server-2005-clr/
Using Signed Assemblies for SQLCLR: Doing the Safety Dancehttp://www.sqljunkies.com/WebLog/ktegels/articles/SigningSQLCLRAssemblies.aspx

BDC
MSDN: Business Data Cataloghttp://msdn2.microsoft.com/en-us/library/ms563661.aspx
Business Data Catalog Sampleshttp://msdn2.microsoft.com/en-us/library/aa598181.aspx
Sahil Malik. SharePoint 2007: BDC – The Business Data Cataloghttp://blah.winsmarts.com/2007-4-SharePoint_2007__BDC_-_The_Business_Data_Catalog.aspx
TechNet Virtual Lab: Getting Started with the Business Data Catalog in Microsoft Office SharePoint Server 2007 http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032331910&EventCategory=3&culture=en-US&CountryCode=US
OS303 – SharePoint Server 2007 Business Data Catalog: Integrating Line of Business Data and Applications into Enterprise Portals (OS303_Burke.wmv)http://www.microsoft.com/downloads/details.aspx?FamilyID=5ec4193a-8061-4fd8-8ca4-574540049fe9&DisplayLang=en
Microsoft SharePoint Products and Technologies Team Blog: Business Data Cataloghttp://blogs.msdn.com/sharepoint/archive/2006/04/18/578194.aspx
AdventureWorks SQL Server 2005 BDC Samplehttp://msdn2.microsoft.com/en-us/library/ms494876.aspx
Troubleshooting Business Data Clients and Metadatahttp://msdn2.microsoft.com/en-us/library/ms499588.aspx
Walkthrough: Using the Business Data Catalog Security Trimmer to Trim Search Resultshttp://msdn2.microsoft.com/en-us/library/bb447548.aspx

Notification Services
Building Effective SQL Server Notification Applicationshttp://www.simple-talk.com/sql/sql-server-2005/building-effective-sql-server-notification-applications-part-i/
SQL Server 2005 Notification Services Tutorial.http://msdn2.microsoft.com/en-us/library/ms170337.aspx
MSDN Webcast: Introducing Notification Services in SQL Server 2005—Level 200 http://msevents.microsoft.com/cui/webcasteventdetails.aspx?eventid=1032263436&eventcategory=5&culture=en-us&countrycode=us

Reporting Services
Raju Sakthivel. Microsoft SQL Server Reporting Services – Installation and Configuration Guide for SharePoint Integration Mode (very good resource)http://blogs.msdn.com/sharepoint/attachment/4194088.ashx
Microsoft SharePoint Products and Technologies Team Blog. Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007.http://blogs.msdn.com/sharepoint/archive/2007/02/19/microsoft-sql-server-2005-sp2-reporting-services-integration-with-wss-3-0-and-moss-2007.aspx
How to: Configure SharePoint Integration on Multiple Servershttp://technet.microsoft.com/en-us/library/bb677365.aspx
How to: Configure SharePoint Integration on a Standalone Serverhttp://technet.microsoft.com/en-us/library/bb677368.aspx
Reporting Services Configuration How-to Topicshttp://msdn2.microsoft.com/en-us/library/ms157412.aspx
Report Server How-to Topics (SharePoint Integrated Mode)http://msdn2.microsoft.com/en-us/library/bb283321.aspx
SQL Server 2005 Reporting Services Tutorials.http://msdn2.microsoft.com/en-us/library/ms170246.aspx
William Li. Service Account Configuration for Reporting Servicehttp://blogs.msdn.com/williaml/archive/2006/10/21/service-account-configuration-for-reporting-service.aspx

Tools and Utilities
Windows SharePoint Services 3.0 Tools: Visual Studio 2005 Extensionshttp://www.microsoft.com/downloads/details.aspx?familyid=19f21e5e-b715-4f0c-b959-8c6dcbdc1057&displaylang=en
.NET Reflectorhttp://www.aisto.com/roeder/dotnet/
SQL Server 2005 Sample Databases (including AdventureWorksLT)http://www.codeplex.com/MSFTDBProdSamples
SQL Server 2005 SP2http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/servicepacks/sp2.mspx
MOSS SDK – August 2007http://www.microsoft.com/downloads/details.aspx?familyid=6d94e307-67d9-41ac-b2d6-0074d6286fa9&displaylang=en
BDC Editor (included in MOSS SDK – August 2007 Release)http://www.microsoft.com/downloads/details.aspx?familyid=6d94e307-67d9-41ac-b2d6-0074d6286fa9&displaylang=en
BDC Metamanhttp://www.bdcmetaman.com/
Microsoft Virtual Serverhttp://www.microsoft.com/windowsserversystem/virtualserver/
Windows Powershell http://www.microsoft.com/windowsserver2003/technologies/management/powershell/download.mspx
SharePoint Products and Technologies: Creating Custom Web Part Page Templates Samplehttp://www.microsoft.com/downloads/details.aspx?familyid=48b2c899-db2c-4a93-aa95-af4a37fa8ae8&displaylang=en
Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologieshttp://www.microsoft.com/downloads/details.aspx?FamilyID=1E53F882-0C16-4847-B331-132274AE8C84&displaylang=en

Additional Resources
Application Templates for Windows SharePoint Services 3.0http://technet.microsoft.com/en-us/windowsserver/sharepoint/bb407286.aspx
WSS How To’shttp://office.microsoft.com/en-us/sharepointtechnology/FX101494691033.aspx?ofcresset=1
MOSS How To’shttp://office.microsoft.com/en-us/sharepointserver/FX101211721033.aspx
Windows Powershell Script Repositoryhttp://www.microsoft.com/technet/scriptcenter/scripts/msh/default.mspx?mfr=true