Windows Server: Sample uses of SETSPN

SPN means "Service Principal Name". In Active Directory you can set an SPN with the command line tool SETSPN. Find below some usage examples which I use often: setspn -Q http/www.mywebsite.com ==> Check if the SPN "http/www.mywebsite.com" exists setspn -L MyServer ==> Show all SPNs for MyServer setspn -X ==> Search for duplicate SPNs in the current domain setspn -S http/www.mywebsite-com MyServer ==> Set the SPN for a specific Server object in AD. This also checks for duplicate Read more [...]

ESXi 6.0: Upgrade vCenter from version 6.0 U2 to U3

If your vCenter has no Internet access, use the following procedure to upgrade it: Go to https://my.vmware.com/en/group/vmware/patch#search Download the VMware-vCenter-Server-Appliance-6.0.0.30000-5112509-patch-FP.iso Copy the .iso to the ESX datastore Connect the .iso file as CD ROM to the vCenter VM Login to the vCenter Appliance via Web Browser https://vcenter:5480/index.html#/update?locale=en Choose "Check updates" > "Check CD ROM" Then choose "Install updates" Once Read more [...]

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 [...]

My experience with servers, networks and gadgets.