Wednesday, June 30, 2010

Geek Post Monthly Newsletter Volume 2 Issue 6

Geek Post

Volume 2 Issue 6

June 2010





































































Hippolite Musings

Tena Koutou Katoa,

This month I managed to:

  • Code in PHP for the first time in years;
  • Protest the Emissions Trading Scheme;
  • Complete my annual performance evaluation;
  • Watch a World-Cup football game (my first ever);

I’ve got a new motto: Boycott ‘Carbon-Neutral’ as a meaningless marketing term.

Blessings,
James


Community Development

Grenada Village Online

  • Simplified “Query Documents” page into “Search” page. 
  • Reduced number of text boxes to fill in down to just one Search field (as per Google). 
  • Modified business layer code to accommodate for one search term in multiple fields.
  • Learned how to include parentheses in SubSonic queries in the WHERE clause.
            public DAL.DocumentCollection GetData(


                string searchValue, 


                string audience)


            {


                _qry.From(DAL.Document.Schema);


                if (searchValue != null)


                {


                    _qry.WhereExpression(columns.DocumentName).ContainsString(searchValue);


                    _qry.Or(columns.Author).ContainsString(searchValue);


                    _qry.Or(columns.Purpose).ContainsString(searchValue);


                    _qry.CloseExpression();


                }


                else


                    return null;


                if (audience != null) _qry.And(columns.Audience).ContainsString(audience);


     


                _qry.OrderDesc(columns.DateWritten);


                _ret.LoadAndCloseReader(_qry.ExecuteReader());


                return _ret;


            }





Align Church Online




  • As above



Wellington Home Education Network




  • I was right: this website is probably on an Apache server, as it accepted a PHP page.


  • Coded an online Application Form which is processed server-side and sends a formatted email to an administrator.
    /* 
    Sends the mail and outputs the "Thank you" string
    if the mail is successfully sent, or the error string otherwise.
    */
    if (mail($email,$subject,$message,$headers)) {
    echo "<p>Your application form has been posted.</p>";
    } else {
    echo "<h4>Can't send email to $email</h4>";
    }








Developer News





Run the following in any database for some stats on your tables in SQL Server.




USE [DatabaseName]
GO
EXEC sp_table_count






Study News



My upgrade to Visual Studio 2010 on my laptop did not impact my study for MCTS Exam 70-503 (Microsoft .NET Framework 3.5 – Windows Communication Foundation) as much as I had originally anticipated, as the requirements for the study material includes Vista, which my Telecom-issued COE (common operating environment) does not contain!



So, I had to re-install a Virtual PC environment (thankfully I’m MCT and have one handily lying around) with Vista & Visual Studio 2008 installed.



Next problem was that the requirements for chapter 4 were for Internet connectivity.  Yes, I know that Virtual PC will enable Internet, but the MCT environment I was using (Course 6461A) did not allow for it, and for the life of me, I couldn’t work out how to make it work!  Very frustrating couple of days.  If anybody has any clues how to make this happen, I’d be grateful for a link.



Meantime, I was able to do Exercise 1 back in Visual Studio 2010 on my DEV PC (which has Internet connectivity), but not Exercise 2!  Exercise 2 introduce concurrency, and ran into the problem “cannot update control on a thread that did not create the object” error.  I didn’t manage to overcome this problem either.







Telecom News



Significant redundancies



Occurring around me at present. 



Sign of the times, unfortunately.





Microsoft News



This was (somewhat) useful (if slightly unprofessional):




ASP.NET MVC for Web Form Programmers



See the story of a Web Form developer who decided to take a closer look at this radical new approach to ASP.NET development











Situations Vacant



Parameter Manager



Stretch the limits



Lead and develop a high performing team and ensure continuous improvement of service delivery. Drive quality through the team's processes to support zero error tolerance. Utilise your commercial, analytical and business acumen and really stretch the limits. Ensure all framework, processes and tools are in place and used to develop people capability.



Our Parameters Management Group is responsible for the management and 'gate keeping' of parameters for internal Telecom billing systems to ensure a smooth end-to-end operation across our business from customer contact to bill presentation.  Have full accountability for managing a team of 'subject matter experts' on parameter changes during the feasibility, design, build and testing phase. With a solid understanding of the complexities of our business, assist in the design of future strategies, ensure the right capabilities within the team and allocate resources effectively.



Your previous leadership and people management skills mean you have the ability to ensure learning and growth within the team. You're capable of ensuring compliance and audit processes are adhered to. Your problem solving and negotiation skills are top notch as is your ability to work under pressure. You're strategically focussed on delivering results for the team and the wider business.



Our Parameter team is part of the Business Operations and Finance Group which sits in the Transformation, Technology and Shared Services Business Unit.  We're a centrally managed function primarily responsible for the delivery of Shared Services processing and accounting functions to the pan Telecom Group.  Join a high performing team that's professional and motivated.



Enterprise Architect



Are you an experienced Enterprise Architect?



It's a great feeling to be valued for your expert knowledge and advice.  Customers and colleagues alike look to you to show them the way. Join our Consulting and Design team and get the recognition you deserve.  



Your customers look to you to match high quality technical knowledge to their business drivers and provide valuable technology solution roadmaps.  Be the most trusted of advisors as you consult on the issues that matter to them. Work at a variety of levels, from presenting whitepapers to applying robust technical governance practices.



Significant experience in an ICT vendor environment is a given. Your knowledge of TOGAF and possibly other EA frameworks is robust, but you are also not a purist in how you deploy these methodologies.  Equally important as your Enterprise Architecture skill is your ability to relate technical solutions to business outcomes and to design and deliver should the need arise. You have excellent communication skills and a strong customer focus. Your experience with infrastructure strategic planning and technical evaluation is impressive.



Providing a breadth of services unparalleled in the New Zealand market, Gen-i is NZ's ICT market leader.  This Wellington-based role sits within our high-performing Consulting and Design team.  We help organisations generate greater value from their IT spend by offering innovative solutions for the issues important to them.



