cyberkiwi

  • 6,715,505Expert Points
  • 0Points this month
  • Member since: 04/18/2010

Your Account

View Profile

Personal Description

** Nowadays I only occasionally answer questions on EE **
--------------------------------------------------------------------------------------------------

People call me Richard.  You can reach me @RichardTheKiwi on Twitter.

According to Thomas Edison, Genius is 1% inspiration and 99% perspiration.

Computers and programming fascinate me, as do all related aspects hardware and software.
I hope some of that fascination and dedication to understanding things can translate into knowledge sharing and solutions for others.

Since 2000, I have been working as an IT consultant in the good old country down under.
We hosted the Rugby World Cup in 2011 and we won! Go All Blacks!

======================================================= miscellany follows
SQL> http:Q_26487697.html#a33724604
        I programmed minesweeper in T-SQL!  Check it out.
        Spent a couple of hours just to see if I would end up with something different from
        how Auke Teeninga (http:M_2017282.html) did his in
        http://www.simple-talk.com/sql/t-sql-programming/minesweeper-in-t-sql/

SQL> http:Q_26490338.html#a33759359
        What is Parameter Sniffing?  

SQL> http:Q_26520468.html#a33838575
        Hierarchical XML using SQL Server:  
        (email me if you have an alternative, I would be very interested)

SQL> http:Q_26572280.html#34006140
        Parsing for a datetime in an unstructured blob

SQL> http:Q_26597468.html#a34078708
        A method for comparing two tables and showing only column-level differences across records.

SQL> http:Q_26202788.html#a32814459
        Breaking up delimited strings into columns using CTE and XML

mySQL> http:Q_26613047.html#a34135078
        Creating a constraint on two columns (a,b) to prevent duplicates on both (a,b) and (b,a)

mySQL> http:Q_26668537.html#a34312555
        Create and fill a date table from day X to today

mySQL> http:Q_26670029.html#a34315376
        Emulation of SQL Server computed column using triggers

mySQL> http:Q_26603984.html#a34099095
        MySQL top N records per group

Access > http:Q_26749833.html#a34622647
        Generating a sequence number in an Access query using binary composition and msysobjects

Skills and Expertise

Expertise:
Guru
Experience:
15-19 years
Primary site use:
giving back to the community