Martin Hinshelwood's Blog

A Scottish dyslexic software developer: .NET architect, developer, evangelist, technology enthusiast and multi-dimensional free thinker


News

Disclaimer

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

Subscribe

Personal

Accreditation

Stats

My Stats

  • Posts - 255
  • Comments - 283
  • Trackbacks - 67

Twitter












Tag Cloud


Recent Comments


Recent Posts


Article Categories


Archives


Post Categories


Image Galleries


Blogs I read


Blogs of Friends


Blogs on VSTS


Multi-Dimentional Free Thinking Bloggers


Personal


Projects


November 2007 Entries

Community Credit and GeeksWithBlogs up a tree...


It is fantastic news that GeeksWithBlogs.net and Community Credit have now both said their vows and are now fully integrated with each other. Awww, so cute.

A long and happy integration to you both...

Now all we need is a child component to select the CC category from Windows Live Writer :)

 

posted @ Thursday, November 29, 2007 10:16 PM | Feedback (0) | Filed Under [ Social Networks Industry News ]


It's nice to be appreciated!


A few months ago I found a cool site called Community Credit. I did not understand the premise at first, but after seeing the prizes page, I thought, what the heak! Community Credit is the brain child of one David Silverlight, and yes, it is quite possible that "Silverlight" was named after him :). What is this wondrous site you may ask...Well, its part bragging, part recognition, and part prizes :)

I thought, "this is fantastic, getting prizes for what I am doing anyway", and started posing all of the things I have been involved in to do with technology.

In my second month of posting I tore the cartilage in my knee (Ouch!) and so with nothing to occupy my tiny brain and noting that David was looking for moderators I emailed him to see if I fitted the bill. And I did!

David just a nice recognition blog about it...thanks David...what about some extra credit :)

 

Technorati Tags:

posted @ Thursday, November 29, 2007 9:58 PM | Feedback (0) | Filed Under [ Personal ]


TFS Event Handler gets 3 stars from Accentient


All be it it is only popularity, but they are stars non the less...

Willy-Peter Schaub brought and update of the page to and I remembered that I had submitted the I built and headed over to take a look.

Its even second from the top smile_omg... makes me proud...

 

posted @ Wednesday, November 28, 2007 11:41 AM | Feedback (0) | Filed Under [ Visual Studio Team System Personal TFS Event Handler Industry News ]


Identity crisis


I am having a look at Microsoft's Identity Lifecycle Manager 2007 as a solution to our disparate user identity problem. Some of the bigger companies out there have solved this problem, and in many of the smaller companies it just does not exist, but we have many system that hold meta data about our employees. From HR systems to Active Directory and custom web based address books. Because of Aggreko's unprecedented growth these systems have outgrown our capacity to maintain the consistency of the data, with small groups responsible for each repository and everyone not knowing where ALL the repository's are or who controls them.

The idea of ILM server is to provide a single "metaverse" where all of the data is stored that has agents and adapters for all of the systems that you have. These agents and adapters are responsible for pulling and pushing the data between the stores in a consistent manor, so if HR in France updates a users job title it gets pulled into the "metaverse" and then pushed out to all of other system connected to ILM.

How Identity Lifecycle Manager 2007 Works

 

Out of the box ILM 2007 supports the following agents and connectors:

Network Operating Systems and Directory Services

Microsoft Active Directory Windows Server 2003 R2, 2003, and 2000
Microsoft Active Directory Application Mode Windows Server 2003 R2 and 2003
Microsoft Windows NT 4.0
IBM Tivoli Directory Server
Novell eDirectory 8.6.2, 8.7, and 8.7.x
Sun Directory Server (Netscape/iPlanet/SunONE) 4.x and 5.x

Mainframe

IBM Resource Access Control Facility
Computer Associates eTrust ACF2
Computer Associates eTrust Top Secret

Email and Messaging

Microsoft Exchange 2007, 2003, 2000, and 5.5
Lotus Notes 6.x, 5.0, and 4.6

Applications

SAP 5.0 and 4.7
Telephone switches
XML-based systems
DSML-based systems

Databases