Be valued for your expertise.  Apply today.



Senior Technology Consultant - Capacity & Availability



Are you an expert in capacity & availability analysis across an extensive range of technologies?



It's a great feeling to be valued for your expert knowledge and advice.  Customers and colleagues alike look to you to show them the way. Join our Consulting and Design team and get the recognition you deserve.  



Your customers look to you to match high quality technical knowledge to their business drivers to create valuable technology solutions.  Be the most trusted of advisors as you consult on the issues that matter to them. Work at a variety of levels, from presenting whitepapers to the nitty gritty of technical designing.



Significant experience in an ICT vendor environment is a given. Your knowledge of infrastructure capacity & availability analysis across Windows, Unix\Linux and/or EMC Storage is robust.  Equally important as your superior technical design and delivery skills, is your ability to relate technical solutions to business outcomes. You have excellent communication skills and a strong customer focus. Your experience with infrastructure strategic planning and technical evaluation is impressive.



Providing a breadth of services unparalleled in the New Zealand market, Gen-i is NZ's ICT market leader.  This Wellington-based role sits within our high-performing Consulting and Design team.  We help organisations generate greater value from their IT spend by offering innovative solutions for the issues important to them.



Contact James if interested.







Training News





http://mcitpguide.net/how-many-people-are-already-mcitp-certified-worldwide/





INETA News



A summary of Significant Dot Net User Group Chatter




  • 02-Jun, Video Problems with VS2010, 6 replies


  • 15-Jun, Accessing Properties of Domain Objects, 23 replies


  • 22-Jun, TFS/VS 2010 Pricing, 13 replies


  • 22-Jun, FogBugz, 9 replies


  • 23-Jun, Xero Architecture, 13 replies


  • 25-Jun, Developer Laptop, 40 replies


  • 29-Jun, Problems Using DataContractSerializer, 6 replies


  • 30-Jun, Problem with WCF Study Material, 15 replies


  • 30-Jun, Microsoft’s confusing partner programme, 6 replies





PASS News



A summary of  Significant SQL Server User Group Chatter




  • 15-Jun, SQL Server Data Auditing, 7 replies


  • 17-Jun, 24 Hours of PASS Recordings Now Available, 0 replies


  • 21-Jun, Using FOR XML AUTO with a synonym, 0 replies





Events Schedule



In this section, I highlight dates, times and venues of events either I am presenting at, or of interest to Geeks.  I’m available for bookings.









































































Date Event Venue Speaker
8-Jul-10 Windows Phone 7 Development Massey University, Auckland Keith Patton
15-Jul-10 SharePoint 2010 Databases – what are they and why are they required? Intergen, Wellington Chandima
29-Aug-10 Code Camp (TBA) SkyCity Convention Centre, Auckland Lots
30-Aug-10 to 01-Sep-10 Microsoft TechEd 2010 SkyCity Convention Centre, Auckland Lots
8-11 Nov 2010 PASS Summit 2010 Seattle, Washington, USA Lots
April 2011 ALM Conference Wellington Various











Humour



Comments made in the year 1955!



That's only 55 years ago!




  • I'll tell you one thing, if things keep going the way they are, it's going to be impossible to buy a week's groceries for $20.00.


  • Have you seen the new cars coming out next year? It won't be long before $2,000.00 will only buy a used one.


  • If cigarettes keep going up in price, I'm going to quit. 25 cents a pack is ridiculous.


  • Did you hear the post office is thinking about charging 10 cents just to mail a letter


  • If they raise the minimum wage to $1.00, nobody will be able to hire outside help at the store.


  • When I first started driving, who would have thought gas would someday cost 29 cents a gallon. Guess we'd be better off leaving the car in the garage.


  • I'm afraid to send my kids to the movies any more. Ever since they let Clark Gable get by with saying DAMN in GONE WITH THE WIND, it seems every new movie has either HELL or DAMN in it.


  • I read the other day where some scientist thinks it's possible to put a man on the moon by the end of the century. They even have some fellows they call astronauts preparing for it down in Texas ...


  • Did you see where some baseball player just signed a contract for $75,000 a year just to play ball? It wouldn't surprise me if someday they'll be making more than the President.


  • I never thought I'd see the day all our kitchen appliances would be electric. They are even making electric typewriters now.


  • It's too bad things are so tough nowadays. I see where a few married women are having to work to make ends meet.


  • It won't be long before young couples are going to have to hire someone to watch their kids so they can both work.


  • I'm afraid the Volkswagen car is going to open the door to a whole lot of foreign business.


  • Thank goodness I won't live to see the day when the Government takes half our income in taxes. I sometimes wonder if we are electing the best people to government.


  • The drive-in restaurant is convenient in nice weather, but I seriously doubt they will ever catch on.


  • There is no sense going on short trips anymore for a weekend, it costs nearly $15.00 a night to stay in a hotel.


  • No one can afford to be sick anymore, at $35.00 a day in the hospital, it's too rich for my blood.


  • If they think I'll pay 50 cents for a hair cut, forget it.





Humour







