Month – May 2010

Free MS SQL 2008 administrator certification

Now that I have your attention, every SMS / ConfigMgr administrator needs to know SQL in order to support SMS/ ConfigMgr. There are no “Ifs” “ands” or “buts” about it, without SQL, ConfigMgr / SMS could not run. You could not write reports or use SSRS. Neither MDT nor WSUS work without it either.  So […]

Chassis type

SELECT Case v_GS_SYSTEM_ENCLOSURE.ChassisTypes0 when ‘1’ then ‘Other’ when ‘2’ then ‘Unknown’ when ‘3’ then ‘Desktop’ when ‘4’ then ‘Low Profile Desktop’ when ‘5’ then ‘Pizza Box’ when ‘6’ then ‘Mini Tower’ when ‘7’ then ‘Tower’ when ‘8’ then ‘Portable’ when ‘9’ then ‘Laptop’ when ’10’ then ‘Notebook’ when ’11’ then ‘Hand Held’ when ’12’ then […]