New Geek Toy and Upcoming SQL Down Under Podcasts

Hi Folks,

I was so pleased today to finally get my new geek "toy" installed. I bought a Rode Podcaster mike a while back but didn't get a chance to install it till today. I love the balanced arm that lets me get it positioned so well while still able to type. And then I can just push it out of the way. It's a broadcast quality mike and is in a shock mount. I've already noticed a major difference in the sound quality, including vastly reduced background noise. I've got a pop-filter for it which I might end up using too.


I had a small problem getting it working with Vista but was super-impressed that I just called their phone number, within one transfer I got to a human who immediately helped me. I have to mention it because that's so far removed from the typical service experience I have with most things nowadays.

So look out for increased sound quality on upcoming SQL Down Under podcasts. I'd taken a break from producing any for a while as I've been travelling extensively but now I'm back and they'll start to flow.

Impact of Software as a Service on ISVs

I love seeing people start to undertake research work in computing areas. There aren't nearly enough. Oscar Trimboli told me today that he's undertaking predoctoral work at present and his topic is the "Impact of Software as a Service on Australian Independent Software Vendors". Oscar is keen to recruit ISVs who are either traditional ISVs or SaaS (Software as a Service) ISVs (or a combination) that have their management and marketing decision making based in Australia. If that sounds like you, I'd encourage you to get in touch with Oscar (Oscar_trimboli @ and answer his survey questions. Alternately, if you have strong opinions about this space, I'm sure he'd love to hear them.

A description of his research topic is as follows:


Software as a Service (SaaS) is a fundamental change in the architecture of software development and distribution model that will change the way Australian Independent Software Vendors (ISVs) compete locally and globally.


SaaS is an exciting opportunity for local ISVs and simultaneously the most significant threat to the industry in the last 30 years. SaaS rapidly increases the competitive intensity of firms operating in the Australian market place as global ISVs seek to expand into the Australian market. Conversely it offers an important export opportunity for the local industry if ISVs can leverage the impact of the technology and distribution discontinuity created by SaaS.

There is a significant national economic impact through employment growth in the information economy and associated industries especially telecommunications. As a result, there are significant barriers and costs which will limit the effectiveness of Australian ISVs exporting such as the impact of national broadband policy and natural barriers to competition such as national taxation and business processes.


SaaS, as a new distribution model impacts the sales and marketing mix of ISVs. Traditional methods of face to face sales and marketing will adapt to the changing nature of the medium and the ability of prospective customers to preview the software they will actually use immediately rather than the traditional approach of presentations and demonstrations via sales and marketing staff. In parallel, ISVs paid upfront commissions to their sales organisation to access ongoing maintenance revenues from their customers.


Overall capital allocation to research and development will alter through SaaS along two major dimensions. Traditionally, ISVs have maintained multiple versions of their software as their customers where running historical versions. Customers paid annuity maintenance to the ISVs to in part help fund research and development for future versions of software and partly to fund employees which support older versions of software.


Conversely, SaaS enables the continuous maintenance on the single and most current version of the software. Customers will always be using the most current and up to date version of their product via SaaS and as a result research and development will be focused on the most current version of the product exclusively.


Capital allocation beyond research and development, focused on human and physical resources will alter the business models of ISVs going forward as they need to invest beyond software into data centres and networking competencies.


The business model via SaaS can explore alternatives in their revenue models including using upfront licensing revenues, subscription based revenues and advertising revenue based models.


SaaS is the most recent technology and business model dis-continuum facing the local ISVs, which the industry faces each decade. Very few Australian ISVs have survived the past 3 decades and the industry has a strong history of generating new ISVs which are successful during their decade.

Finally, the growth of SaaS is a function of end user adoption and these users currently have not be totally embraced SaaS applications due to security, reliability and availability concerns, despite the low cost of entry of the new SaaS applications.


OT: Internet Connection Sharing on Vista – Problem Resolution – IPv6

I've been travelling a lot lately and one of the problems that always comes up is how to share a single Internet connection in a hotel room with my wife Mai who's usually travelling with me. (She does remote SQL Server DBA work).