PUNS FOR THE EDUCATED




  1. A thief broke into the local police station and stole all the toilets and urinals, leaving no clues. A spokesperson was quoted as saying, "We have absolutely nothing to go on."


  2. Evidence has been found that William Tell and his family were avid bowlers. Unfortunately, all the Swiss league records were destroyed in a fire... and so we'll never know for whom the Tells bowled.


  3. A man rushed into a busy doctor's office and shouted, "Doctor! I think I'm shrinking!" The doctor calmly responded, "Now, settle down. You'll just have to be a little patient."


  4. A marine biologist developed a race of genetically engineered dolphins that could live forever if they were fed a steady diet of seagulls. One day, his supply of the birds ran out so he had to go out and trap some more. On the way back, he spied two lions asleep on the road. Afraid to wake them, he gingerly stepped over them. Immediately, he was arrested and charged with transporting gulls across sedate lions for immortal porpoises.


  5. Back in the 1800's the Tate's Watch Company of Massachusetts wanted to produce other products, and since they already made the cases for watches, they used them to produce compasses. The new compasses were so bad that people often ended up in Canada or Mexico rather than California. This, of course, is the origin of the expression: "He who has a Tate's is lost!"


  6. King Ozymandias of Assyria was running low on cash after years of war with the Hittites. His last great possession was the Star of the Euphrates, the most valuable diamond in the ancient world. Desperate, he went to Croesus, the pawnbroker, to ask for a loan. Croesus said, "I'll give you 100,000 dinars for it." "But I paid a million dinars for it," the King protested. "Don't you know who I am? I am the king!" Croesus replied, "When you wish to pawn a Star, makes no difference who you are."


  7. An Indian chief was feeling very sick, so he summoned the medicine man. After a brief examination, the medicine man took out a long, thin strip of elk rawhide and gave it to the chief, telling him to bite off, chew, and swallow one inch of the leather every day. After a month, the medicine man returned to see how the chief was feeling. The chief shrugged and said, "The thong is ended, but the malady lingers on."


  8. A famous Viking explorer returned home from a voyage and found his name missing from the town register. His wife insisted on complaining to the local civic official who apologised profusely saying, "I must have taken Leif off my census."


  9. There were three Indian squaws. One slept on a deer skin, one slept on an elk skin, and the third slept on a hippopotamus skin. All three became pregnant. The first two each had a baby boy. The one who slept on the hippopotamus skin had twin boys. This just goes to prove that... the squaw of the hippopotamus is equal to the sons of the squaws of the other two hides.


  10. A sceptical anthropologist was cataloguing South American folk remedies with the assistance of a tribal Brujo who indicated that the leaves of a particular fern were a sure cure for any case of constipation. When the anthropologist expressed his doubts, the Brujo looked him in the eye and said, "Let me tell you, with fronds like these, you don't need enemas."







Sunday, May 30, 2010

Geek Post Monthly Newsletter Volume 2 Issue 5

Geek Post

Volume 2 Issue 5

May 2010

Hippolite Musings

Tena Koutou Katoa,

This month I managed to:

  • Upgrade to VS2010;
  • Had a birthday;
  • Attended a wedding;
  • Saw a movie (Iron Man 2);
  • Presented a guest lecture at VUW;
  • Attended a committee meeting (or 2);
  • Played some squash;
  • Took ownership of another community web site (my third);
  • Indoctrinated my kids into programming (with Scratch); and
  • Moved my home wireless modem from downstairs to upstairs.

Blessings,
James


Developer News

This is where I continue the saga of documenting my learnings from actually putting a web site “out in the wild” (I usually code within a nice, safe, Intranet).

In May I took ownership of my third community web site.  The three are (in order of ownership):

This one follows a radically dissimilar structure to the other two, as it appears to be totally static and the web server doesn’t appear to be IIS.  This may hinder my ability to bring active (dynamic) content.  I’ll have to test the limits of what the Wellington Community Network are offering us web masters.

Ah well, at least I’m being versatile.


Telecom News

I upgraded to Visual Studio 2010 on my laptop at work.  Yay!  However, it means that my study for MCTS Exam 70-503 (Microsoft .NET Framework 3.5 – Windows Communication Foundation) has to be done on my desktop at work (yes, I have two workstations - don’t envy me – although it is not on my desk so it is used by a contractor) as the labs don’t work on VS2010.

I have recommenced study, after a particularly busy few months.  Enjoying the break, caused by many projects being negatively impacted by the recent job losses.

I learned a lot more about connecting telephone and broadband at home than I had intended this month.  I had invited my Team Leader (a man with 35 years experience with the company) around to my place to help me move my modem upstairs.  I thought it would be a simple matter of replacing my single telephone jack-box in the dining room with a double telephone and broadband jack.  Turns out the dining room was wired directly from the Point of Entry (roadside cable) with telephone only, and we didn’t possess the special triangular screwdriver to get into the POE box to enable BB to that node.  So, we followed the BB cable and found it went from POE to master bedroom to downstairs.  So we had to enable BB from master bedroom to secondary bedroom (where a telephone jack existed).  From there, we were able to extend the BB (and telephone) through the wall into the lounge.  Now the modem resides in the lounge and reception is sweet as.  It took us 4 hours!

I won’t say I’m a qualified Telecom engineer now, but I have a lot more respect for wiring diagrams than I did before!


Microsoft News

Presented my “Designing & Developing Applications to Ensure Quality Code” lecture to a class of third year “Software Engineering” students at Victoria University again this month.  Lecturer Hui Ma informed me that last year’s class highly rated me, which is rewarding.  How is this related to “Microsoft News”?  Because my talk is very much based around the Microsoft Foundations architecture training for Solution Developers.


Situations Vacant

Solutions Architect – DEV0207S

Want to join a company that is innovative, passionate and thrives on providing cutting edge solutions to suit our client's needs?

Join our growing Voice & Contact Centre team as a Contact Centre Solutions Architect leading, solutions and design in Enterprise Information Technology solutions, specific to the Contact Centre environment.  As a subject matter expert in your field you will be an innovative leader driving, mentoring others to deliver to customer outcomes.

You will scope and manage ICT strategies and translate business requirements into technical solutions.  Your experience in a similar capacity coupled with industry knowledge of Banking/Finance and Logistics, along with a strong consulting and design background, will secure you this position.

Contact James if interested.


Training News

Took my kids to ScratchDay

Scratch Day is a worldwide network of gatherings, where people come together to meet other Scratchers, share projects and experiences, and learn more about Scratch.

Scratch is a programming language that makes it easy to create your own interactive stories, animations, games, music, and art -- and share your creations on the web.

As young people create and share Scratch projects, they learn important mathematical and computational ideas, while also learning to think creatively, reason systematically, and work collaboratively.

My assessment of the day (a Saturday afternoon) was it was very worth-while.  And not just because a lot of home-schoolers that we knew were there.  The hands-on, collaborative, one-on-one training each kid received got them started on some very quick and easy and rewarding little script writing.