Microsoft SQL Server 2005, 2000, and 7
IBM DB2
Oracle 10g, 9i, and 8i

File-Based

Attribute value Pairs
CSV
Delimited
Fixed Width
Directory Services Markup Language (DSML) 2.0
LDAP Interchange Format (LDIF)

All Other

Extensible Management Agent for connectivity to all other systems

But ILM supports way more than just data consistency. It will even provision Active Directory accounts and mail accounts automatically if an employee is added by HR enabling this process to be automated. You could have HR create a user in their system and set the relevant "profile" that the relates to the user and have their AD and mail setup along with permissions for SharePoint sites, folder shares and any other custom system you care to name smile_regular I like this system already... even if it only does half of what it says on the box it could be a very effective tool in the arsenal of any companies automation strategies.

A good point to note is wither the Data protection Act covers information about a person stored by the company they work for! I am not sure wither the same rules apply, but it is of benefit to any company if users details are accurate across all of their systems.

The benefits according to Microsoft's

propaganda marketing:
  • Improve Operational Efficiency
    Now businesses can aggregate identities across the enterprise into a single view, simplify user access to multiple applications, reduce IT costs, and increase productivity.
  • Boost Compliance
    Companies can ensure that every user has proper access to resources, create auditable processes for access rights, and deploy single sign-on capabilities that comply with company policy.
  • Heighten Security
    Businesses can reduce the risk of security leaks by ensuring that only authorized users can gain access to company resources and that people know who they are dealing with electronically.
  • Enable Business Success
    By securely sharing identities across organizational boundaries, businesses can collaborate more efficiently with partners and customers.

We will see! I am currently installing a dev box and I will evaluate it according to the specific needs of our business...

 

posted @ Wednesday, November 28, 2007 10:15 AM | Feedback (0) | Filed Under [ Microsoft Windows Software Industrial Revolution Industry News Work ]


Mozy Backup Space Gathering update


Well, I currently have two referrals :)

Thanks to Garrett Hoofman and who got their fingers out and ! Hopefully the others that have signed up with my referral link will complete a backup as well so we can all benefit (well me!) from the extra space.

Go on get an extra 250MB added to your 2GB of storage when you get Mozy online backup.

It seams that in order to clamed a referral bonus the referee needs to have completed at least one backup:

 

Referrals

User Status Date
Using Mozy 11/26/07
Garrett Hoofman Using Mozy 11/26/07
Giovanni P. Signed Up 11/26/07
Piotr Signed Up 11/26/07
M Signed Up 11/27/07
Peter Benschop Signed Up 11/27/07


Total space from referrals: 256 MB

People with a status of "Signed Up" have not yet backed anything up. You will receive your free space when they complete a backup. (Please allow 24 hours for your extra space to show up.)

Your referral URL: https://mozy.com/?code=8R96AG

I thought I should "name and shame" those that have gone only half way :)  Get backing up!

image

I only need another 300MB...so...

...My quest for more free backup space continues...

 

posted @ Tuesday, November 27, 2007 10:12 PM | Feedback (0) | Filed Under [ Microsoft Windows Personal ]


Mozy Backup


I was looking for an online backup solution and provided it for me: Thanks Scott and good luck with all the :).

These days, with all of your...lets call it "stuff" being mostly digital. The photos of the kids, your correspondence, all your work... You need backup...

I have been looking for a solution that does not brake the bank, but the best I could find was "BT" who charge and arm and a leg while probably losing your data. If the government can lose 7 million peoples personal details (du..post? How dumb can you get!) then BT can lose your backup. With Mozy being a smaller company, all be it partnered with someone bigger, loosing your data could brake them, so it is in their interest to provide the best service rather than best-effort as you would get from BT or another monolithic company that really does not care about your data, just your money...

image

I have only just started using Mozy Backup but I think it is a winner. With 2GB of free space (which never does the job :)) it is a fantastic solution. And it is only $5 for unlimited space, Wow...

It has a really simple setup, even my dad could work it, and just chugs away in the background. You get options (pictured above) for wither you want quicker backups or a faster computer, but with 2.5GB of data to get through I opted for the faster backup.

