How do you turn off the Outlook email sidebar in Microsoft Edge?

Microsoft have recently made a change to how internet links open from within Outlook. The link now opens in Microsoft Edge and also shows the email content in a box to the right known as the side pane.

Some people like it, some don’t. Here’s how to turn it off.

  1. Open Microsoft Edge and click the ellipsis button (top right)
  2. Go to Settings (cog icon)
  3. Under the Settings heading click “Sidebar
  4. Under the heading “App and notification settings” then sub heading “App specific settings” look for Outlook and click it
  5. Turn it off by clicking the “Automatically open Outlook email context in the side pane” toggle.

Visual Voicemail not working on iPhone

If you are having issues with visual voicemail not working on iPhone then here’s a few tips on how to get it working! It’s happened to me a few times whether it’s because I switched phones, changed plans or got a new sim.

  1. Contact o2 customer support. You can do this from your o2 phone by dialling 202, or contact them on social media at facebook, twitter or instagram and drop them a message.
  2. Ask them to turn on the “iData Bolt On”
  3. On your iPhone go to Settings > General > Transfer or Rest iPhone > Reset > Reset Network Settings

After you’ve done step 3 your phone should reboot and hopefully visual voicemail will start working.

Quickly delete all records from a MSSQL database table

How can you remove all data from a table efficiently? Using the delete command can take a very long time if you have lots of data.

If you want to delete all rows from the table – the simplest way to do this is to use the TRUNCATE command.

TRUNCATE TABLE table_name

Remember that the table cannot have foreign keys constraints, but there is a workaround. You can delete foreign keys temporarily and recreate them afterward.

Action steps:

  • Drop the FK constraints
  • Execute TRUNCATE command
  • Recreate the FK constraints

Once you removed all rows – consider resetting the identity value as follows:

DBCC CHECKIDENT ('table_name', RESEED, 0)

Shout out to Piotr Bach for the article that can be found here

Update many SSL certificate site bindings in one go

If you have to deal with updating SSL certificates in IIS then you probably know how much of a pain it can be if you have lots of sites and bindings that all use the same certificate. I found a really simple PowerShell script that can go through and match the thumbprint of your old certificate on all bindings in IIS and replace them with the thumbprint of your new certificate! This is particularly useful if you have a wildcard multi-domain certificate that you can use on all sites regardless of hostname!

Open up a PowerShell window with administrative rights then enter the following commands. Obviously you will need to replace the thumbprint values below with yours.

The first one will set a variable for the old certificate

$OLDCertificateThumbprint = "123456789abcdefgh1a2b3c4d5e6f7g8h9a1a1a1"

The second will set a variable for the old certificate

$NEWCertificateThumbprint = "7a3b5a1g1a6a2j2a262a3343a333a5a64a4a4a4a"

The following will show bindings where the old certificate is in use

Get-WebBinding | Where-Object { $_.certificateHash -eq $OLDCertificateThumbprint} | Format-Table

This will select bindings where the old certificate is in use and switch it to the new certificate

Get-WebBinding | Where-Object { $_.certificateHash -eq $OLDCertificateThumbprint} | ForEach-Object {
Write-Host "Working on" $_
$_.RemoveSslCertificate()
$_.AddSslCertificate($NEWCertificateThumbprint, 'My')
}

Once the script above has completed you can use this to show bindings where the new certificate is in use

Get-WebBinding | Where-Object { $_.certificateHash -eq $NEWCertificateThumbprint}

Now that everything has been updated you can go into IIS to check it out.  Big thank you to the following people here and here for providing these solutions.

How to check Wi-Fi signal strength on Windows using command prompt (cmd)

On Windows 10 / 11 there are a number of ways to check the wi-fi signal strength but I find the most accurate and simple way is using command prompt.

  1. Open up a command prompt by clicking start, type cmd then click “Command Prompt”.
  2. Enter the following command and press “Enter”.
    netsh wlan show interfaces
  3. Check out the “Signal” value to determine the quality of your connection.

If the number is equal or higher than 80%, then the strength of the signal is good. Anything below 60% is pretty poor.

Office 365 Group not showing in Outlook (Exchange Hybrid Environment)