INETA News

A summary of Significant Dot Net User Group Chatter

  • 6-May, CSS Cruncher (10 replies)
  • 6-May, PDF creation (5 replies)
  • 11-May, TechEd2010 Registrations are open! (10 replies)
  • 13-May, Sharepoint 2010 local install licensing (8 replies)
  • 18-May, Visual Studio 2010 (34 replies)
  • 19-May, Nhibernate and filtered collections (6 replies)
  • 21-May, TFS 2010 question (4 replies)
  • 25-May, CITCON ANZ 2010 sponsorship (4 replies)
  • 28-May, Windows Phone 7 Developer Training (4 replies)

PASS News

A summary of  Significant SQL Server User Group Chatter

  • 13-May, Report Builder 3.0 (4 replies)
  • 19-May, SQL Server 2008 R2 Management Studio (11 replies)
  • 19-May, Cannot open script editor in BIDS 2008 (3 replies)
  • 21-May, Error installing Sql Server 2008 R2 (4 replies)
  • 30-May, Job Vacancy – Senior DBA (2 replies)

Events Schedule

In this section, I highlight dates, times and venues of events either I am presenting at, or of interest to Geeks.  I’m available for bookings.

Date Event Venue Speaker
01-Jun-2010 Azure Boot Camp Microsoft, Auckland Chris Auld and Ryan CrawCour
02-Jun-2010 Azure Boot Camp Microsoft, Wellington Chris Auld and Ryan CrawCour
03-Jun-2010 Azure Boot Camp Intergen, Christchurch Chris Auld and Ryan CrawCour
15-Jun-2010 Windows 7 Phone Development Convention Centre, Christchurch Various
16-Jun-2010 Windows 7 Phone Development Microsoft, Wellington Various
17-Jun-2010 Windows 7 Phone Development Microsoft, Auckland Various
25-26 Jun 2010 Continuous Integration and Testing Conference Fronde, Queen’s Wharf, Wellington Various
29-Aug-10 Code Camp (TBA) SkyCity Convention Centre, Auckland Lots
30-Aug-10 to 01-Sep-10 Microsoft TechEd 2010 SkyCity Convention Centre, Auckland Lots
April 2011 ALM Conference Wellington Various


Humour

Great to be Kiwi

Young Rangi bought a donkey from a farmer for $100.

The farmer agreed to deliver the donkey the next day.

The next day he drove up and said, 'Sorry son, but I have some bad news. The donkey's died.'

Rangi replied, 'Well then just give me my money back.'

The farmer said, 'Can't do that. I've already spent it.'

Rangi said, 'OK, then, just bring me the dead donkey.'

The farmer asked, 'What are you going to do with him?'

Rangi said, 'I'm going to raffle him off.'

The farmer said, 'You can't raffle a dead donkey!'

Rangi said, 'Sure I can. Watch me.. I just won't tell anybody he's dead.'

A month later, the farmer met up with Rangi and asked, 'What happened with that dead donkey?'

Rangi said, 'I raffled him off. I sold 500 tickets at two dollars a piece and made a profit of $898'

The farmer said, 'Didn't anyone complain?'

Rangi said, 'Just the guy who won. So I gave him his two dollars back.'

Rangi now works for Telecom selling the new XT Mobiles 


Tuesday, May 11, 2010

Geek Post Monthly Newsletter Volume 2 Issue 4

Geek Post

Volume 2 Issue 4

April 2010

Hippolite Musings

Tena Koutou Katoa,

Stake in the ground: the April issue should come out at the end of April, documenting what happened in April.  (That decision was never necessary, when the newsletter used to be weekly on a Sunday documenting what happened in the previous week.)  So far, I’ve failed this test!

This month I managed to:

  • wrangle some more training;
  • attended a launch event;
  • took some unplanned leave;
  • made some deliveries;
  • started a new church (and website).

Blessings,
James


Developer News

Grenada Village Online

This is where I continue the saga of documenting my learnings from actually putting a web site “out in the wild” (I usually code within a nice, safe, Intranet).

In April I launched my new church website: Align Church Online

Essentially follows very similar structure to Grenada Village Online, but I suspect I shall be putting more time into this one, as I have a close team of interested individuals giving me plenty of advice about what next needs to go up.

Discovered a quick way to send up only the necessary changes:

  • Make my edits locally
  • Publish to local folder
  • Zip the local folder, being careful to exclude the web.config file and images folder.  (Web.config,  because I don’t want to overwrite the different connection string between DEV and PROD, and images folder in order to decrease the size of the zip file.  Since the images don’t change from update to update, there is no need to continually send them up.)  However, the slightest HTML change (let alone code behind) requires a recompile and the entire BIN folder to be updated.
  • I also delete the SubSonic.dll file from the zip archive, because although it is in the BIN folder, it doesn’t change from version to version.  And it’s comparatively large.
  • My ISP admin website allows for me to upload and unzip files to a folder.  By uploading the entire zip file into the web site root folder, I overwrite all files there, thus a quick and easy way to update my site.

There is one distinction I made between these two sites, which I think I need to retrofit into GVO:

  • When someone signs up with ACO, they are not granted any extra rights, until I go in as admin and assign them to a security group.
  • When someone signs up with GVO, they are automatically granted Membership.  I think this was a mistake.
  • Membership allows you to see the Directory of all other users.  Potentially, this is a security breach.

I made a couple of design decisions:

  • I had a number of photos and a video which we wanted to put up on our site.
  • I discovered that FaceBook has a 200 image limit per album.
  • I decided to upload approx. 600 images to FaceBook in 3 different albums for 3 different events, but make those images private to my friends.
  • Then I decided to upload only 12 of the best photos each for those 3 events and  make them public on the ACO website.
  • Then I converted the 90min video into 11 x 9 min (approx) clips.
  • Then I uploaded those clips to YouTube.
  • Then I created a page which lists, displays and names those 11 clips, on the ACO site.

