Sky / Sky+ / Sky HD / Sky Q
Sky Q Hidden Engineers Menu
If you have Sky Q, there’s a hidden engineers menu with some extra options including the ability to change the wi-fi bands and enabling connectivity over your home’s existing electricity wiring (known as powerline). Sky […]
Sky / Sky+ / Sky HD / Sky Q
Change your Sky Q AirPlay / Bluetooth name
If you have multiple Sky Q boxes, say a Sky Q Silver and two or three Sky Q Mini boxes, the similar airplay/bluetooth names can be confusing. The good news is, that you can change […]
Microsoft Office
Microsoft Excel cannot open or save any more documents because there is not enough available memory or disk space
If you are seeing the ‘Microsoft Excel cannot open or save any more documents because there is not enough available memory or disk space‘ error, this might be misleading and the cause is likely nothing […]
- Create a SQL Server index without locking the table
- How to disable basic authentication and enable modern authentication on Office 365
- How to clear the browser cache on an iPhone or iPad
- Sky Q Voice Commands
- Sky Q, using voice commands to run apps
- How to setup a iOS home automation task using an NFC tag and the iOS shortcuts app
- How to set the PowerShell Window Title
-
Richard Wallace: I’ve just done another post for you (link below). I hope it helps. Sky Q Voice Commands
-
Cathy: What else can I tell Sky Q to do?
-
Home Automation
How to setup a iOS home automation task using an NFC tag and the iOS shortcuts app
If you have an iOS 13, or later, device with an NFC reader, you can use it to automated tasks around your home. Why, you might ask. Well it won’t be for everyone, but for […]
PowerShell
How to set the PowerShell Window Title
When running multiple scripts, either at the same time, or sequentially, it’s nice to know which script is running. An easy way to do this, it to set the title of the PowerShell window, when […]
Windows 10
Enable or disable hibernate in Windows 10
If, like me, you want to set your computer to hibenate, instead of sleep, you’re probably annoyed that this option is not on by default. Sleep has it’s place, but it still uses power. Thankfully […]
Mircrosoft SQL Server
Diagnose SQL server by viewing running and queued queries
If you run a busy SQL server an experience performance issues, there are several things you can do to diagnose issues. I’ll ignore the obvious ones for now (ensuring your queries are streamlined and using […]
C#
C# Detect HTTPS in a load balanced environment
Detecting HTTPS in your asp.net c# web app is fairly straight forward in a normal environment with a single server solution, as you can see from the below example:
|
1 2 3 4 5 6 7 8 |
if (HttpContext.Current.Request.IsSecureConnection) { Response.Write("Using HTTPS"); } else { Response.Write("Using HTTP"); } |
The problem comes when your […]
Sky / Sky+ / Sky HD / Sky Q
Change your Sky Q AirPlay / Bluetooth name
If you have multiple Sky Q boxes, say a Sky Q Silver and two or three Sky Q Mini boxes, the similar airplay/bluetooth names can be confusing. The good news is, that you can change […]