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
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.
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