Our community of experts have been thoroughly vetted for their expertise and industry experience. Experts with Gold status have received one of our highest-level Expert Awards, which recognize experts for their valuable contributions.
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
More
Education
No Education Background shown
More
Full Biography
People call me Richard. You can reach me @RichardTheKiwi on Twitter.