Guy Hengel [angelIII / a3]
Billing Engineer
  • Luxembourg
Member Since: 2000/03/09
Industry: Computer & IT
Top Skills:
Tech Certifications:
View All
CERTIFIED EXPERT

Provide a quick, creative biography in 140 characters or less.

More bio
Activity
Points this month247
Total points40,990,714
Questions: 115
Solutions: 35338
Articles: 11
Videos:
Tutorials:
Posts:
Group Discussions: 342
Professional Background
Billing Engineer
tango s.a.
February 2007 – Present
Luxembourg
More
Education
No Education Background shown
More
Full Biography

I am part of a Sql Server group (Luxemburg):
sql-pass:  http://luxemburg.sqlpass.org/Home/tabid/1913/Default.aspx
linked-in: http://www.linkedin.com/groups?home=&gid=944787


================================================
Zone Advisor (Databases & co)  (previously Page Editor)
since 19-June-2006

Cleanup Volunteer
since August-2008
================================================

I wrote a couple of articles on EE, having fun to link to them for some of the most typical problems.
Usually, they are comparing the features/syntax of MS SQL Server, MySQL and Oracle (the order chosen is Alphabet ...)
They will not go into the full depth of all the syntax, instead refer to the Documents where you can (and should) read up more details.
I understand my articles as starter and/or guidance for the different problems in general.
<Quote>
Give a man a fish and you feed him for a day. Teach a man to fish and you feed him for a lifetime.
</Quote>
If I can work for 4 hours to get, for example, XML stuff working in MS SQL server, and another 4 hours for the same on Oracle, so can you, if you need to use it at your work.
================================================

Can you hire me?
short answer: no (sorry), as I do already have a full-time job.

================================================


For you, the questioners:

#Introduction --
it's not that I don't want to be polite, but you share my time with many others, among my boss !!!
I often post suggestions or links without any explanation or greetings:
-> try to check it out, learning by doing is what made me know what I know today
-> if it does not work, tell me.
-> if it works, but you don't understand the solution, tell me (I will be happy to explain)



rule  #1  -- Do you know how to behave on EE?
* did you read the members agreement: https://www.experts-exchange.com/memberAgreement.jsp ?
* did you read the ALL the help sections: https://www.experts-exchange.com/help.jsp ?

----> If not, you risk to be "wrong".

rule #2  -- Is your question posted correctly?
* did you put your question in the correct topic area: https://www.experts-exchange.com/allTopics.jsp ?
   note: there are several subtopic areas, you might also post pointer questions in several topic areas
* did you put a good question title?  
  note: only putting "URGENT HELP NEEDED" is NOT (and will never be) a good question title
  note: adding "URGENT" or similar will not help to get answers faster, only slower
* did you put problem details?
  note: typically information like the following should be in your question, where applicable
    - application names and versions and service packs
    - extract of codes where applicable
    - error messages (if any) !!!!!
    - sample input , current ouput and requested ouput (data and/or behaviour)
    - indication of your knowledge
    - indication of what you tried already
  note: do NOT post pages of code or details. only the essential parts.

----> If not, you started the question badly.

rule #3 -- Question follow up ?
* Once you received a comment, you should react to it. If you need some time to test (>30 min), post a comment you do so, and come back when done.
* The suggestion does not work "copy/pasted" into your situation... Did you put some effort to understand the suggestion, I usually assume you can and should do like that.
* The suggestion does not work "copy/pasted" into your situation... Did you check that your posted details might not have been complete enough to write the full solution.
* Very often, the suggestions assume you have some basic knowledge, so you should be able to implement it
* A "No, this does not work" CAN be a correct answer.
* If you got several people giving you the "answer" withing few minutes, split the points.

----> If not, you are not respecting the experts.

rule #4 -- we, the "experts"
* not every one posting to your q is an expert in the topic regarding your q (this includes myself). Still, the comment might be valid.
* not every comment is correct. Error happens, most often because the question was not read properly or was not precise enough.
* try not to flame us, we try not to flame you.
* we are not employees of EE, we get NO money nor anything else (except some that get some t-shirts). We help, because we:
   - know about the situation you are in (technical problem)
   - know about the situation you are in (boss behind you asking for solutions)
   - like to share our knowledge
* we are not "working" 24/24 - 7/7. It could be that the expert helping you has gone off for lunch, to bed, to a meeting, dancing or whatever. we have a private life
* we do not know everything. Some might think we do (should), but that's impossible.
* we sometimes "know" that what you ask for is not possible. This is an acceptable answer, but you might review your constraints so we can suggest workarounds or other solutions.

Now, if you think I did a really "bad job" on your question, send me a message


TYPICAL WORK SHIFT:
whenever I have some time while working on a PC...

