All posts by Admin

Microsoft SQL Server: How to compare 2 databases

I recently had the problem that a software upgrade that also involved a database upgrade did not work correctly and the database was "half" upgraded. So I wanted to find out what data has changed in this half upgraded database. If you search the Internet, you will find many people recommending some third-party database comparison tools that cost money. But I was looking to find a legal free alternative. Actually, there is one from Microsoft itself: Go and download: SQL Server Data Tools https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt I Read more [...]

Windows 10: Disable Picture on Lock Screen

On the Windows 10 Lock Screen, you can have either a picture or a slide show. If you would like to have a solid background, there is no option for this. Here is what you need to do: Click on the Start Menu and then type lock screen Choose "Lock screen settings" Make sure that under "Background" you have chosen "Picture" Under the pictures, choose "Browse" Browse to C: > Windows > Web > Screen Choose the blue solid picture (this is called "img105.jpg" on my machine). Click Read more [...]

Windows 10: Can't type in Search field

After I had done some changes in Windows 10 to make it faster and less "chatty" to Microsoft (switch off Telemetry, switch off error reporting etc.) I could not use search any more. Symptoms were: Can't type into Cortana search field Can't type to search in Start Menu Can't type to search in Win 10 App Store Can't type in taskbar search Can't type in Settings search There are lots people with the same or similar issues as can be seen from a simple Internet search "win 10 taskbar Read more [...]

iOS: How to turn off Voice Control when you press the Home button

A number of iPhone owners found that "Voice Control" kicks in when they try to unlock their phone. The reason for this is they are holding down the home button for too long. This is, for want of a better phrase, a pain in the face. There is a way to stop it from happening, but it's not straight forward. First things first, this is a bit tricky because Voice Control cannot technically be disabled. To get around this you must enable Siri, which overrides Voice Control. Here's a step-by-step guide. Read more [...]

Kerio Connect: Use it with free "Let's Encrypt" Certificates on IIS

"Let's Encrypt" is an organisation that provides SSL certificates for free in an automated way. While the use is simple on IIS or Apache web servers, on Kerio Connect it is a bit more complicated as it comes with its own web server. Here is how I set it up (there might be other ways, of course, please feel free to add your comments at the bottom of the page). First, download "letsencrypt-win-simple" from https://github.com/Lone-Coder/letsencrypt-win-simple This tool simplifies and automates Read more [...]

Outlook: Disable Auto-Complete of your own Name

Outlook has an editor feature that suggests to insert your full name whenever you start typing your first name. This is really annoying because you might want to use only your first name for signing off your emails (i.e. "Regards, John", instead of "Regards, John Doe"). You can switch it off, but not in the auto-correct or auto-format options, as you might have expected. Outlook has hidden it under "Quick Parts" and "Building Blocks". Here is how to disable this annoying feature: Create a Read more [...]

Windows 10: iPad in recovery mode not recognized by iTunes

I had an iPad that was bricked and i brought it into Recovery Mode to Factory Reset it: Disconnect the USB cable from your iPad, but leave the other side connected to your Mac or PC Launch iTunes Press and hold down the Home and Sleep/Power button on the top of the iPad to turn off the iPad Press and continue to hold the Home button while you reconnect the USB cable to your iPhone, this will cause the iPad to turn on Continue to hold the Home button until an alert message in iTunes Read more [...]

Blackberry: Changes in BES 12.5.0a

On July 26 2016 BlackBerry released "BlackBerry Enterprise Service 12 Service Pack 5a" (BES 12.5.0a) without release notes. So there was no direct way of finding out what the "a" really changed. Digging through the KB articles I found this: http://support.blackberry.com/kb/articleDetail?articleNumber=000038323 So the short answer is: The "a" fixes one specific issue that would block you from upgrading from a previous BES version to 12.5. If you already have upgraded to BES 12.5.0 successfully, Read more [...]

Veeam 8.0: How to remove a restore point manually

Veeam is a good tool to backup and restore virtual machines. After you remove a server from backup (because you have decommissioned it, for example) you might get the following warning: 01.06.2016 11:04:33 :: Server01 is no longer processed by this job. Make sure this change is intentional. This is happening because Veeam still has one or more restore points of this server. If you are sure you never want to restore this server again, you can delete the restore point manually: Backup & Replication Read more [...]

Word 2013/2016: How to remove the extra "Save AS" Dialog Window

Word 2013 and Word 2016 introduced a new window when you use "Save As". Microsoft calls this "Backstage". For me, this extra window has absolutely now value and just means one click more. Luckily, there is a setting that removes that extra window. Here is how: Click on File > Options Tick Don't show Backstage when opening or saving files Click OK What is confusing is that if you go to File > Save As, you will still see the Backstage window! Unfortunately, that tick box only Read more [...]