(function() { var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true; ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js'; (document.getElementsByTagName('head')[0] || document.getElementsByTagName('body')[0]).appendChild(ga); })();

Archive

Author Archive

Auckland SQL Users Group Sep Meeting

August 14th, 2009 Kevin No comments

Defragging Indexes for Beginners
Indexes over time become fragmented and as a result don’t work quite as well as they should.  This short talk will show you how an index can become fragmented and will also show you the steps to fix index fragmentations. 

Effective Indexes for Beginners
From SQL Server 2005 onwards, we have been able to use a DMV to identify which of our indexes are effective and which of our indexes can be disabled.  This short talk will show you how and why you should be checking the effectiveness of your indexes. 


Presented by Amanda Jackson
Consultant/Developer with Fronde Systems Ltd with almost 20 years experience in the IT industry. Amanda is currently focusing on SQL development and BI and is working towards Microsoft BI development and maintenance certification. In the past she has covered most roles in IT including: Developer, Network Admin, Change Control Manager, Source Control & Build Manager, QA, Games Development, Novell DBA.
Amanda is also the founder of Girl Geek Dinners in New Zealand

 

Register here

Categories: SQL Tags: , ,

Sky TV gazumps TiVo with remote recording | The National Business Review – New Zealand – business, markets, finance, politics, property, technology and more

August 10th, 2009 Kevin No comments

Sky TV gazumps TiVo with remote recording

Chris Keall | Monday August 10 2009 – 05:06am

With the launch of the TVNZ-backed TiVo just months away, Sky TV has announced it will match the service’s killer point-of-difference – from Friday week.

Sky TV’s MySky subscribers – representing around 10% of its customer base – will be the new Remote Recording feature from Friday 21.

The service, modelled on those already launched by Foxtel in Australia and BSkyB in the UK, will let subscribers remotely set their MySky decoders via the web. After accessing a password-protected area of SkyTV’s website, they will be able to click on the shows they want to record.

A basic txt-to-record option will be available for cellphones from the 21st, with a more fully-featured mobile service on the way.

via Sky TV gazumps TiVo with remote recording | The National Business Review – New Zealand – business, markets, finance, politics, property, technology and more.

Categories: Tech Tags: ,

Dr Who The Waters Of Mars

August 9th, 2009 Kevin No comments

The latest Doctor Who The Waters Of Mars  looks good coming in Sep 2009

Categories: Everything else Tags: , ,

Stargate Universe Preview

August 6th, 2009 Kevin No comments

Categories: Everything else Tags: ,

The Frozen Crabs and the Blonde Stewardess

August 2nd, 2009 Kevin No comments

A lawyer boarded an airplane in New Orleans with a box of
frozen crabs and asked a blonde stewardess to take care of
them for him.
She took the box and promised to put it in the crew’s
refrigerator. He advised her that he was holding her
personally responsible for them staying frozen, mentioning
in a very haughty manner that he was a lawyer, and
proceeded to rant at her about what would happen if she
let them thaw out.
Needless to say, she was annoyed by his behaviour.
Shortly before landing in New York, she used the intercom
to announce to the entire cabin, “Would the gentleman who
gave me the crabs in New Orleans, please raise your hand?”
Not one hand went up … so she took them home and ate them.
Two lessons here:
1. Lawyers aren’t as smart as they think they are.
2. Blondes aren’t as dumb as most folks think

Categories: Joke Tags: ,