My colleague Fernando Guerrero suggested I try his USB-to-Ethernet adapter (a SiteCom one) and use Internet Connection Sharing. I installed the drivers for the SiteCom device (which is a good small size too) and configured ICS and it just worked. I thought this was excellent until Tuesday last week when the latest update for Vista came down from (I'm pretty sure that's what did it). Along with rebooting my machine in the middle of the day (I'd so love to discuss that with the windows update author), my ICS no longer worked.

When I tried to configure it, it provided the helpful message that "An error occurred while configuring Internet Connection Sharing". I *love* those sorts of error messages. No help whatsoever. It might as well poke you in the eye for good measure. Anyway, a search of the system event log found an error loading the IPv6 driver. What's interesting about that is I *don't* have IPv6 enabled on my connections as it tends to cause problems with various routers, particulary wireless routers.

After much frustration, it suddenly dawned on me to turn on IPv6 on the main network connection and lo and behold, ICS came back to life. So the moral of the story is that ICS on Vista now doesn't understand you disabling IPv6. It interprets it as being unable to load it. Enabling it allows ICS to work again (while no doubt returning me to router-related problems in the future).

Global Reach Awards – Congratulations to All

Each year the Microsoft Regional Director program issues Global Reach Impact Awards. It was great to see seven from our company receiving awards:

Gold Awards – Fernando Guerrero, Richard Hundhausen, Greg Low, Mauro Sant'Anna

Silver Awards – John Alexander, Shervin Shakibi

Bronze Award – Ken Spencer

The Impact Award represents Microsoft's respect for the work these Regional Directors do in evangelizing Microsoft technologies and products worldwide. That's an oustanding result for our company. Congratulations also to all other Regional Directors receiving awards this year.

OT: Books: Bill Bryson "Down Under"

I was on a flight from Houston to Washington via Dallas today. We seemed to sit forever on the tarmac in Dallas, in fact just over 1.5 hours from leaving gate to taking off. The captain was warning that if he had to stop and restart the engines one more time, we'd have had to return to the terminal for more fuel.

However, the good thing was that I finished reading Down Under by Bill Bryson. I'm a real fan of Bill's writing and this book is no exception. It provides a wonderful and very humourous summary of his trips throughout a good chunk of Australia. Bill has a way of providing insights that is sorely lacking in most authors. I found myself laughing out loud many times while reading it. I also enjoyed the extra chapter at the end about his time growing up in the U.S. in the 1950s.

Highly recommended!

OT: Banks, security, IE7/Vista, password policies and CardSpace

I had to go through the signup procedure for direct account access for Bank of America today. It reminded me of how much nonsense gets perpetrated and how it's always done supposedly in the name of security. In the end, it usually achieves the exact opposite of what they are trying to achieve.

First, you need to generate a digital certificate to use. The bank has a sign-up site for this. After entering my details, I was greeted with:


I can't imagine anyone that would consider "Error 0x1AD generating certificate request" to be either friendly or helpful. Now I thought, hmm, this might be an IE7/Vista thing so I tried to run IE as an Administrator. No joy. Eventually I gave up and contacted support. So what was their recommended solution? You guessed it: install Firefox and use it instead !

I asked when the bank was going to support IE7 and Vista, given it was 2008 now and that was becoming a pretty common combination. They told me that there was a convoluted process that you had to go through to get it to work and that I might have to involve my IT department to get it to work. I'll take that as a "not real soon now" response.

So I gave in and installed Firefox. It was interesting to notice that my options for doing that included the GoogleToolbar. I suppose all those bundling and anti-trust rules should only apply to evil organisations like Microsoft :-)

After doing that, I could then create the certificate, then back it up to a file and reimport it into IE7. So far so good. Then I needed to create a new password. I was a little surprised by this message:


I wonder which Einstein at the bank thinks that is a good idea. It reminded me of the Telstra Bigpond error message that told me my passwords couldn't be longer than 8 characters.

After removing the offending special character, I was then told I must have a number in the password. So I added a number only to be told that my password couldn't end in a number, unless it ended in two numbers. Heaven forbid they could have told me that in the first error message.

And so on and so on. I cannot imagine that policies such as this ensure anything except that I have to write down my new password as there's no chance I'll ever remember it. I'll bet they have a rule that says I can't do that either.

I had a related conversation with the Commonwealth Bank in Australia recently. They have a system where if you get the password wrong on a new online account three times, it *never* resets without you physically going into the bank. Again, this is done for security. I asked "but what if someone wrote a program to just try all the numbers? No new customer would be able to connect at all." They said "ah, no-one would do that surely".

It really is time for a system like CardSpace to become prevalent.


Sessions announced for CodeCampOz 2008

Sorry to all for the delay in working these out but we've now posted details of the sessions for CodeCampOz in 2008. You can view them on the "2008" tab at

There's a really great lineup of sessions. We also have two extra special guests: Jonas Folleso from Norway and Fernando Guerrero from Spain.

This year, there is also a precon event on Friday afternoon prior to the main event on Saturday and Sunday.

If you are planning on coming and have not already let us know, please email us at registration @ to let us know.

SQL Server 2008: Interesting Full-Text Dynamic Management Function

I've been playing around with full text search in SQL Server 2008 and was intrigued by the DMF sys.dm_fts_parser(). It allows you to see the result of the word-breaking occurring within full text search. If you execute the query:

select * from sys.dm_fts_parser('"Hello Greg. How are you? I haven"t seen you for a while."',1033,0,0);

It returns the following data (along with some other columns):

occurrence  special_term     display_term
1           Exact Match      hello
2           Exact Match      greg
10          End Of Sentence  END OF FILE
11          Noise Word       how
12          Noise Word       are
13          Noise Word       you
21          End Of Sentence  END OF FILE
22          Noise Word       i
23          Exact Match      haven't
24          Exact Match      seen
25          Noise Word       you
26          Noise Word       for
27          Noise Word       a
28          Noise Word       while
36          End Of Sentence  END OF FILE

(15 row(s) affected)

That's really sweet as it lets you parse text into words. The 1033 was the locale I chose and the other two parameters were a stop word list (formerly called a noise word list) and whether or not it should be accent sensitive.