Talk about using Social Media to our advantage!


Telecom News

Share Price Fell

Note: the following is my personal opinion.  I have no “extra” knowledge of Telecom business other than what is publicly known.

CEO made big announcement.  200 managers were going to lose their jobs in a massive scale-back.  That’s approximately 10% of the managerial layer, so expect management layoffs in May, and staff layoffs in June.

Personally, I’m not too concerned:

  1. Telecom sees itself as three components: Wholesale, Retail and Shared Services.
  2. I’m Shared Services.
  3. Whatever happens to the company, (i.e. apparently physical separation between Wholesale and Retail is a possibility), both will still need Shared Services.  We just might need to split up.
  4. My skills as a .NET Developer are still in demand elsewhere, if necessary.


Microsoft News

What I did for Microsoft this month

(I don’t work for them, but sometimes it feels like I do)

  • Attended Test Technologies Training event at Microsoft on Thursday 15 April.  Training by Jeremy Boyd.
  • Attended Visual Studio 2010 and Windows Azure launch event at Holiday Inn, Featherston Street on Friday 23 April with work colleagues.
  • Downloaded Visual Studio 2010 Ultimate edition.  I’ll install it next month.  Let you know how I get on.

Attempted to get to the bottom of why Telecom had a Team Foundation Server, but it’s only available in a Virtual Environment.  Let me explain:

  • Workgroup Solutions Team (WST, to which I belong) have exemption to be allowed to install and use Visual Studio IDE on our PCs in order to do our jobs.
  • However, Intranet Support (our sister team, with the same manager) do not have this exemption and must run Visual Studio in Virtual PCs.
  • Therefore, when they evaluated they had a need for Team Foundation Server (TFS), they were informed/advised the only way to achieve this was to install it on a separate domain from Telecom.
  • Therefore, they run this server on a separate domain, which is only accessible via wireless network on our floor of our building.
  • Therefore, they are unable to code from home.
  • Therefore, WST doesn’t want a bar of it.
  • But, WST does want TFS and wonders why we can’t install it on one of our servers.

But, if we were to install TFS on one of our servers would cause two issues:

  • Licensing, I imagine, because then there would be two instances of TFS. 
  • However, we can’t merely decommission the existing TFS because then Intranet Support wouldn’t be able to connect to our instance, because they’re all running Visual Studio on Virtual PCs!

Somehow, I surmise, somebody gave poor advice initially, and now we’re stuck with an untenable position.  Hopefully, Network Operations will hear of this, my tale of woe, take pity and remove restrictions from Intranet Support to be able to emulate the WST working environment.


Situations Vacant

Paradoxically, given the current restructure, there are plenty

Network Planner - Bring forward the future

Experience the challenges and complexities associated with working for New Zealand's largest access network services business.  As a key member of the Chorus team help manage our field services and access network (copper, fibre, ducts, radio, cabinets and exchanges) to better support our customers and give all service providers equal access to the local network through its exchanges.  Work alongside a team of true professionals responsible for developing projects to expand the capacity and the reach of the Chorus network.

Complex Provisioning Coordinator - Be the Oil in the Engine

Join this fun and supportive team responsible for handling managed provisioning requests for Chorus's customers and keep the pistons turning as you get to know all the latest network and data products.  You'll be an integral part of this team as you lead and develop end to end customer experience initiatives to achieve consistently superlative results!

Project Analyst - Portfolio Management Office

This position is being introduced within the Service Introduction Portfolio Management Office (PMO). The PMO is responsible for providing consistent management and reporting across all Service Introduction managed projects.


Training News

Learned all the new testing methodologies

Visual Studio 2010 integrates with a new tool for testers.  It looks sweet.  It’s not the VS IDE, so shouldn’t freak out non-coders, but it does integrate with TFS, so can create, edit, assign and close work items.

Also, it allows for very detailed recording of tests (including video!) so that developers can quickly see the error occurring and quickly diagnose it.

Also, it allows for testers to very easily set up a test harness and repeatable tests, so that regression testing is easier.

It’s got some instantly forgettable long name which I’ve been avoiding because I had to go look it up: Visual Studio 2010 Test Professional (remember: it has the name, but not the look and feel of the IDE).


INETA News

A summary of Significant Dot Net User Group Chatter

  • 01-Apr-2010 - Entity Framework (V4) Use – 18 replies
  • 12-Apr-2010 – SilverLight – 34 replies
  • 13-Apr-2010 - VS2010 is RTM - 54 replies
  • 14-Apr-2010 – SharePoint mail list? – 10 replies
  • 25-Apr-2010 – New VS2010 IDE Features – 14 replies
  • 28-Apr-2010 – Silverstripe CMS – 11 replies
  • 29-Apr-2010 – VS2010 IntelliSense Drop-Down Size – 24 replies

PASS News

A summary of  Significant SQL Server User Group Chatter

  • 07-Apr-2010 – Auckland SQL Saturday – 10 replies
  • 08-Apr-2010 – Wellington SQL Server User Group Meeting – Windows Azure – 6 replies
  • 09-Apr-2010 – Dynamics CRM – 5 replies
  • 21-Apr-2010 – What is the best alternates to avoid using Cursors? – 6 replies
  • 22-Apr-2010 – Protecting SQL Server Data – 4 replies

Events Schedule

In this section, I highlight dates, times and venues of events either I am presenting at, or of interest to Geeks.  I’m available for bookings.

Date Event Venue Speaker
06-May-10 BizTalk Roadmap DataCom Systems Myles Matheson
07-May-10 How to Code for Quality VUW Software Engineering class James Hippolite
18-May-10 NZ SharePoint Conference Bay of Plenty Lots
19-May-10 12:00 GMT 24 Hours of PASS Internet Lots
01-Jun-2010 Azure Boot Camp Microsoft, Auckland Chris Auld and Ryan CrawCour
02-Jun-2010 Azure Boot Camp Microsoft, Wellington Chris Auld and Ryan CrawCour
03-Jun-2010 Azure Boot Camp Intergen, Christchurch Chris Auld and Ryan CrawCour
29-Aug-10 Code Camp (TBA) SkyCity Convention Centre, Auckland Lots
30-Aug-10 to 01-Sep-10 Microsoft TechEd 2010 SkyCity Convention Centre, Auckland Lots

