mwvisa1 Login Name
Qualified Expert Account Type
4,329,873 Expert Points
03/24/04 Registration Date
10,000 Points this month
Member Profile:
Thanks for viewing my profile.  Hopefully I have helped answer a question or two.  

I became a member/fan of EE in 2004 after stumbling onto it googling for an answer to a question.  I later became involved with answering questions.  August of 2008, I decided to be a bit more active.  Maybe my passion turned to obsession considering I had about 55k points then and no certifications.  

SQL and Java Programming is where you will typically find me...

My goal is to hopefully give back at least a fraction of what some of the EE legends have given me as I can always count on EE having a solution or thought that inspires me to find solution I am looking for.

As others here on EE, I don't mind you dropping me a line as long as questions are handled here on EE:
b1ackKnigh7 [AT] gmail [DOT] com

Best regards,
Kevin

"keep learning and/or keep smiling; there's nothing worse than a sad fool..."


SQL/Databases Zone Advisor & Page Editor  (since July '09)
For ZAPE topics, email me at: mwvisa1 [AT] experts-exchange [DOT] com


====================
A SQL Tidbit: Articles
====================  

A SQL Tidbit: Conditional Aggregates - http:A_3527.html

A SQLite Tidbit: Quick Numbers Table Generation - http:A_3570.html

A MySQL Tidbit: Quick Numbers Table Generation - http:A_3573.html

A MySQL Tidbit: In-line XML Parsing - http:A_3574.html

A MySQL Tidbit: In-line CSV Parsing - http:A_3622.html

A MySQL Tidbit: Dynamic Export To_XML Stored Procedure - http:A_3638.html

====================  
Articles I Refer to Often
====================  

Analytical SQL : Where do you rank? - http:A_1555.html

Dynamic Pivot Procedure for SQL Server - http:A_653.html
by mark_wills - http:M_4390378.html

Pivot Rolling Periods Without Using Dynamic T-SQL - http:A_654.html
Broaden Your Horizons : Pivot Again! - http:A_1537.html

3 Ways to Speed Up MySQL - http:A_1250.html
by gr8gonzo - http:M_124884.html

====================
Other articles written by me - http://w.e-e.com/I5pI9R
====================
Skills / Accomplishments:
Genius Certification SQL Server 2005 (2010.02.09) - http:Q_25118450.html
Hall of Fame - Top 100! (2009.09.16)
3 Million Points! (2009.09.07) - http:Q_24711454.html | http:Q_24711767.html (w/o article points)
Converting AD Timestamps T-SQL (my 1st EE approval | 2009.06.04) - http:A_811.html
Sage Certification Sql Syntax (2009.03.11) - http:Q_24214879.html
MySQL IsNumeric() How To (my 1st EE article | 2008.11.21) - http:A_252.html
Guru Certification Java Programming (just cool! | 2008.10.27) - http:Q_23852725.html
Master Certification Sql Syntax (my 1st EE cert | 2008.08.28) - http:Q_23686932.html
Sun Certified Java Programmer (2007.09.14)
Napersoft <> Novell eDirectory Identity Management Driver Developer (1st ever | 2004)
 
3,646 Questions Participated In
18,849 Comments Posted
Date Points Title Activity Type Status Zone
09/02/10 500 sql syntax Comment Open MySQL Server
09/02/10 500 ORDER BY clause in SQL 20… Comment Open Query Syntax
09/02/10 0 Expert Notify Thread - MS SQ… Comment Open MS SQL Server
09/02/10 500 SQL Query - Stem Comment Open PostgreSQL
 
 
23 Articles Written
1,388 Article Comments
Date Title Activity Type Status Zone
1 09/02/10 Microsoft Access and SQL Azure Data… Article Comment Published MS Access
2 09/01/10 Remove XML Empty Nodes with MSSQ… Article Comment Author Review MS SQL Server 2…
3 08/31/10 A MySQL Tidbit: Dynamic Export To_… Article Comment Unverified MySQL Server
4 08/31/10 Sorting Arrays and Collections in Java… Article Comment Published JavaScript
5 08/31/10 Hackers Guide to Being Hacked: How… Article Comment Published Network Security
 
5 Blog Entries Posted
11 Blog Comments
Date Title Activity Type Category
1 08/25/10 Agile Software Development Comment Techno
2 08/23/10 Finally ... I have a DROID ! Comment Techno
3 08/18/10 Finally ... I have a DROID ! Entry Techno
4 08/03/10 Cannot Open Outlook Window Error Comment Techno
5 07/13/10 Sabbatical Entry Rhythm and Blues