PROBLEM:-

I have an issue where a Microsoft 365 group has been created but will not appear in Outlook 2019 or Outlook on the web.

After a bit of digging, I found out that the following factors played a part in this.

  • Exchange is running in Hybrid environment
  • User had created the Group/Team from within MS Teams

Because we were running a hybrid environment and the user had created the Team/Group from within the MS Teams app it doesn’t do as good a job as it would if you created it via the web-based admin interface.

When the group is created from the MS Teams app it doesn’t set the exchange attribute –HiddenFromExchangeClientsEnabled:$false which means that by default the group will not appear in Outlook App or Outlook on the web.

If you create the group via the Microsoft 365 admin center it works fine.

SOLUTION:-

1. Open up Windows Powershell and connect to Exchange online using the following command. (Make sure you have Powershell 7 and the exchange EXO V2 module installed).

connect-ExchangeOnline -UserPrincipalName youremail@yourdomain.com

2. Set the groups visibility using the following command

Set-UnifiedGroup -Identity "Name of Your Group Here" -HiddenFromExchangeClientsEnabled:$false

Install the latest Windows PowerShell and Exchange Online Management EXO V2module

I often find that I’ll jump on to a server, PC or laptop and I’m trying to run commands in PowerShell that it doesn’t understand. Normally because it’s an old version of PowerShell, certain modules aren’t installed or I’m just bad at typing.

Here’s where to get the latest version of Windows PowerShell and EXO V2 that you will need if you’re working with Exchange Online.

PowerShell 7
https://aka.ms/PSWindows

Exchange Online Management
https://www.powershellgallery.com/packages/ExchangeOnlineManagement/

At the time of writing the following command will get you the module…

Install-Module -Name ExchangeOnlineManagement -RequiredVersion 2.0.5

Check what modules are installed…

Get-InstalledModule
Fox Ranger 2.5L Water Jacket

Fox Ranger 2.5L Water Jacket Review

https://foxracing.co.uk/product/ranger-2.5l-water-jacket/27361.html

Features:-

  • Advanced weather protection for a wide range of weather conditions
  • Lightweight 10K/3K 2.5-layer, waterproof, breathable main body fabric
  • DWR finish sheds moisture, dirt, and debris
  • Two zippered front hand pockets
  • Draw cord, cinching at hem and elastic cuff, provides customized fit
  • Helmet-compatible hood fits over most helmets
  • Length (HPS): 29″, size large
MATERIALS
  • 100% polyester ripstop, 2.5-layer fabric
  • Weather rating: 10K waterproof, 3K breathability

Nice jacket, looks great but could be better…

I’ve had this jacket for about 11 months. I live in the UK and have used it through the winter so it’s seen PLENTY of rain! First off it’s a great looking jacket and I’ve worn it on and off the bike. It fits well and does keep the majority of the elements out. It does a good job in general and I wanted to love this jacket but there are a few little things that could be done better which is probably why I wouldn’t recommend it.

The hood… it’s big and can easily fit over your helmet… great, but it doesn’t have any bungee type cords to pull it snug around your neck / helmet / head so when you’re bombing down a trail in the wind and rain it acts like a sail then flies off the back of your head and starts to fill with rain. This also means that if you’re not wearing a helmet and put the hood up, it goes over your head and face and again blows open in the wind. If you don’t put the hood up and it’s raining or windy then it flaps about quite a bit and you cant make it fit snug around your neck.

The last thing I think is missing is some kind of ventilation (apart from the gaping neck hole!). Lot’s of modern jackets have ventilation of some description whether it be under the arms or the sides but this has none so can get a bit “boil in the bag” but I understand that this might be the case for most jackets of this type anyway.

Overall I like the aesthetics of the jacket but the hood lets it down.

Drivers for Digital Persona U.are.U 4500 Fingerprint Reader USB

Below you will find 2 zip files that can be used to get your Digital Persona U.are.U 4500 up and running. The first 4500_wbf_driver_5.0.0.5_rs3.zip is smaller in size and is just the basic drivers, probably all you need to get up and running on Windows 10. The second DP_UareU_WSDK223.zip I believe is the SDK kit and has all the drivers and full software.