Skip to main content

Posts

SOLVED: Convert old Equation Editor 3 document to new Office equation format for free

Microsoft has suddenly disabled Equation Editor 3 in Office for "security reasons" and in order to force you to buy new Office 365 / 2019 they don't even offer a way to convert your equations to the new format. Another option is to buy the expensive MathType. Look here: https://support.office.com/en-us/article/editing-equations-created-using-microsoft-equation-editor-08a44b8c-ae15-41a7-bc15-7239890c0cec#ID0EAADAAA=Office_2016,_2013,_or_2010 This is really really annoying but fortunately I found a way to convert to the new equation editor format for free using the great open source LibreOffice : Make sure that you have enabled Mathtype conversion in LibreOffice settings Open your Word document in LibreOffice Save your document as Microsoft Word .docx Open the converted document in Word to see that it has been converted Thank LibreOffice for offering you this great feature for free!!! "Thank" Microsoft for making your life as hard as possible and think a...
Recent posts

SOLVED: GPO blocks Windows Meltdown / Spectre Update KB4056892

Dell was very fast to release BIOS updates (version A21) just a few days after the Meltdown / Spectre disaster became public. So I installed them on all of our Dell 9020 PCs and M4800 notebooks and I thought that everything was fine as I had automatic Windows Updates enabled... But then I noticed that the required Windows Meltdown / Spectre Update KB4056892 was not installed for some reason. So I decided to run the Meltdown / Spectre PowerShell test script released by Microsoft and the surprise was that everything showed up in red, i.e. nothing was patched, not even the BIOS! Then I suspected Kaspersky that might be preventing the Windows update from installing because I read about some AV conflicts. But Kaspersky did really fine this time - it had set the registry key allowing the update to install correctly on all computers. So what was the problem? Microsoft is the problem as usual! I had set some GPO to prevent preview builds and feature updates from installing imme...

Adding a SATA controller to Dell PowerEdge T30 server - more drives and UEFI

The Dell PowerEdge T30 is a very compact and affordable server with Intel Xeon CPU and 8 GB RAM. In contrast to Lenovo and some others, drive caddies and SATA cables are included here and there are no artificial limitations built in. Now you can connect 4 disks to Dell's onboard SATA Intel controller. But if you want to use it as e.g. a high performance NAS and run Windows Server 2016 you will probably need more than 4 SATA ports! In my situation I wanted to install a small Samsung SSD as a boot drive (there is space for it in the case), connect the internal DVD-ROM and also add 4 x 10 TB Seagate Enterprise Capacity (Exos) hard drives for NAS functionality - so a total of 6 drives. Using Windows storage spaces in mirror mode, maybe with ReFS 3.1 should replace a hardware RAID controller and make it even more reliable. So in order to be able to use 6+ SATA drives I needed an additional PCIe SATA controller; this is even stated in Dell's manual. After a lot of research it t...

Veeam Backup & Replication: "Failed to execute script in guest OS" (Linux Guest VM on Hyper-V)

Problem: Veeam Pre-Freeze / Post-Thaw .sh Scripts Fail on Linux Guest VMs (e.g. Ubuntu) with "Failed to execute script in guest OS" although the scripts run fine. I use Hyper-V but that should not matter. Failing scripts are configured to "Require successful script execution" under "Application-Aware Processing Options" under "Guest Processing" in the Veeam backup job. My Solution: Some commands executed inside the scripts seem to return error output which is passed back to Veeam through the script and confuse Veeam so it reports that the script was not successful. So we must redirect error output from such commands to 2>/dev/null or some file, otherwise error status is passed back to this script and Veeam reports a failure. For information about discarding error output, see https://bash.cyberciti.biz/guide//dev/null_discards_unwanted_output Additional information: Also make sure that Veeam scripts (*.sh) are located on the Veea...

SOLVED: Network connection problems (shares, domain) after Windows 8.x wakes up from standby (sleep)

The Windows 8.x Standby / Wakeup from Sleep Problem: Some time ago I set up multiple Dell Optiplex 9020 mini towers with Windows 8.1. After testing standby / sleep mode I noticed a very strange and annoying problem: Whenever the PCs are waken up from sleep (standby) all connections to open network shares and open Office 2010 documents are lost . All shares are on a Windows 2012 R2 ESSENTIALS server + domain controller which runs as a Hyper-V VM. So after waking up a Dell 9020 from standby I get my Win 8.1 login prompt, log in, but for any open shares that were open when the PC went to sleep in explorer, now I randomly get either a domain authentication error message or a new authentication prompt that asks me for domain username and password. The connection to open Word 2010 docs is always lost and Word tells me that the computer came back from standby but a connection problem occured and the document is now read-only, i.e. it must be saved as a new document. Very an...

Changing the Reserved IP Address in a Static DHCP Reservation in Windows Server

  Static IPs preferred DHCP is a good thing if it works - set and forget. But what happens if the DHCP server is down for some reason? Exactly - the whole network stops working. Another problem of DHCP are those random IPs a client gets each time. This is very bad for printers that use DHCP. Therefore I prefer static IPs over dynamic.   Windows Server 2012 R2 Essentials: You cannot stop Windows LAN Configuration Service anymore Unfortunately, there is some strange behavior on Server 2012 R2 Essentials if you just enter static IPs on your Windows clients - your Windows OS will show exclamation marks on your network connection from time to time, etc. There is actually a Windows Server LAN Configuration service which keeps overwriting your manual settings and the bad thing is that you cannot stop that service in Server 2012 R2 any more for some reason...So, instead, I decided to use DHCP on the server and add an Alternative IP Configuration with all static data as...

Backup to USB disks: Do-it-yourself setup for USB drive rotation / swapping

I was looking for a simple but effective solution to use external USB disk drives attached to my server for backup with backup applications that do not directly support USB drive rotation / swapping. Unfortunately, Windows does not seem to support assigning the same drive letter to different USB drives, e.g. you cannot assign the letter U: to two different USB drives. This would be nice to be able to rotate the drives but it does not work. So my idea was to use a network share name that automatically mounts different USB drives to the same share name , depending on which USB drives are connected, that creates some sort of priority as we will see. An additional advantage is that drive can be also accessed directly from other computers through the network share. The first step is to assign different drive letters to each USB disk through Windows disk management, e.g. U: and V:. Then create the same directory to be shared on each drive, e.g. "USB_SHARE". Backups will be...