SharePoint Guidance: Released

Standard

Microsoft patterns & practices SharePoint Guidance has been released to MSDN!

http://www.microsoft.com/spg

Updated: SharePoint Guidance 1.0 – Nov 2008

Here are a few of the topics you will find inside:

  • Architectural decisions about patterns, feature factoring, and packaging
  • Design tradeoffs for decisions many developers encounter, such as whether to use SharePoint lists or a database to store information
  • Implementation examples that are demonstrated in the Training Management application and in the QuickStarts
  • How to design a SharePoint application for testability, create unit tests, and run continuous integration
  • How to set up different environments including the development, build, test, staging, and production environments
  • How to manage the application life cycle through development, test, deployment, and upgrading
  • Team-based intranet application development
  • You might also see my name, along with the names of a couple of others from Avanade, in the Authors and Contributors section. (Updated to refer to SharePoint Guidance 1.0 – Nov 2008)

    Service Level Dashboard for System Center Operations Manager 2007

    Standard

    Earlier this year I worked on a project with the Microsoft Solution Accelerator Team to develop what was released as the Service Level Dashboard for System Center Operations Manager 2007.

    The dashboard is a report that is installed into Operations Manager 2007 and is used to display availability and performance metrics related to SLA thresholds set by the administrator.

    Service Level Dashboard for System Center Operations Manager 2007

    Download

    I also recently noticed my name, along with the names of many others from Avanade, on the Acknowledgements page.

    MCTS: WSS 3.0 – Application Development

    Standard

    Last Saturday I was able to pass the 70-541 exam to earn the MCTS: Microsoft Windows SharePoint Services 3.0: Application Development certification. Not only will I be working on my MCPD certification this year, but also the WSS/MOSS certifications. Check my About page to see a list of my current certifications.

    New Xbox Live Gamertag

    Standard

    I updated my Xbox Live gamertag tonight from “alex00110101” to “NewGuid”, something a little more… globallyunique

    Appending binary to my name didn’t really gel with all of those non-technical folks out there. Hmmm… I guess they won’t be very familiar with the whole Guid concept either… oh well… at least it’s easier to tell people.

    SharePoint Guidance: Second Release

    Standard

    The second release of SharePoint Guidance from the Microsoft Patterns & Practices SharePoint Guidance team is now published on Codeplex at http://www.codeplex.com/spg.

    Updates included in this release:

    • Refactor code to leverage MVP pattern where applicable.
    • Refactor SPList-related SharePoint code with the Repository Pattern.
    • Unit tests for manager and presenter classes using TypeMock.
    • And much more…
    Disclaimer: This will evolve (and change) significantly. At this stage the RI provides a basic set of WSS features with accompanying guidance. This is not a CTP or a BETA.

    Stay tuned for new releases about every two weeks or so.

    SharePoint Guidance: First Release

    Standard

    The first release of SharePoint Guidance from the Microsoft Patterns & Practices SharePoint Guidance team is now published on Codeplex at http://www.codeplex.com/spg.

    Disclaimer: This will evolve (and change) significantly. At this stage the RI provides a basic set of WSS features with accompanying guidance. This is not a CTP or a BETA.

    Stay tuned for new releases about every two weeks or so.

    SharePoint Guidance: Intro

    Standard

    Microsoft Patterns & Practices

    Recently I started a new project with one of the teams in the Microsoft Patterns & Practices group in Redmond, Wa. For this project our team will provide guidance materials and a reference implementation. We are aiming to help SharePoint developers overcome some of the more difficult aspects of SharePoint development as well as help new developers with the initial 0 to 60 learning experience.

    Already we have started to look at development environments and team development scenarios as they related to SharePoint development. Watch for thoughts on those and more subjects here soon.

    Although we are a small team, we have built quite an elaborate build process for out team. Our current configuration includes developer/tester workstations running Windows Server, a continuous integration (CI) and build verification test (BVT) server running Team Foundation Server, as well as test, staging, and production servers. Look for a CodePlex site soon with some guidance on team-based SharePoint development utilizing a build server, which has turned out to be quite a challenge.

    This is how my Avanade laptop is currently configured for MOSS development:

    SQL Server: Interesting Function and Stored Procedure Behavior

    Standard

    The other day out at Microsoft I ran into some interesting behavior in SQL Server regarding the difference between running a query in a table-valued function versus running it in a stored procedure.

    This particular query I was trying to run selects columns from an existing view that is part a database of the Microsoft product that I am currently working with. Unfortunately, this is no ordinary view. This view not only has two nested select statements, it joins on a table holding thousands and thousands of records. Looking at the estimated execution plan was ridiculous, having probably 50 or 60 processes.

    Running this query in a table-valued function, basically just running the view, causes the CPU on the server to soar to 100% and Management Studio to basically timeout. However, placing the same query in a stored procedure yields almost instant results.

    I talked this over with the resident SQL guru on the project and all we could come up with was that, because of the complexity of execution plan, the pre-compilation of the query in a stored procedure makes all the difference.

    Windows Weekly with Paul Thurrott

    Standard

    “A weekly look at all things Microsoft including Windows Vista, Office 2007, and Xbox from the foremost Windows expert in the world, Paul Thurrott of the Super Site for Windows.”

    “Hosts: Paul Thurrott and Leo Laporte

    This podcast along with many other quality TWiT podcasts can be found on iTunes or on the TWiT Netcast Network website here: http://twit.tv

    I have been listening to Leo and Paul for a few month now and it is by far my favorite podcast. The issues that they discuss coupled with their natural chemistry make this podcast quite special.

    For me, it is the only way to get through the Monday commute between Seattle and Redmond.

    The First Project

    Standard

    Well, the training was finally over and the start of March brought the start of my first project as a consultant at Avanade.

    After a little bit of networking with a fellow WWU grad, I got onto my first project, and wouldn’t you know it, it’s at Microsoft. I am currently working in a small team as a UI developer working with ASP.NET, C#, and SSRS, which is quite an exciting opportunity considering ASP.NET and SQL Server are my bread and butter. There was only one problem.. I (and my trusty new laptop) had to be converted to the Microsoft religion before being able to do pretty much anything. So after a new laptop image, hours in software installs and reinstalls, badge creation, badge recreation, and a smart card reader I was finally fully capable of working at Microsoft.

    As developing on this project starts I have decided that I will be expanding the scope of my weblog to not only include life snippets but also some code snippets and developer thoughts that I find useful or interesting along the way.