Posts

Share tech news, updates, or what's on your mind. Sign up to Post
This could affect YOU if you have ESXi installed on SD cards !!!!!

e.g. DELL EMC have just issued a statement stating the use of SD Mirrored cards (IDSM) is NOT recommended for ESXi 7.x and later, despite that they sold the technology !!! and some DELL EMC R740 shipped with OEM pre-installed ESXi 7.x. using IDSM - Mirrored SD cards!

and now they do not recommend it!

see here

NOTE: If you had ordered VMware ESXi with your Dell EMC PowerEdge server, it is preinstalled on your server. The ESXi installer media is required for reinstallation. The Boot Optimized Storage Solution (BOSS) card is the preferred non-HDD or SSD device for VMware ESXi 7.0 installation. The Dell Internal Dual SD Module (IDSDM) install is no longer recommended due to write endurance issues with the SD flash media. For more information, see the Storage Requirements for ESXi 7.0 Installation or Upgrade section on the VMware ESXi Installation and Setup Guide or see VMware Knowledge Base article 2145210.

https://www.dell.com/support/manuals/en-uk/vmware-esxi-7.x/vmware_esxi_7.0_gsg/getting-started-with-vmware-vsphere?guid=guid-c18ba369-c295-40ea-b289-f82b4cd5270a
1
LVL 62

Expert Comment

by:Pete Long
Hi Andrew
VMware hinted at this last year

https://blogs.vmware.com/vsphere/2020/05/vsphere-7-esxi-system-storage-changes.html
https://blogs.vmware.com/vsphere/2020/07/vsphere-7-system-storage-when-upgrading.html

Since Nov 2020 HPE have actively discouraged quoting for ESX on SD card - citing the VMware warning

</P>
0
LVL 141
So the vendors (OEM) SHOULD NOT supply pre-installed systems with ESXi !!!!!

because the SD cards which DELL EMC/ HPE are supply are worse than what you can purchase from Walmart!

Not disrespect to Walmart!

But you would really think that the SD cards from Dell/EMC and HPE were quality, not a load of shite!

We've all been taken for a ride on this one! especially since from 2004 VMware have convinced us to install ESXi on USB and SD cards, because it was small footprint and embedded! (maybe that was now just a marketing gimmick to beat Hyper-V!"
0
vExpert 2021 Half Yearly Applications now due.

If you want to become a VMware vExpert, talk with me!

Apply here https://vexpert.vmware.com/

I can Mentor you as  VMware vExpert Pro, and help you fill out the application form.

