SQL - Mixing INNER and OUTER Joins [external link]

When mixing INNER and OUTER joins, it's important to understand the risks involed and this article describe it very clearly:
http://weblogs.sqlteam.com/jeffs/archive/2007/10/11/mixing-inner-outer-joins-sql.aspx

SVN > XSLT = HTML Report

svn log -v --xml file:///C:/subversion/repo/http-conf | xsltproc svnstyle.xsl - > ./svnlog.html

===== svnstyle.xsl =====
<?xml version="1.0" encoding="ISO-8859-1"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
<html>
   <body>
      <h2>SVN Log</h2>
      <table border="1">
      <xsl:for-each select="log/logentry">
         <xsl:if test="author='USERNAME'">
            <tr>
               <td><xsl:value-of select="date"/></td>
               <td><xsl:value-of select="author"/></td>
               <td><xsl:value-of select="msg"/></td>
            </tr>
         </xsl:if>
      </xsl:for-each>
      </table>
   </body>
</html>
</xsl:template>
</xsl:stylesheet>
===== svnstyle.xsl =====


Output: 
===== svnlog.html =====
<html>
   <body> 
      <h2>SVN Log</h2> 
      <table border="1"> 
         <tr> 
            <td>2014-04-11T21:34:31.836671Z</td> 
            <td>USERNAME</td> 
            <td>My third commit</td> 
         </tr> 
         <tr> 
            <td>2014-04-11T21:34:31.586674Z</td> 
            <td>USERNAME</td> 
            <td>My second commit</td> 
         </tr> 
         <tr> 
            <td>2014-04-11T21:34:31.024182Z</td> 
            <td>USERNAME</td> 
            <td>My first commit</td> 
         </tr> 
         <tr> 
            <td>2014-04-11T21:34:30.149193Z</td> 
            <td>USERNAME</td> 
            <td>Creating the project</td> 
         </tr> 
      </table> 
   </body>
</html>
===== svnlog.html =====

XSLT - Processing tool

To process files:
xsltproc stylesheet.xslt file.xml

dos2unix

To convert all the files :
find . -type f -print0 | xargs -0 dos2unix

To convert all the files except those in the « .svn » directories :
find . -type f -not -iwholename '*.svn*' -print0 | xargs -0 dos2unix 

Cygwin - Install (Windows)

www.cygwin.com

Add modules:
- dos2unix (Utils \ dos2unix)
- xsltproc (Libs \ libxslt)
- wget (Web \ wget)
- curl (Net \ curl)
- nc (Net \ nc)
- git (Devel \ git)
- svn (Devel \ subversion)
- ssh (Net \ openssh)
- scp (Net \ openssh)
- openssl (Net \ openssl)

Request forwarding based on HTTP Header

HTTP Proxy example:


<VirtualHost 1.2.3.4:80> 
   ServerName dynamic-proxy.company.com 
   DocumentRoot "/application/web_server/root" 
   CustomLog logs/dynamic-proxy.access_80.log combined env=!nolog 
   ErrorLog logs/dynamic-proxy.error_80.log 

   RewriteEngine on 

   <Directory /application/web_server/root> 
      Order Deny,Allow 
      Allow from all 
   </Directory> 

   AddDefaultCharset UTF-8
    
#################################################################################
#                                        Server #1
#################################################################################

   RewriteCond /application/web_server/srv01/%{HTTP:x-msisdn} -f 
   RewriteRule ^/root/(.*)$ http://srv01.int.company.com/root/$1 [L,NE] 

#################################################################################
#                                        Server #2
#################################################################################

   RewriteCond /application/web_server/srv02/%{HTTP:x-msisdn} -f 
   RewriteRule ^/root/(.*)$ http://srv02.int.company.com/root/$1 [L,NE] 

################################################################################# 
#                                        Server #3
#################################################################################

   RewriteCond /application/web_server/srv03/%{HTTP:x-msisdn} -f 
   RewriteRule ^/root/(.*)$ http://srv03.int.company.com/root/$1 [L,NE] 

#################################################################################
#                                        DEFAULT 
#################################################################################

   RewriteRule ^/root/(.*)$ http://prd01.int.company.com/root/$1 [L,NE] 

   # Avoid Cross Site Scripting 
   RewriteCond %{REQUEST_METHOD} ^(TRACE|TRACK) 
   RewriteRuLe .* - [F] 
</VirtualHost> 

Find path

Linux/UNIX/Mac OS X:
$ which java

Windows XP
for %i in (java.exe) do @echo.   %~$PATH:i

Windows since 2003
where java