TYPCIAL POSTING:
  * first comment is usually a fire-and-forget:
   - Typically, it's a suggestion that should point you to the good direction. If you need more details, post a comment and ask
   - Usually, I try to solve 1 problem at a time, and not all at once.
   - If you ask "how do I this/that", often my comment will only be a link to a page that shows how to do it. I admit that 99% of the cases I googled to find/get that page.
   - If I requested more input, post a comment with ALL of the details asked for
   - in areas where I am NOT an expert (yet), I try to find a link that might/should help.
   - suggestions might not be the only valid one, and can even be wrong
  * following comments:
   - I try to follow up your question until resolution.
   - I might miss your comments, email notification is not always 100%
   - I might miss your comments, I get about 200-300 emails per day from EE... (my mailbox has a limit of 500)
   * I might stop responding for some time
   - when I go to bed, to lunch ... (notice, I DO have a life, a job, a wife, a child, tons of hobbies ...)
   - when another expert shows up a much better way or using techniques I don't know
   - when another expert shows up I know has enough knowledge to finalize the question (I will continue looking, though)
   - when I missed a comment notification (happens more often that one might think)
   - when I am off for some days (which can happen for many reasons)
   - when I have to work on a project without the time to visit EE (see above, I have a full-time job).
  * the post may have been done from my mobile, so I will not write long SQL or long comments.

================================================

----------- Here my background ------------
I started to learn developing at the age of 19, when I first discovered a PC.
I started with Turbo Pascal 6, and soon realized small Applications running in DOS.
My 2year-study in Luxemburg gave me INPUT for C, C++, COBOL; Databases were Oracle in Unix and some Merise Method for Analysis.
Start on the job was 1998 with VB5 (being a complete newbie), meanwhile i work with VB6, looking forward for the next generation to come.
In Database means i can handle Oracle 7.3 and SQL 6.5, but my strong point is SQL 7 (starting with SQL Server 2000 now).
I did some MCP exams, and finished my MCSD (2000), and my MCDBA recently (2004). MCP List:
*Visual Basic 5
-> MCP
*Visual Basic 6 Desktop
*Visual Basic 6 Distributed
*Implementing SQL Server 7.0
*System Administration for SQL Server 7.0
*Analysing Requirements Defining Solutions Architecture
-> MCSD
2004 *OCP Exam #1Z0-411: Oracle 8 Internet Database Operator
2004 *Oracle Exam #1Z0-007: Introduction to Oracle9i: SQL*
2005 *Installing, Configuring, and Administering Microsoft Windows 2000 Server
-> MCDBA
2005 * HP Openview Operations for Windows 7.x
-> MVP profile (no longer available, as my MVP status has not been continued)
 https://mvp.support.microsoft.com/profile=D4B8ABD3-BC3B-441E-9436-1F67B456B699
2009 * MS SQL Server & Development
2010 * MS SQL Server & Development
2011 * MS SQL Server & Development

================================================

2006/02/01: job change, seems I can continue to work regulary on EE.
2006/06/19: ee page editor status
2008/09/01: ee cleanup volunteer
2009/09/01: ee article writer

================================================

Sending me a message with a link to the question is a guarantee that I will look at the question, but not that I will post.
although of my meanwhile 1 Savant + 11 (status end of 2012) Genius status in mostly database zones, I do not know everything (I know, I said that already :-)
more points on EE basically mean "more participation" and not "more knowledge", but of course, "more knowledge" helps to provide "more answers"

CHeers & have fun

More
Languages
Luxemburgish
Native or Bilingual Proficiency
German
Native or Bilingual Proficiency
French
Professional Working Proficiency
English
Professional Working Proficiency
Spanish
Elementary Proficiency

Level Progress