Humour

JACK was in the airport VIP lounge en route to Seattle some weeks ago when he noticed Bill Gates sitting comfortably in the corner, enjoying a drink.

Jack was meeting a very important client who was also flying to Seattle, but she was running a little bit late.

Well, being a straightforward kind of guy, he approached the Microsoft chairman, introduced himself, and said: “Mr Gates, I wonder if you would do me a favour.”

“Yes?”

“I’m sitting right over there,” Jack said, pointing to his seat at the bar, “and I’m waiting on a very important client. Would you be so kind when she arrives as to come walk by and just say, ‘Hi, Jack?’”

“Sure.”

He shook Bill Gates’ hand, thanked him and went back to his seat.

About 10 minutes later, Jack’s client showed up.

They ordered drinks and started to talk business.

A couple of minutes later, he felt a tap on his shoulder. It was Bill Gates.

“Hi, Jack,” he said.

Jack replied: “Get lost Gates, I’m in a meeting.”


Monday, March 29, 2010

Geek Post Monthly Newsletter Volume 2 Issue 3

Geek Post

Volume 2 Issue 3

March 2010

Hippolite Musings

Tena Koutou Katoa,

Looking forward to the Visual Studio 2010 launch in April.  Finding it hard to find time to study for my next exam.  

Blessings,
James


Developer News

Grenada Village Online

This is where I continue the saga of documenting my learnings from actually putting a web site “out in the wild” (I usually code within a nice, safe, Intranet).

In March there wasn’t time nor a requirement to implement any new code.  However, I did have time to make a proposal to the Chairman.  Now that we’ve got a database, and a method to authenticate/authorise users, we could allow residents to view/book use of the community hall.

This would be a radical departure from Standard Operating Procedures.  We need a meeting to discuss.  Stay tuned.


Telecom News

Got a new CTO

My hierarchical structure now looks like this:

Dr Paul Reynolds
CEO Telecom

-->David Havercroft
-->Group CTO Transformation, Technology & Shared Services

---->Marc Rackett
---->GM Shared Business Delivery – IT & Internal

------>Trevor Coles
------>HO Application Delivery

-------->Steven Burke
-------->Manager Online Delivery


Microsoft News

What I did for Microsoft this month

(I don’t work for them, but sometimes it feels like I do)

  • Filled in Partner Survey
  • Updated MCT Blog Roll
  • Attended Dot Net User Group meeting
  • Got a freebie t-shirt (thanks Microsoft!) which says “MS-DOS” (say what?)
  • Started training myself on Exam 70-503, Microsoft .NET Framework 3.5 – Windows Communication Foundation
  • That’s enough!


Situations Vacant

Senior Category Specialist – Corporate - STR0204N
Take tactical procurement to a new level in our Procurement Category Management function. Helping shape world class procurement practices. Work horizontally right across categories and suppliers ensuring that we bring together new developments. Deliver leading strategic category management activity that enhance our corporate sourcing activity and enable us to transform the way we deliver to our customers!

Senior Payables Specialist - FIN020GS
Let your enthusiasm and sense of achievement shine through as you develop your commercial understanding and steer your abilities towards being part of this dynamic, fun and tight knit team. Immerse yourself in this accounting environment, demonstrating your natural flair and confidence dealing with numbers. Come and find out where this role could lead you, the options are there for the taking - see where your potential lies!!

If any of my non-Telecom friends are reading this and interesting in any of the above, then drop me a line so we can discuss eligibility and suitability.


Training News

Got invited to Visual Studio 2010 C# Beta Training

At: Auldhouse Wellington

On: April 26-30

By: Invitation only

To register interest: drop me a line.


INETA News

INETA stands for the International .NET Association

It’s the umbrella group for all Dot Net User Groups world-wide.

I’ll try to find new stuff of interest to post here each month.

Last week, we had a report back from Ryan Tarak of Microsoft about the recent MIX conference in Las Vegas.  Here’s the blurb:

With MIX10 around the corner, it’s no better time for Microsoft to get on the road and showcase some of the highlights from this year’s conference held in Las Vegas. Join us at your local Community User Group where we will focus on some of the key highlights including; the future of Mobile™, Silverlight™, Internet Explorer®, Expression®. Ryan Tarak, from Microsoft New Zealand will be travelling all over NZ spreading the good word and also be getting everyone ready for the launch of Visual Studio 2010 by giving the first 30 members at each event a retro Microsoft t-shirt. We will also be providing content from MIX on DVD’s and also the usual pizza, so make sure you block out the date below.


PASS News

I’m not speaking at Auckland SQL Saturday in April…

On Saturday 10 April at Wolters Kluwer, 41 Centorian Drive, Mairangi Bay, North Shore.

My topic (Microsoft Sync Framework) was rejected.  I find it difficult (as a full-time Web Developer) to find topics of relevance to Microsoft SQL Server Database Administrators.

If you’re in the area, you should still go; Ivan Towlson will be talking on LINQ again.


Events Schedule

In this section, I highlight dates, times and venues of events either I am presenting at, or of interest to Geeks.  I’m available for bookings.

Date Event Venue Speaker
31-Mar-2010 Visual Studio Team System (VSTS) 2010 Xero,  Wellington    

Mark Carroll

10-Apr-2010 SQL Saturday

Wolters Kluwer, Auckland

Various
14-Apr-2010 Wellington:SLUG Xero, Wellington

Sky Sigal

22-Apr-10 Microsoft Visual Studio 2010 Launch All Over The World Various
21-23 April 2010 PASS European Conference Neuss, Germany Various
18-May-10 NZ SharePoint Conference Bay of Plenty Lots

