cyberkiwi
  • New Zealand
Member Since: 2010/04/18
Top Skills:
Tech Certifications:
Prodigy
Freelancer

s.k.y.p.e - cyberkiwi2010

More bio
Activity
Points this month0
Total points6,731,005
Questions: 27
Solutions: 4595
Articles:
Videos:
Courses:
Posts:
Group Discussions: 9
Professional Background
Site Expert
Internet
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.

Languages
No Languages shown

Level Progress

Current: Level 58
cyberkiwi needs 230,995 points to level up.
LVL 59
  • Overall
    58
  • Microsoft SQL Server 2005
    30
  • Microsoft SQL Server 2008
    26
  • Microsoft SQL Server
    25
  • Query Syntax
    23
  • Microsoft Excel
    20
  • MySQL Server
    17
  • Microsoft Access
    17
  • Databases
    14
  • PHP
    14
  • .NET Programming
    12
  • Oracle Database
    10
  • ASP.NET
    9
  • C#
    9
  • ASP
    9
  • Visual Basic.NET
    8
  • Visual Basic Classic
    8
  • VB Script
    8
  • JavaScript
    7
  • Microsoft Office
    7
  • Delphi
    7
  • Microsoft Applications
    7
  • Microsoft Development
    6
  • Programming
    6
  • Spreadsheets
    5
  • SSRS
    5
  • HTML
    5
  • Windows Server 2008
    4
  • XML
    4
  • Java
    4
  • Web Development
    4
  • Windows Server 2003
    3
  • jQuery
    3
  • Scripting Languages
    3
  • Math / Science
    3
  • Programming Languages-Other
    3
  • Windows 7
    3
  • Microsoft IIS Web Server
    3
  • CSS
    3
  • PostgreSQL
    3
  • Editors IDEs
    3
  • VMware
    3
  • Outlook
    3
  • JScript
    3
  • ColdFusion Language
    3
  • Windows XP
    3
  • Crystal Reports
    2
  • Web Languages and Standards
    2
  • Regular Expressions
    2
  • Web Browsers
    2
  • Microsoft Server OS
    2
  • AJAX
    2
  • DB Reporting Tools
    2
  • Microsoft Legacy OS
    2
  • Microsoft Word
    2
  • Pascal
    2
  • Microsoft DOS
    2
  • Sybase Database
    2
  • Storage
    2
  • SBS
    2
  • DB2
    2
  • Components
    2
  • Virtualization
    2
  • Web Servers
    2
  • Hardware
    2
  • Networking
    2
  • Windows OS
    2
  • Visual C++.NET
    2
  • Adobe Dreamweaver
    1
  • Storage Hardware
    1
  • Windows Batch
    1
  • Exchange
    1
  • Algorithms
    1
  • Linux
    1
  • Microsoft Server Apps
    1
  • Server Hardware
    1
  • Miscellaneous
    1
  • Apple OS
    1
  • Game Programming
    1
  • Web Development Software
    1
  • WordPress
    1
  • Powershell
    1
  • Web Applications
    1
  • Security
    1
  • Apache Web Server
    1
  • Laptops Notebooks
    1
  • Software-Other
    1
  • C
    1
  • Cloud Computing
    1
  • Java EE
    1
  • JSP
    1
  • C++
    1
  • GIS/GPS Programming
    1
  • HTTP Protocol
    1
  • Linux Distributions
    1
  • Microsoft Dynamics
    1
  • System Utilities
    1
  • Unix OS
    1
  • Web Components
    1
  • Network Analysis
    1
  • Email Protocols
    1
  • Remote Access
    1
  • Citrix
    1
  • Displays / Monitors
    1
  • Email Servers
    1
  • FileMaker Pro
    1
  • PC
    1
  • WCF
    1
  • IBM System i
    1
  • Shell Scripting
    1
  • LibreOffice
    1
  • Document Management
    1
  • Mainframe Languages
    1
  • Office / Productivity
    1
  • Microsoft Virtual Server
    1
  • Operating Systems
    1
  • Programming Theory
    1
  • Perl
    1
  • Storage Software
    1
  • Enterprise Software
    1
  • Microsoft SharePoint
    1
  • Printers and Scanners
    1
  • Active Directory
    1
  • Apache Flex
    1
  • CAD/Architecture Software
    1
  • Consulting
    1
  • Content Management
    1
  • Google Chrome OS
    1
  • Linux OS Dev
    1
  • Mac OS X
    1
  • Microsoft Visio
    1
  • Network Operations
    1
  • Peripherals
    1
  • Productivity Apps
    1
  • SSH / Telnet Software
    1
  • System Programming
    1
  • Tax / Financial Software
    1
  • Web Frameworks
    1
  • Windows 2000
    1
  • Windows Networking
    1
  • Wireless Networking
    1

Profile Validation

Email Verified
Expert Level Achieved
PayPal Connected