And speaking of data size, did you notice that I don't have enough space for a full backup? Well if you sign up using this URL https://mozy.com/?ref=8R96AG you get an extra 250mb, and so do I :)

image

Only 11 hours to go till I have a full backup :)

posted @ Monday, November 26, 2007 7:04 PM | Feedback (1) | Filed Under [ Microsoft Windows Personal ]


Event: MSDN: SharePoint for Developers (Edinburgh)


Better late than never, but I attended a MSDN event on Tuesday night in Edinburgh. Although I eagerly signed up for it, I did not expect to learn a lot:

Windows SharePoint 3.0 - Martin Parry

I am not usually a fan of Martin's speaking, but it seems that it might have been due to the content that I have heard him present in the past. maybe he just always got the short straw for the boring content at previous events I have attended, but this time I was presently surprised.

I found Martin's incite into SharePoint Services 2007 very informative and interesting and I learned the following key points about WSS3.0 that interested me:

  • Office SharePoint Designer is for users

Although SharePoint designer is the "new" front page, it is definitely for "power" users of SharePoint. Its ability to make simple Workflow easy and to allow the user more control over many facets of the sites and lists is invaluable. Granted this is not the tool for all users. Most users are content to point and click within SharePoint itself, but when that is not enough (and when you need a new type of workflow it is not), this is the tool that they will turn to. It works very like all of the office products with a friendly users interface and a default tendency to hide the code that may frighten a less experienced power user.

  • Not for relational things!

Martin pointed out that this is a mistake that many developers get into with SharePoint, and being one of those unfortunate developers who has tried to struggle with relational content, I agree with him that SharePoint does not handle it well. This is not a bad thing, just a limitation to be aware of. I have spent many hours trying to get a list in Site A to load content from another list in Site B, which is just not the way to do it...

  • SharePoint workflow with VS2008

The new SharePoint 2007 Workflow projects within Visual Studio 2008 look very impressive and beats the previous method in VS2005 hands down. You can find the new projects under the "Office" section of your chosen language in VS2008.

image

An introduction to MOSS 2007 - David Gristwood

This was the first time I had seen David perform on stage and I was quite impressed. He initially seams agitated, as he hops about on stage, but as the session unfolded it becomes just part of his presentation style. He gets very exited about the subjects he is talking about and can make even boring subjects seam interesting. Here are the cool things I found interesting:

  • Enterprise search is very cool

This is something that I knew already, but it was good to see a demo implementation and even a quick look at Microsoft's own internal implementation of Search within an organisation.

  • Search can search exchange and custom databases (BDC)

The ability to integrate BDC information into your search results, I think is invaluable. You could give users the ability to look up Customers or in our case Fleet units or products and link them all together. Very powerfully...

  • Use info path for forms

I had not really seen any info path implementation prior to this presentation, but I had played about with it and noted the lack of customisation and lack of direct integration inside of SharePoint. What David showed us however convinced me that if users need to fill out a form, it should be done in info path. It is a fantastic tool to add to the arsenal of SharePoint.

I found the whole thing very informative and I would recommend it to both novices and experts as it helped me fill in some of the blanks and gain incite into future improvements.

posted @ Friday, November 23, 2007 10:21 AM | Feedback (0) | Filed Under [ Sharepoint Work ]


Hold on lads, I have an idea!


lightbulb Something occured to me after seeing the Family Show application from Vertigo. If you have not seen this application it is definitely worth a look. What I want to achieve would be to display and allow the edit of company Higherarchical data through a similar interface to the one presented in Family Show.

image

The data would be centric around an employee, with data for Management, organisational and cost higherarchies. It would allow users to edit selected information about their subordinates and to create fictional reorganisations of the company. Users would be able to edit their own data and search for any user, group or organisational unit.

The data would be fed into a database after workflow on authorising the updates has been completed and would them make its way into all the other systems within the organisation including HR system, Active Directory and SharePoint.

smile_sarcastic So just a small task then...

It should be possible to get the project off the ground by providing a single point of truth for information on staff. This in conjunction with technologies like SharePoint and Communication Server should provide substantial business benefit to companies  holding data about its staff in multiple systems geographically.

 

