Cygwin survival kit

cygcheck -p

--- crontab:
cygrunsrv -I cron -p /usr/sbin/cron -a -D
net start cron

Vista / W2008server / Windows7 survival kit

* Reading the following, some folders are 'virtualized' on Vista
http://support.microsoft.com/kb/927387

The way around I took, is to create a c:\MyProgramFiles

* To add 'SendTo' shortcuts:
C:\Users\myusername\AppData\Roaming\Microsoft\Windows\SendTo

* Stop continuous OS Disk Access (Vista):
- "points de restauration" in Panel/System/System protection
- Windows Defender

* Remove corrupted thumbnails in Windows7
- cleanmgr.exe (system32) and select "thumbnails". You may have to switch to the "details" view, and back again to the "large icons" view to finalize the reset

Initials

- AD: Active Directory
- ACL: Access Control List
- CLR: Common Language Runtime
- CLI: Common Language Infrastructure
- CPL: Courant Porteur en Ligne = Power Line Communication (PLC)
- CMF: content management frameworks
- CMS: content management system
- ERP: Enterprise Resource Planning
- GAC: Global Assembly Cache
- GED: Gestion Electronique de Documents
- LRU: Least Recently Used
- IT: Information technology
- LAMP: Linux, Apache, MySQL and PHP
- MOA: Maitrise d'ouvrage (cree les specs, effectue la recette), parois appele "metiers"
- MOE: Maitrise d'oeuvre (recommande, implemente)
- MVP: Minimum Viable Product  (asked as a first step for start up )
- PLN = CPL
- RIA: rich Internet application
- SLA: Service Level Agreement. In practice, the term SLA is sometimes used to refer to the contracted delivery time
- WMI: Windows Management Instrumentation
(nom du service en francais: Lanceur de processus DCOM)

SQL survival kit

SELECT * FROM ITL WHERE str CONTAINS  'BBB';   --> exact match 
SELECT * FROM ITL WHERE str LIKE  'C';         --> starts with 
SELECT * FROM mytable WHERE Md IS null; 
SELECT * FROM mytable WHERE Id>5; 
SELECT count(*) FROM mytable;                  --> count the number of rows
UPDATE table_13 SET Width=50, Height=50 WHERE id=1; 
ALTER TABLE mytable ADD COLUMN Width int; 
ALTER TABLE mytable CHANGE col col_new_name VARCHAR(255); 
RENAME TABLE mytable TO newtable;

DELETE FROM `mytable` WHERE Url LIKE '%sylvain%';
DELETE FROM ourson_offer;
DELETE FROM lt.image WHERE lt_kimage_id IN (select lt.image.lt_kimage_id from lt.image INNER JOIN lt.keyword ON lt.image.ltu_kimage_id = lt.keyword.lt_kimage_id WHERE lt.keyword.keyword LIKE '%_dead' ORDER BY lt_kimage_id LIMIT 100000);

jointure explicite:

SELECT *   
  FROM employee INNER JOIN department
  ON employee.DepartmentID = department.DepartmentID; 

jointure implicite:

SELECT *   
  FROM   employee, department  
  WHERE  employee.DepartmentID = department.DepartmentID; 

• list sorted column names of a table 

SELECT COLUMN_NAME FROM information_schema.columns WHERE table_schema='app_v2' AND table_name='guest' ORDER BY COLUMN_NAME;

Perl's survival kit

[] empty array
{} empty hash

my $toto = shift equivalent to shift(@_) meaning the first function parameter.

msbuild.exe

c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\msbuild.exe "c:\build\MyBuild.sln" /t:Build /p:Configuration=Release;Platform=Win32 /v:diag

Switch AZERTY/QWERTY key settings (when it is changed using Studio)

When using Visual Studio, it happens that the key settings change from AZERTY to QWERTY. To put them back:

left ALT + SHIFT