Humour

Why I’m generally sceptical of all statistics

Three econometricians went out hunting, and came across a large deer.

The first econometrician fired, but missed, by a meter to the left.

The second econometrician fired, but also missed, by a meter to the right.

The third econometrician didn't fire, but shouted in triumph, "We got it! We got it!"


Tuesday, March 23, 2010

Geek Post Monthly Newsletter Volume 2 Issue 2

Geek Post

Volume 2 Issue 2

February 2010

























































Hippolite Musings

Tena Koutou Katoa,

Still catching up on stuff I did last month.  It’s been hectic at work, so taking a breather to document it all seems good to me.

Blessings,
James


Developer News

Grenada Village Online

This is where I continue the saga of documenting my learnings from actually putting a web site “out in the wild” (I usually code within a nice, safe, Intranet).

In February I learned how to upload documents to a database, without having to upload the file to the server first. 

  • I had always assumed that using the FileUpload control, I had to copy the file from the client to the server first, in order to grab the file on the server and push it into the database.
  • However, in a managed server environment (e.g. utilising an Internet Service Provider) I do not have permission to write files to the server.
  • I now realise that assumption was false.
  • Here is the completed (presentation) code:
   1:  Protected Sub Submit_Click(ByVal sender As Object, _


   2:                             ByVal e As System.EventArgs) _


   3:                             Handles Submit.Click


   4:      If Page.IsValid() Then


   5:          DocumentLogic.Insert()


   6:      End If


   7:  End Sub


   8:   


   9:  Protected Sub DocumentLogic_Inserting( _


  10:      ByVal sender As Object, _


  11:      ByVal e As ObjectDataSourceMethodEventArgs) _


  12:      Handles DocumentLogic.Inserting


  13:   


  14:      Dim iod As IOrderedDictionary = e.InputParameters


  15:      iod("documentName") = TitleTextBox.Text


  16:      iod("attachment") = FileUpload1.PostedFile.InputStream


  17:      iod("documentType") = FileUpload1.PostedFile.ContentType


  18:      iod("userName") = AppState.UserName


  19:  End Sub




 


Then, the business layer looks like this:




   1:  [System.ComponentModel.DataObjectMethodAttribute(


   2:      System.ComponentModel.DataObjectMethodType.Insert, true)]


   3:  public bool Add(


   4:      string documentName,


   5:      string documentType,


   6:      string author,


   7:      string audience,


   8:      string purpose,


   9:      DateTime? dateWritten,


  10:      Stream attachment,


  11:      string userName)


  12:  {


  13:      DAL.Document dr = new DAL.Document();


  14:   


  15:      dr.DocumentName = documentName;


  16:      dr.DocumentType = documentType;


  17:      dr.Author = author;


  18:      dr.Audience = audience;


  19:      dr.Purpose = purpose;


  20:      dr.DateWritten = dateWritten;


  21:      dr.UpdatedBy = userName;


  22:      dr.UpdatedOn = DateTime.Now;


  23:      Int32 docLength = (Int32)attachment.Length;


  24:      byte[] docBuffer = new byte[docLength];


  25:      attachment.Read(docBuffer, 0, docLength);


  26:      dr.Attachment = docBuffer;


  27:      dr.Save(userName);


  28:      return true;


  29:  }











Telecom News



We are moving to SubVersion…



We are finally moving off Microsoft Visual SourceSafe for source code control.  The reasons for moving are:




  • Ability to branch and merge (apparently) is better;


  • More stable, robust database;


  • Other teams (non-Microsoft e.g. Java) already have it – we’re the last holdouts.


  • Free Open Source application (although the Visual Studio interface – Visual SVN – isn’t free).



The reason why we’re not going to Team Foundation Server is:




  • There already is a TFS database, but they way it was implemented (Virtual Server on a non-Telecom network via internal wireless network) means that we couldn’t code from home.


  • Prohibitively expensive to spin up a second license.



Seems like a good idea to me.  Not sure I want to share the same repository as all other teams: might lose too much autonomy.  We shall see.







Product News





Nothing new to report at this time



Last month, I made a mistake.  I had thought (typo?) that the world-wide launch of Visual Studio 2010 was taking place on 22 March.  Turns out to be 22 April.







Partner News



Got our new MSDN Subscriber Licenses



Good for another two years of unlimited, legal downloads.  I love working here.







Situations Vacant



Senior Functional Specialist BI/Planning - Wellington



  • Requisition ID – INF022D5


  • NZ-Wellington


  • Permanent - Full-time


  • Job Posting 18/Mar/10



Senior Finance Analyst



  • Requisition ID – FIN020GO


  • NZ-Wellington


  • Permanent - Full-time


  • Job Posting 12/Mar/10



Technical Graduate Programme



  • Requisition ID – GRA2200Y


  • New Zealand


  • Permanent - Full-time


  • Job Posting 08/Mar/10



Functional Specialist BI/Planning - Wellington



  • Requisition ID – INF022CE


  • NZ-Wellington


  • Permanent - Full-time


  • Job Posting 01/Mar/10



Graduate Leadership Development Programme 2011



  • Requisition ID – GRA2200X


  • New Zealand


  • Permanent - Full-time


  • Job Posting 01/Mar/10



If any of my non-Telecom friends are reading this and interesting in any of the above, then drop me a line so we can discuss eligibility and suitability.







Training News



In February, I sat and passed Exam 70-562




  • TS: Microsoft .NET Framework 3.5, ASP.NET Application Development


  • Should have been easy, but there was a whole lotta extra stuff


  • e.g. WCF & AJAX


  • My score: 763



Skills being measured in this exam:




  • Configuration and Deploying Web Applications (10%)


  • Consuming and Creating Server Controls (20%)


  • Working with Data and Services (17%)


  • Troubleshooting and Debugging Web Applications (16%)


  • Working with ASP.NET AJAX and Client-side Scripting (15%)


  • Targeting Mobile Devices (5%)


  • Programming Web Applications (17%)







Trainer News



