Andy's VMware vSphere tip#8: Spectre and Meltdown....Have you patched your server yet? It's almost 5 months since this Security Flaw was found in Intel CPUs, and we are still finding many VMs, and Hosts in the wild which are still not patched!
Remember this actually requires a little bit of work... To successfully patch against Spectre and Meltdown, you must:-
1. Update the BIOS and Firmware, and maybe CPU microcode in the Host ESXi Server. Some BIOS updates update the microcode for you. Check with your Server Vendor, some server vendor have been very slow to release new BIOS/Firmware/Microcode updates, and some servers may be now end of life, as server vendor may not release new code.
2. Update vCenter Server to 6.5 U1g, 6.0 U3e or 5.5 U3h.
3. Update the ESXi Build to the latest versions
ESXi 6.5: ESXi650-201803401-BG* and ESXi650-201803402-BG**
ESXi 6.0: ESXi600-201803401-BG* and ESXi600-201803402-BG**
ESXi 5.5: ESXi550-201803401-BG* and ESXi550-201803402-BG**
4. Update VMware Tools and all virtual machine hardware versions to 11.
for all you VMware fans out there, and a Cautionary Tale! (why not to use vCenter Server for Windows), and keep continually upgrading as each version of vCenter Server comes out, at a client site, where they've been using Windows Server 2012 to Host vCenter Server, and have resisted heavily to use VCSA. (Linux Appliance). They upgraded from 5.0 to 5.5, and then 5.5 to 6.0 (which caused many days of issues).
Now just trying to upgrade from 6.0e to 6.0h, has caused VMware Support a headache, trying to get this to go... and it's now been over 1 week, trying to get this to function!!!!
I need to write query retrieve the loan number, state and city, customer first name for loans that
are in the states of CA,TX,FL,NV,NM but exclude the following cities (Dallas, SanFrancisco,
Oakland) and only return loans where customer first name begins with John.
I keep getting error syntax can .