On persistence

Our family are relatively new converts to organised sport.  It all started last year when the NSW AFL hosted an introduction to Auskick at Ronan’s school, which culminated in them participating in an Auskick during half time at a GWS Giants game mid-season.  We found it interesting enough that we bought an adult and junior membership to see us out to the end of the season, with Kathy and I tag-teaming  each other for the home games while we encouraged Ronan in his newly chosen sporting endeavour.

What we found was a very young set of players, but despite their inexperience, what we also found was our team.  Somewhat unusually for sports fans, we’re supporting a team that hasn’t yet won a game this season, and we’re well past halfway.

What makes them different though?  I can’t really put my finger on any one trait that says that these are the guys to root for rain, hail or shine, or I suppose from a sporting perspective, win, lose or draw.  We’ve never really understood the fervour of sports enthusiasts, as we’re more inclined to spend time reading or fishing.  As for the blinker vision of AFL supporters…

There are a few obvious things that they do though :-

When they’re down, they get up again.

They take time for the fans (even us)

There are moments during a game where you can see that they’re not afraid to punch above their weight – last week was a classic example where they nearly took down the Collingwood magpies, including a couple of nasty pitch bounces resulting in concussions for Tim Mohr (my personal favourite – go 39!), Will Hoskin-Elliot and Adam Kennedy, who I think was subbed on for Tim when he was knocked out during the first quarter.  Talk about giving your all.  Such heart!

Anyway, despite we’re facing the possibility of finishing a season completely winless, I have just one thing to say.

Let’s go Giants!  Let’s Go!!!


The Harey Maclarey

Some of you might be wondering who or what is Harey Maclarey. Hairy Maclary is a beloved if mischievous dog from Donaldson’s dairy, and the main character in a wonderful set of children’s books that sprang from the mind of Lynley Dodd. Incidentally they’re wonderful books to ham up with the kids sitting on your lap at the end of a long day.

So is it a bird, a plane, or is it Superman?

The answer is no – it’s a fly, used as an early season nymph imitation based loosely on the Hare and Copper, a popular pattern that I believe originated in New Zealand much like old Hairy Maclary himself. Both are grey and shaggy, and at least in the case of the Harey, the shaggier the better.

Full SBS to follow!

32-64 bit linked server problems

Had an interesting issue recently with a linked server going from a 64 bit SQL2008R2 host to a 32 bit  SQL2000 host.

The error message when running the distributed query was :-

OLE DB provider “SQLNCLI10” for linked server “sql02source” returned message “Unspecified error”.
OLE DB provider “SQLNCLI10” for linked server “sql02source” returned message “The stored procedure required to complete this operation could not be found on the server. Please contact your system administrator.”.
Msg 7311, Level 16, State 2, Line 2
Cannot obtain the schema rowset “DBSCHEMA_TABLES_INFO” for OLE DB provider “SQLNCLI10” for linked server “sql02source”. The provider supports the interface, but returns a failure code when it is used.

According to Microsoft, this problem occurs because the system stored procedures are not upgraded as part of the service pack installation. You must manually upgrade the system stored procedures after you install SQL Server 2000 Service Pack (SP3) or SQL Server 2000 Service Pack 4 (SP4) by running instcat.sql.

Official MS response is here :-
http://support.microsoft.com/default.as … -us;906954

Peace to all,

And here we go.

We all have dreams.  Some days I think I would like to be a writer. Others a fisherman.  Then a musician.  Cafe/Pizza shop owner, preferably in a quiet little town near some sort of water?  In reality I’m a DBA.

This has been a long time coming, and the simple truth is you have to start somewhere.  Here’s where I start writing, with the added benefit of being able to write about anything I choose.

To that end :-

“It was a dark and stormy night…”