Current: Level 143
Guy needs 481,286 points to level up.
LVL 144
  • Overall
    143
  • Microsoft SQL Server
    87
  • Microsoft SQL Server 2005
    60
  • SQL
    48
  • MySQL Server
    45
  • Databases
    41
  • PHP
    39
  • Oracle Database
    38
  • Microsoft SQL Server 2008
    38
  • Visual Basic Classic
    32
  • Microsoft Access
    27
  • .NET Programming
    26
  • Visual Basic.NET
    24
  • ASP
    23
  • C#
    23
  • ASP.NET
    22
  • Microsoft Excel
    15
  • Microsoft Development
    13
  • Programming
    12
  • VB Script
    10
  • Web Development
    10
  • Programming Languages-Other
    9
  • Windows Server 2003
    8
  • Editors IDEs
    8
  • Web Languages and Standards
    7
  • HTML
    7
  • Web Applications
    7
  • SSRS
    7
  • Microsoft Applications
    7
  • DB Reporting Tools
    7
  • Microsoft Word
    7
  • JavaScript
    6
  • Microsoft Office
    6
  • Scripting Languages
    6
  • Java
    6
  • Enterprise Software
    6
  • Delphi
    6
  • Windows Server 2008
    6
  • Windows XP
    6
  • Windows OS
    5
  • Storage Software
    5
  • XML
    5
  • Sybase Database
    5
  • Web Servers
    5
  • Fonts Typography
    5
  • Microsoft IIS Web Server
    5
  • Linux
    5
  • Crystal Reports
    5
  • Microsoft Legacy OS
    5
  • DB2
    5
  • ColdFusion Language
    5
  • Miscellaneous
    5
  • PostgreSQL
    5
  • Unix OS
    5
  • Microsoft Server OS
    4
  • Microsoft DOS
    4
  • CSS
    4
  • Apache Web Server
    4
  • Windows Batch
    4
  • Software
    4
  • Math / Science
    4
  • SBS
    4
  • Web Development Software
    4
  • Adobe Dreamweaver
    3
  • Regular Expressions
    3
  • Java EE
    3
  • Storage
    3
  • C++
    3
  • Active Directory
    3
  • C
    3
  • VBA
    3
  • Security
    3
  • System Programming
    3
  • Algorithms
    3
  • Operating Systems
    3
  • Puzzles / Riddles
    3
  • Powershell
    3
  • jQuery
    3
  • Microsoft SharePoint
    3
  • Microsoft Server Apps
    3
  • Windows 7
    3
  • Exchange
    3
  • Networking
    3
  • Windows 2000
    3
  • Perl
    3
  • Visual C++.NET
    3
  • Installation
    3
  • Shell Scripting
    3
  • Windows Vista
    2
  • Server Hardware
    2
  • Linux Distributions
    2
  • AJAX
    2
  • Programming Theory
    2
  • Web Components
    2
  • Components
    2
  • JSP
    2
  • Web Browsers
    2
  • Web Services
    2
  • WordPress
    2
  • Outlook
    2
  • Windows Networking
    2
  • Server Software
    2
  • Hardware
    2
  • SSIS
    2
  • Python
    2
  • COBOL
    2
  • Smartphone Programming
    2
  • Anti-Virus Apps
    2
  • VMware
    2
  • OS Security
    2
  • Vulnerabilities
    2
  • FoxPro
    2
  • JScript
    2
  • Wireless Networking
    2
  • Java App Servers
    2
  • E-Commerce
    2
  • Telecommunications
    2
  • Cell Phones
    2
  • Network Management
    2
  • Joomla
    1
  • Windows Server 2012
    1
  • Project Management
    1
  • Email Servers
    1
  • System Utilities
    1
  • Assembly
    1
  • Storage Hardware
    1
  • Microsoft Dynamics
    1
  • JSON
    1
  • Internet Explorer (IE)
    1
  • Desktops
    1
  • Computer Games
    1
  • GIS/GPS Programming
    1
  • Email Protocols
    1
  • Displays / Monitors
    1
  • Linux OS Dev
    1
  • FileMaker Pro
    1
  • Microsoft Forefront ISA Server
    1
  • Internet Marketing
    1
  • Laravel
    1
  • Network Security
    1
  • Voice Over IP
    1
  • Laptops Notebooks
    1
  • Printers and Scanners
    1
  • Smartphones
    1
  • Wireless Hardware
    1
  • SSAS
    1
  • Email Clients
    1
  • Tax / Financial Software
    1
  • Experts Exchange
    1
  • BlackBerry
    1
  • Software Firewalls
    1
  • HTTP Protocol
    1
  • TCP/IP
    1
  • IBM System i
    1
  • InfoPath
    1
  • Multimedia Programming
    1
  • Proofreading
    1
  • Ruby
    1
  • VPN
    1
  • WCF
    1
  • SSH / Telnet Software
    1
  • Spreadsheets
    1
  • File Sharing Software
    1
  • Internet / Email Software
    1
  • Networking Protocols
    1
  • Office Productivity
    1
  • Web-Based CMS
    1
  • Search Engine Optimization (SEO)
    1
  • Citrix
    1
  • Adobe Flash
    1
  • Network Architecture
    1
  • IT Administration
    1
  • Philosophy / Religion
    1
  • Peripherals
    1
  • Disaster Recovery
    1
  • IP Telephony
    1
  • Networking Hardware-Other
    1
  • Acronis
    1
  • Routers
    1
  • Adobe Acrobat
    1
  • Virtualization
    1
  • Internet Protocols
    1
  • Productivity Apps
    1
  • DNS
    1
  • Game Programming
    1
  • Version Control
    1
  • Drupal
    1
  • COBOL
    1
  • Mainframe Languages
    1
  • Microsoft PowerPoint
    1
  • .NET MVC
    1
  • Cloud Computing
    1
  • Email Software
    1
  • FTP
    1
  • JIRA
    1
  • Linux Networking
    1
  • Mainframe OS
    1
  • Objective-C Programming
    1
  • PC
    1
  • React
    1
  • Responsive Web
    1
  • SOAP Protocol
    1
  • SSL / HTTPS
    1
  • Statistical Analysis System (SAS)
    1
  • Technical Writing
    1
  • Web Frameworks
    1
  • Windows Phone
    1