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

Formulas in MS Excel

------ Formulas

1. Click the cell you want the product of the multiplication formula to go in.

2. Type: =(cellname1*cellname2). Substitute "cellname1" and "cellname2" with the names of the cells you would like to multiply.

Also, to mask some of the columns: "Accueuil/Cellules/Format"

------- SUM a column

  . Type =SUM(  in the cell and then select the cells in the column, press enter

------ open a csv with specific separators in Excel

To open these “|” separated files:
Open Excel / Données/ A partir du texte / importer / Suivant / Séparateurs :autres : « | »

------- to change source cells in a pie graph

   select the cells in the column, drag and drop the cell group on the pie chart 

-------- copy a cell on different lines selected in a column:

    . select the cells, enter the string in the top cell, type "ctrl" + enter

Disable C$, D$ drives sharing

For NT 4.0/W2K/Windows Server 2003s, the change is: (if the key does not exists, create it)

Hive: HKEY_LOCAL_MACHINE
Key: SYSTEM\CurrentControlSet\Services\LanManServer\Parameters
Name: AutoShareServer
Data Type: REG_DWORD
Value: 0