Andy
0
1
EndNote scripts made with AHKscripts-for-EN20.zip
These are several scripts I made (with a lot of help) that automate the process of updating my publications database in EndNote (version 20).  Note that if you wish to use these, you will want to change some of the items in the excludes script and possibly the backup script (although you don't really need to do anything on that one).  I would have uploaded the executable versions except this system wouldn't let me - so just unzip and enjoy.
0
Are you a WSUS-admin and "timely-patcher"? You might have noticed that your servers didn't restart after yesterday's patchday, since Microsoft had problems with WSUS-synchronization. Updates didn't arrive in time on your WSUS and thus, might not be installed, yet. There are several critical updates, see https://www.zerodayinitiative.com/blog/2021/5/11/the-may-2021-security-update-review

So you might want to verify that these get installed as soon as possible.
0
Outlook email body shows blank.
There is an issue that Microsoft is currently working on.
To roll back to the April 23rd, 2021, You could try the following command as a workaround.
C:\Program Files\Common Files\microsoft shared\ClickToRun\OfficeC2RClient.exe" /update user updatetoversion=16.0.13901.20462.

Open in new window

0
LVL 73

Expert Comment

by:McKnife
That does not answer my question. We don't run the CTR version but the MSI version and it does not seem to be affected.
0
LVL 49

Author Comment

by:MAS
Not sure about MSI. CTR yes.
0
0
Vulnerabilities in Vmware, (CVE-2021-21972), (CVE-2021-21973), (CVE-2021-21974).

They affect Vmware versions 7.0, 6.7 and 6.5, in products such as vCenter and ESXi. The vulnerability exploits through the vROP plugin (vRealize Operation Manager), the same vulnerability can cause damage, regardless of whether or not vROP is deployed on the vCenter Server. The attack or malicious code can enter through port 443 (vCenter Communication Port) and through port 427 of the ESXi Hypervisor.

Reference Link.

https://www.vmware.com/security/advisories/VMSA-2021-0002.html

To configure the vROP plugin as incompatible, the information is in the following link

https://kb.vmware.com/s/article/82374.

To proceed with the deactivation of the SLP service, I attach a reference link: https://kb.vmware.com/s/article/76372.
1
VMware Licenses for a Year !!!!

Group Buy - VMUG Advantage Subscription

Sign up now to receive an exclusive tiered pricing opportunity for your VMUG Advantage membership. Eligible for all single year memberships, including renewals. Final pricing is based off of sign ups - so make sure to tell your friends about the limited time offer! Offer only will run until May 12. Quantity Discount Cost 1-199 12% $176 USD 200-299 14% $172 USD 300+ 15% $170 USD 1000+ 15% + entered to win VMUG swag *list price for VMUG Advantage is $200 USD.

https://www.virtuallyghetto.com/2021/04/2021-vmug-advantage-community-group-buy.html

https://forms.gle/aTFaamYuvQQNVNtb6

It's now at 15% discount off VMUG Advantage Subscription
 for a year, sign up top get the discount code!
0
Integrate Azure Web App with NAT Gateway and vNET to get static outbound IP

https://sakaldeep.com.np/1193/azure-web-app-nat-gateway-and-vnet-integration-to-get-static-outbound-ip

I wrote this article as it was a very frequent ask by many of us.
0
SQL Server: Split strings the right way – or the next best way

https://sqlperformance.com/2012/07/t-sql-queries/split-strings

Found this not new but very useful article.
0
Admins, do you like PsExec or Powershell Remoting?
I wrote an article you might find worth reading, as it shows potential security concerns with those and also offers an idea for a safer alternative: https://www.experts-exchange.com/articles/35931/About-the-risks-of-executing-commands-remotely.html
1
0
LiteManager - cross platform screen-sharing app, works on Windows, Linux and Mac OS, there is simple client for Android and IOS.

LiteManager 5
New version of LiteManager 5.0 really free for home and business use, even possible Mac to Mac, Linux to Linux, Windows to Windows connections or any other combinations like Mac to Linux or Windows to Mac or Linux, any way possible.

http://www.litemanager.com/
1
Were you hit with the Windows 10 update this month that crashed printing?  Well, Microsoft now has an out-of-band update that supposedly fixes the issue:


March 15, 2021—KB5001568 (OS Build 17763.1821) Out-of-band
https://support.microsoft.com/en-us/topic/march-15-2021-kb5001568-os-build-17763-1821-out-of-band-c1ce521e-5073-4800-bd1a-09378470d954

March 15, 2021—KB5001567 (OS Builds 19041.868 and 19042.868) Out-of-band
https://support.microsoft.com/en-us/topic/march-15-2021-kb5001567-os-builds-19041-868-and-19042-868-out-of-band-6e0844a2-7551-4b2d-9c4b-4274a5949bf3

March 15, 2021—KB5001566 (OS Build 18363.1441) Out-of-band
https://support.microsoft.com/en-us/topic/march-15-2021-kb5001566-os-build-18363-1441-out-of-band-23c4c824-8638-43e9-a381-ff58213ae6fe



Microsoft Update lists it as an Optional Quality Update.
Reports are that it's not distributed to WSUS though you can manually download it via the Microsoft Update Catalog.
1
Not new but useful

Find the Last Occurrence of a Lookup Value a List in Excel
https://trumpexcel.com/find-last-occurrence/
0
DO NOT UPGRADE TO ESXi 7.0 Update 2 !!’

Due to "crypto64.efi" issue, VMware has pulled ESXi 7.0 Update 2 online/offline depot

@VMware does NOT recommend upgrading to 7.0 Update 2 until a new patch is released

Follow these KBs for more details:  kb.vmware.com/kb/83063 & kb.vmware.com/kb/83107
0
Windows vs. Ford.
 

For all of us who feel only the deepest love and affection for the way computers have enhanced our lives, read on.  At a recent computer expo (COMDEX) : Bill Gates reportedly compared the computer industry with the auto industry and stated,

"If Ford had kept up with technology like the computer industry has, we would all be driving $25 cars that got 1 000 miles to the gallon."


In response to Bill's comments,

Ford issued a press release stating:

If Ford had developed technology like Microsoft, we would all be driving cars with the following characteristics (and I just love this part):

1. For no reason whatsoever, your car would crash.........twice a day.

2. Every time they repainted the lines in the road, you would have to buy a new car.

3. Occasionally your car would die on the freeway for no reason. You would have to pull to the side of the road, close all of the windows, shut off the car, restart it, and reopen the windows before you could continue. For some reason you would simply accept this.

4. Occasionally, executing a maneuver such as a left turn would cause your car to shut down and refuse to restart, in which case you would have to reinstall the engine.

5. Macintosh would make a car that was powered by the sun, was reliable, five times as fast and twice as easy to drive - but would run on only five percent of the roads.

6. The oil, water temperature, and alternator warning lights would all be replaced by a …
2
LVL 71

Expert Comment

by:☠ MASQ ☠
It's only just left it's teens though, this one stated doing the rounds at the end of the 1990's
https://www.snopes.com/fact-check/car-balk/
0
LVL 68

Author Comment

by:Martin Liss
I'm sure your right but my wife and I spent many a happy hour during the past COVID year watching shows like Crazy ex Girlfriend, Jane the Virgin and Hot in Cleveland all over again with a significant amount of new-to-us surprise.
0
Patching your Exchange servers and wondering if you've been hit?

Microsoft has a script for you:
https://github.com/microsoft/CSS-Exchange/blob/main/Security/Test-Hafnium.ps1
1
1200px-Microsoft_Office_Access_-2018.png

Lost code of form


Issue
If you on a form decide to move some controls into a tab control, you normally do a cut and paste of these controls - from the form into a page of the tab control. Then all the events of the controls get cleared; the [Event Procedure] markings are gone and the code behind is detached though still present.  

Solution
To restore these settings, open the code module of the form. Then do:

  1. Mark all code with Ctrl+A
  2. Cut it away with Ctrl-X
  3. Select menu Debug, Compile
  4. Paste all the code back into the empty module with Ctrl-V
  5. Select again menu Debug, Compile

Now your event procedures are hooked up again.
0
AccessUserGroups.org launched a new tool that will convert your Access queries over to TSQL.  If you specialize in converting Access to SQL Server, this tool will be a real time saver! But it gets better with the ability to also create a string you can paste into your code.  Juan Soto of AccessExperts has a great description at:
https://accessusergroups.org/blog/accesssqltool/
Please note it’s still in BETA and we are looking for feedback, which you can provide by clicking on the feedback button. Read the post and head on over to the tool to learn more!

You can find the tool at
https://accessusergroups.org/sql-converter/
0
#Hugops
It is so easy to not see all the hard work that goes into keeping a site going when everything is going well. But when things go south... a different story. Thanks to all the DevOps, sysadmins, Operations engineers, etc!

"So next time your favorite website goes down, remember -- don’t get mad... #hugops."

https://thehustle.co/03032021-hugops/
2
Get your fresh, hot 0-Day Exchange patches now!

Do you still run Exchange on prem?  

https://www.microsoft.com/security/blog/2021/03/02/hafnium-targeting-exchange-servers/

Even if you're not targeted YET, now that this is publicized, I would expect many to come up with scripts to find you and attack you.  PATCH NOW!
0
LVL 53

Expert Comment

by:kevinhsieh
My team is already patching.
0
Super Cheap Discount Deal available for Surfshark VPN Software at the moment

This post will read like an ad, and I guess it is, but it's an offer I thought is just too good not to share with the EE Community.

I recently gave Avast's VPN the flick and ended up disappointed after trialling Malwarebytes Privacy VPN performance for 7 days as well, so after reading a ton of reviews on software VPNs, I decided to give Surfshark VPN a try.

Surfshark's performance when comparing it to Avast and Malwarebytes VPNs at various times of the day and night, changing from one to the other and using the same country servers was impressive. Up to 30% faster on download, upload, and ping times. I've taken snapshots of the results of my tests that I intend to use for an article on VPNs in the near future.

With results like that, I decided to purchase a 2-Year subscription for a Total Cost of $59.76 AUD - and no - that's not a typo. Using the free ShopBack App I wrote an article about, I also got an additional 25% Cash Refund too :-)

The discount/deal can be found here: https://order.surfshark.com/

Guaranteed 100% refund of your payment if you're not happy with it in your first 30 days of use.

Unsure of how long this discount deal will be valid for so if you're considering purchasing a VPN, check it out now.

A list of the benefits delivered to all of their subscribers.

  • Unlimited installs to as many devices you want to protect, whether that be 1, 5, or over 50 installs
0
PowerSchool SIS ODBC (Oracle DB connection)

Thanks to Evan Hines & slightwv for pointing me the right way.
(https://www.experts-exchange.com/questions/28235072/ODBC-Access-to-PowerSchool-Oracle.html)

Quick walk-through detailing steps in order
On client machine (not the system containing database; the system that’s going to pull the data instead)…

You need 3 downloads:

 Instant Client Package - Basic
 Instant Client Package – ODBC
 Microsoft Visual Studio 2017 Redistributable
 
http://www.oracle.com/technetwork/topics/winx64soft-089540.html 

Create a new folder (i.e. c:\Drivers\oraclepsODBC)

Unzip contents of “Basic” package to created folder

Unzip contents of “ODBC” package to same created folder (combine duplicate folders; files from ODBC package should be in same directory as basic package contents) (i.e. EVERYTHING including odbc files should be in here…. C:\Drivers\OraclePsODBC\instantclient-basic-windows.x64-19.10.0.0.0dbru\instantclient_19_10)

Right-click odbc_install.exe and open properties.

“Unblock” installer on general tab and click OK

CMD as administrator and change directory to location you created and combined like folders (i.e. cd c:\oracle\odbc\instantclient-basic-windows.x64-19.10.0.0.0dbru\instantclient_19_10\)

Type odbc_install.exe and hit enter

ODBC driver should now be installed and ready for use

You can now create a DSN (ODBC data source) connection on the client workstation.

Type ODBC in your start menu and choose the appropriate (x86 vs …
1

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month