posted @ Tuesday, November 20, 2007 2:11 PM | Feedback (0) | Filed Under [ Software Industrial Revolution Ideas ]


AD Update-O-Matic


In my quest to

play with test VB 9.0 and it very cool  features I created a little application to update Active Directory. I was asked by my boss (Andre) to get some sense of order into Active Directory for the users that will be involved in the proof of concept for MOSS 2007. So I immediately thought of an application to automate this.

The idea was to pull the information from AD for the selected users into a database and then make all the changes that are required there before updating AD with the new values.

This works very well, but I am unable to test most of the AD update procedures as I only have permission to update my own Office and telephone number fields; Which work just fine...

One of the guys from infrastructure are coming over this afternoon to run the application under his login, which will be a full test smile_omg I hope nothing goes wrong...

 

Technorati Tags: ,

posted @ Tuesday, November 20, 2007 1:51 PM | Feedback (0) | Filed Under [ Microsoft .NET Framework Work ]


VS2008 Update


Well it seems that Microsoft took the generally felt community suggestion and bundles Team Explorer with Visual Studio 2008 team Suit. I don't know if they did the same with VS2008 Pro or the other version, but it would seem a good idea.

I had a few problems uninstalling Beta 2, but I got there in the end and now have VS2008 RTM and MSDN installed, and I am just waiting for Team Explorer's install to complete.

Then I will see if all my projects from beta 2 need upgraded and wither the source control copes with it. I will defiantly try the upgrade in a branch to make sure I don't totally "gub" my projects smile_regular

This afternoon I will be attending a Microsoft event in Edinburgh "MSDN: SharePoint Developers" which should be interesting, and then I have a wee meeting with the folks in MS tomorrow to go over anything that was missed and to discuss my companies impending MOSS 2007 deployment.

A busy couple of days...

 

posted @ Tuesday, November 20, 2007 9:09 AM | Feedback (0) | Filed Under [ Microsoft .NET Framework Visual Studio Team System Sharepoint ]


RTM Confusion


I am a little confused by the RTM release of VS2008. I cant find a copy of the Team Explorer RTM or wither it is bundled with Team Suit. This would be a problem if I uninstalled everything only to find that I can't get my source control...

Does anyone know if Team Suit is bundled with VS2008 Team Suit?

