If you’re working with data in Power BI and would like to count how many duplicates there are, the below example will help you. Let’s start with the table structure. For this example, lets says […]
If you need to test something, but don’t want to risk changing or damaging your existing Windows installation, then you can utilise something called Windows Sandbox. This basically creates an isolated sandbox machine, which is […]
If you have a column containing numeric values in your Power BI report, depending on the graph, it can sometimes be too much and produce some messy graphs, like the below: To make this look […]
If you need to work with multiple files (e.g. log files) and want to identify them by using wildcards, you can take the below approach: 1 Identify the folder to work in, and add it […]
If you have a Škoda Enyaq iV, and have experienced difficulties with the infotainment system connecting to the internet, perhaps with a message saying ‘unable to load connection status’ or if you cannot disable private […]
Unfortunately, Škoda, for cost saving reasons (I presume), chose to only provide one umbrella in the new Škoda Enyaq iV. They provide one for the driver, but not the passenger. Personally, I think the umbrella […]
Have you noticed that the key for your Škoda Enyaq flashes? In fact, this might not be limited to the Enyaq, it could also extend to other cars built by Audi, Škoda and VW. The […]
If you don’t have the matrix light package, and would like to enable the auto high beams on your Škoda Enyaq iV, then you can, by following this guide. WARNING Although I’ve taken the time […]
If the sat nav in your Škoda Enyaq is displaying the maps with a day view (shown below), even at night, you might find that too bright. I know I do. It’s easy to change […]
Unfortunately, the reversing lights and reversing camera on the Škoda Enyaq aren’t as good as you would want, well not when there is no street lighting, as the camera doesn’t have night vision. When you […]
If you have recently moved/upgraded to Windows 11, and miss the left aligned taskbar from Windows 10, then the good news is that you can left align it by following the below steps: 1) Right […]
Ordinarily, when you order a new car, you know how long it will take, and are most likely happy to wait. However, you might be impatient, like I was after waiting an additional two months […]
If you’re lucky enough to be able to buy a brand new car, you’ll know that it feels good knowing that you’re the first person, and possibly the only person, to drive it. However, if […]
If you have Sky Q, you might be surprised to hear that you can use your Sky Q box(es) as Wi-Fi repeaters, even if you don’t have Sky broadband. To set it up, follow the […]
Are you new to Sky Q, or finding some every day functionality slow and clunky? If so, then the below shortcuts, tips and tricks should prove useful. 1) Quickly access your recordings To access your […]
If you’ve ordered a new Škoda and are confused by the number status codes, then you might find the below useful: Status code Description 00 Assigned to factory, no production week scheduled 10 Production week […]
Have you ever wanted to view all of your iPhone and/or iPad apps alphabetically? I hadn’t, but I stumbled accross this and thought it might be useful to some people. Here’s how to do it: […]
I’ve ordered a Škoda Enyaq iV, and although I noticed it had drum breaks when I test drove one, I didn’t really give it much more thoughts on the day. However, I now find myself […]
I’ve decided to do my bit for the environment, and my wallet, and make the move to an EV (Electric Vehicle), and I thought I’d share my experiences with you, as I go through the […]
If you have, or are buying and EV (Electric Vehicle), then it’ll be worth you looking at a tariff that will helps you to save some money by charging your vehicle in the early hours […]
From time-to-time, you might experience a laggy infotainment system, or even worse, it may freeze. If this happens to you in your Škoda Enyaq iV, try resetting the infotainment system by following the below single […]
Whilst creating an application, which works from a central job list, I found myself wanting to perform both a select and update query at the same time. Essentially, marking jobs as collected, at the same […]
If you followed my other guide on how to install Pi-hole in a docker container on a Raspberry Pi, then this guide will help you to upgrade it. If you didn’t setup Pi-hole using my […]
If, like me, you have some temperature sensors, Philips Hue Motion sensors in my case (they include LUX and temperature), around the house, and you want to automate tasks, you’ve probably noticed that you cannot […]
So I’ve had the Flashforge Creator Pro 2 for a couple months now, and I’m still enjoying it. I’ve not really done much practical with it yet, but I’m still having fun with my prints. […]
Before we start, it’s important for you to note that this isn’t a supported setup for the Flashforge Creator Pro 2 to work with OctoPrint, it’s more of a work around. So it’s completely at […]
After printing a ton of stuff in PLA, I thought I’d try printing with a different material in my new Flashforge Creator Pro 2. I thought about ABS, but after doing some research online, temperature […]
I’m fairly new to the world of 3D printing, but wanted to get into it as a hobby, but also because I need plenty of brackets for the smart tech installed around my home. After […]
Out of the box, OctoPrint / OctoPi works with ethernet, but to run it over wi-fi, you need to make a few simple changes. So let’s get started: Step 1 Connect your OctoPi Micro SD […]
If you have a 3D printer without an IP connectivity (e.g. ethernet / wi-fi), but you’d like to gain some remote control and monitoring, then OctoPrint will help you. Essentially, you connect a Raspberry Pi […]
Copyright © 2021 | Richard Wallace