Renewed my MCT for another year…



I’m a Microsoft Certified Trainer again.  Yippee!  It means that Telecom gets a discount on MSDN subscription, and I get unlimited, free and legal access to all Microsoft Official Curriculum material.







PASS News



I’m speaking to Auckland SQL Saturday in April…



On Saturday 10 April at Wolters Kluwer, 41 Centorian Drive, Mairangi Bay, North Shore.



My topic will probably be the Microsoft Sync Framework (again).  I find it difficult (as a full-time Web Developer) to find topics of relevance to Microsoft SQL Server Database Administrators.





Events Schedule



In this section, I highlight dates, times and venues of events either I am presenting at, or of interest to Geeks.  I’m available for bookings.









































































Date Event Venue Speaker
19-Feb-2010 Exam 70-562 Auldhouse, Wellington None
22-26 Feb 2010 Exchange 2010 Training Auldhouse, Wellington ?
10-Apr-2010 SQL Saturday

Wolters Kluwer, Auckland


James, et al
22-Apr-10 Microsoft Visual Studio 2010 Launch All Over The World Various
21-23 April 2010 PASS European Conference Neuss, Germany Various
18-May-10 NZ SharePoint Conference Bay of Plenty Lots




Humour



Mistaken Identity



One day, one of my first-grade students, Taylor, asked his grandmother if he was a child of God. "Why, of course you are, Taylor," she replied. He looked puzzled, then responded, "Well I better get home and tell Mom and Dad—they think I'm theirs!"



—Mary De Guzman, Greenville, SC. Today's Christian Woman, "Heart to Heart."




Sunday, March 7, 2010

Geek Post Monthly Newsletter Volume 2 Issue 1

Geek Post

Volume 2 Issue 1

January 2010

Hippolite Musings

Tena Koutou Katoa,

Last year, I started this newsletter.  I managed 11 weeks before year end.  This was a bit much, so this year I will probably end up doing monthly.  I have two months to catch up on.  Here goes…

Blessings,
James


Developer News

Grenada Village Online

This is where I continue the saga of documenting my learnings from actually putting a web site “out in the wild” (I usually code within a nice, safe, Intranet).

This month I learned how to actually implement Profile, Membership and Role providers. 

  • The first learning was that there are three providers!
  • Secondly, put it all in the Web.config (see below). 
  • Point all three providers to the one connection string for your application’s database. 
  • Then, create all the objects (tables, views & stored procedures) that the Providers expect to find there. 
  • The code for creating a script to generate the objects is this: aspnet_regsql -S (local) -E -A all –sqlexportonly <filename>


Telecom News

XT has developed a glitch…

People are working on it.

I’m not directly a cause nor a cure for the problem.

We’re all being impacted in some way or other.  For example, Production change requests are under closer scrutiny to ensure nothing exacerbates the situation.

That’s all I have to say on this subject at this time.


Product News

ReSharper 5.0 for Visual Studio 10

Can’t wait to get VS10 RTM, so I can upgrade ReSharper!


Partner News

I met Telecom’s new Microsoft Technical Account Manager

His name is Antony Willis.

 


Situations Vacant

Customer Service Representative- Faults Mobile- 26th April

  • Requisition ID – CUS020ZB
  • NZ-Auckland
  • Permanent - Full-time
  • Job Posting 08/Mar/10

Complex Billing Specialist

  • Requisition ID – INF022CU
  • NZ-Christchurch
  • Permanent - Full-time
  • Job Posting 05/Mar/10

Systems Engineer - Networks

  • Requisition ID – ENG0209K
  • NZ-New Plymouth
  • Permanent - Full-time
  • Job Posting 05/Mar/10


Training News

In January, I sat and passed Exam 70-561

  • TS: Microsoft .NET Framework 3.5, ADO.NET Application Development
  • Should have been easy, but there was a whole lotta extra stuff
  • e.g. Sync Framework, LINQ and ORM with the Entity Framework


Trainer News

Nothing new

 


PASS News

Nothing New

 


Events Schedule

In this section, I highlight dates, times and venues of events either I am presenting at, or of interest to METTLE.  I’m available for bookings.

Date Event Venue Speaker
11-Jan-2010 First day back at work Telecom Wellington James
19-Jan-2010 Exam 70-561 Auldhouse, Wellington James
25-29 Jan 2010 SharePoint 2010 Ignite for Developers Microsoft, Wellington Wayne Ewington
22-26 Feb 2010 Exchange 2010 Training Auldhouse, Wellington ?
22-Mar-10 Microsoft Visual Studio 2010 Launch All Over The World Various
21-23 April 2010 PASS European Conference Neuss, Germany Various
18-May-10 NZ SharePoint Conference Bay of Plenty Lots

Humour

Digging Whales


We had recently moved from Tennessee to Mississippi. Our four-year-old son, Jeep, came home from church one Sunday, excited about the Sunday school lesson. "My teacher taught us all about the whales," he announced.
"You mean Jonah and the whale?" my wife asked.
"No," he said, "Jacob and the whales."
"I think it was Jonah," my wife corrected. "He was swallowed by a whale in the ocean."
But Jeep knew his lesson. "No, it was Jacob. He moved out into the desert and when he got thirsty, he dug some whales."

—Pat Apel, Hazlehurst, Mississippi. Christian Reader, "Kids of the Kingdom."


Monday, October 5, 2009

MCTS Exam 70-561 Prep

I’m reading the Self-Paced Training Kit for Microsoft .NET Framework 3.5 – ADO.NET Application Development…

…and loving it.

At first, I wasn’t because the first four chapters were boring, but now I’m reading about interesting stuff:

  1. Creating Database Connections
  2. Selecting and Querying Data
  3. DataSets (including Strongly-Typed DataSets)
  4. Updating Data
  5. Synchronizing Data (including the Microsoft Sync Framework)
  6. Introducing LINQ
  7. XML
  8. LINQ to SQL
  9. Using the Entity Framework
  10. ADO.NET Data Services