When I was on MSDN earlier there was only one download and that was Visual Studio 2008 Team Suit. Now that have added more downloads, and the site is dead again :)

  • Visual Studio Team System 2008 Team Foundation Server Trial (x86 and x64 WoW) - DVD (English)
  • Visual Studio Team System 2008 Team Suite Trial (x86 and x64 WoW) - DVD (English)
  • Visual Studio Team System 2008 Test Load Agent Trial (x86 and x64 WoW) - CD (English)
  • Visual Studio 2008 Standard Edition (x86 and x64 WoW) - DVD (English)
  • Visual Studio 2008 Express Editions (x86 and x64 WoW) - DVD (English)
  • Visual Studio 2008 Professional Edition (x86 and x64 WoW) - DVD (English)
  • MSDN Library for Visual Studio 2008 (x86 and x64 WoW) - DVD (English)
  • Visual Studio Team System 2008 Team Foundation Server Workgroup Edition (x86 and x64 WoW) - DVD (English)
  • Visual Studio Team System 2008 Team Suite (x86 and x64 WoW) - DVD (English)
  • All the flavours are here, but no Team Explorer? Do I need to download Team Foundation Server just to get Team Explorer? Granted I need it anyway as I have a deployed instance of TFS Beta 2, but not at home :)

    And where is the .NET 3.5 redistributable... I have applications that are hot to trot but I can't roll out on Beta 2.

    Ah well, I will stow my impatience and wait...

    posted @ Monday, November 19, 2007 8:49 PM | Feedback (3) | Filed Under [ Microsoft .NET Framework Visual Studio Team System ]


    Get your RTM here!


    Well, its official. Visual Studio 2008 and .NET 3.5 went RTM this morning....

    So I will be spending the next wee while moving to the full release. if I can ever get the MSDN site to load. At the moment I have been waiting a couple of minutes for it, and no sign yet... That's everyone in the UK and probably European development communities hitting the site mercilessly. I know I will be...

     

    posted @ Monday, November 19, 2007 12:55 PM | Feedback (1) | Filed Under [ Microsoft .NET Framework Visual Studio Team System ]


    Where am I?


    I decided that I should have a go at this LINQ thing, so as .NET 3.5 will be RTM at the end of the month I am using LINQ and .NET 3.5 in my new Locator project.

    The Locator project is just a small application that will run on a users computer and tell a central server where they are. In Aggreko we have the problem that people are moving about a lot (everyone has a laptop) and when you are looking for someone you need to be able to find them.

    WhereAmI_Infrastructuer

    The application sits and poles the IP address of the local computer, and when it get an internal IP (i.e. not localhost) it will send that IP to a Windows Communication Foundation service for identification. If it is an IP that represents an internal company IP it sends back the detected location to the client and stores it in a database. The client then updates the physicalDeliveryOfficeName property in Active Directory and notifies the user of their location.

    image

    The information updated into Active Directory will then be visible on SharePoint and in any presence display.

    image image

    As you can see the SharePoint listing is considerably out of date. This is because of the Schedule associated with its import of profiles. it does not seam as if it can be done any more regularly than once a day smile_sad

    The LINQ comes to the forefront when I am updating the database from the service. LINQ made this incredibly easy, but produced some strange looking SQL.

     ' Get single value. This will execute the SQL
                Dim wai_Uip = (From val_uip In DataStore.WhereAmI_UserIPs _
                              Join val_ipm In DataStore.WhereAmI_IPMasks _
                                On val_uip.CurrentIP.Substring(0, val_uip.CurrentIP.LastIndexOf(".")) _
                                Equals val_ipm.Data.Substring(0, val_ipm.Data.LastIndexOf(".")) _
                              Join val_off In DataStore.WhereAmI_Offices _
                                On val_ipm.OfficeID _
                                Equals val_off.OfficeID _
                              Where val_uip.UserID = user _
                              Select val_off.Country, val_off.Name, val_ipm.Data).First

    Which produces this crazy SQL:

    SELECT [t2].[Country], [t2].[Name], [t1].[Data]
    FROM [dbo].[WhereAmI_UserIP] AS [t0]
    INNER JOIN [dbo].[WhereAmI_IPMask] AS [t1] ON SUBSTRING([t0].[CurrentIP], @p0 + 1, 
        (CASE 
            WHEN (CONVERT(Int,DATALENGTH(@p1) / 2)) = 0 THEN (CONVERT(Int,DATALENGTH([t0].[CurrentIP]) / 2)) - 1
            WHEN CHARINDEX(@p1, [t0].[CurrentIP]) = 0 THEN -1
            ELSE 1 + ((CONVERT(Int,DATALENGTH([t0].[CurrentIP]) / 2)) - ((CONVERT(Int,DATALENGTH(@p1) / 2)) + CHARINDEX(REVERSE(@p1), REVERSE([t0].[CurrentIP]))))
         END)) = SUBSTRING([t1].[Data], @p2 + 1, 
        (CASE 
            WHEN (CONVERT(Int,DATALENGTH(@p3) / 2)) = 0 THEN (CONVERT(Int,DATALENGTH([t1].[Data]) / 2)) - 1
            WHEN CHARINDEX(@p3, [t1].[Data]) = 0 THEN -1
            ELSE 1 + ((CONVERT(Int,DATALENGTH([t1].[Data]) / 2)) - ((CONVERT(Int,DATALENGTH(@p3) / 2)) + CHARINDEX(REVERSE(@p3), REVERSE([t1].[Data]))))
         END))
    INNER JOIN [dbo].[WhereAmI_Office] AS [t2] ON [t1].[OfficeID] = [t2].[OfficeID]
    WHERE [t0].[UserID] = @p4',N'@p0 int,@p1 nvarchar(1),@p2 int,@p3 nvarchar(1),@p4 nvarchar(20)

    Now that is nuts smile_omg

     

    posted @ Friday, November 09, 2007 10:47 AM | Feedback (0) | Filed Under [ Microsoft .NET Framework WCF ]