Category: Useful Tips

Conditional Formatting Columns in SharePoint

Posted on by DevPaulC
When working with SharePoint lists there are cases when you need to create a better visualization of data by using Conditional Formatting. Some of these cases would be to make overdue items in red or to highlight items based on their status. To do this in SharePoint Online, lets start with a simple example of a task list. To keep things simple and focus on understanding conditional formatting the list has only 3 columns. Title - a text field Due Date - a date field Status - a drop-down with Open, Closed, Pending Let's format by Status first. Let's...read more

Why is my iPhone Synced Media so big

Posted on by DevPaulC
You may have arrived here because, like me, you noticed that your iPhone Storage media is quite large. Synced Media Storage If you go to Settings - General - iPhone Storage (this is the same for iPad as well), you may notice this additional line item called Storage Media that is taking a lot of space. Apple iOS17 Synced Media Change It turns out, it’s not as bad as you think Before iOS 17, all media for the core Apple apps (Books/Music etc) was shown within that app’s storage. So for example, if you had a bunch of music,...read more

11 Easy ways to speed up Windows 10

Posted on by DevPaulC
Make your PC faster even without installing an SSD. If your computer is starting to feel slower than when you first powered it up, here are some ways to make it faster 1. Disable Transparency Windows 10's Start menu may look good, but that transparency will cost you some resources that slow your PC slightly To reclaim those resources, you can disable transparency. Open the Settings menu and go to Personalization > Colors and toggle off Transparency Effects. 2. Remove Special Effects Windows 10 still has a lot of built-in special effects. Small animations, color changes etc. that make...read more

How backup a table in SQL with data

Posted on by DevPaulC
Before running and update or delete queries, make sure you backup your database. But sometimes you don’t want to backup the entire SQL Database. Sometimes you just want to backup a single table, run your query and revert to the previous version. Here is a simple method to do that. Step 1: Create an identical copy of the table including data Run this command in a new query USE [YourDB]GOSELECT * into YourTable_Backup from YourTableGO This will create an exact copy of your table and will also copy your data. Now you’ll have 2 tables. YourTable and YourTable_Backup Step...read more

Google Sheets edit history

Posted on by DevPaulC
How many times it happened that you deleted or modified something in a Google Sheet or you shared a Google Sheet for collaboration and other people modified it. How do you go back? There is not Undo ? Well, now there is. Google Sheet Edit History For this example I wrote in a cell the following text: "This Cell". Then I typed over: "This Cell was modified". And then I typed over: "This Cell was modified 3 times" Click on the cell in a Google Sheet that you want to see previous values and right click for menu Click...read more

How to insert emojis in email on Outlook

Posted on by DevPaulC
Few may know that Windows applications like Outlook or any Office Applications have a quick shortcut to insert emojis. Next time you want to add a smiley face to your next email, use this little trick to add some of the most common emojis. Press the keyboard shortcut Win & . or Win & ; and get something like this Now you can do several things. You can pick one from your recently used (don't judge) or you can use the category search at the bottom to select a category or you can just type something and they will...read more

How to copy files from WD My Cloud to the attached USB Hard Drive – the fastest way

Posted on by DevPaulC
I had a personal WD My Cloud for a while working as a NAS and I recently added a second Hard Drive for redundancy. I wanted to make sure my data is stored in 2 places in case one of the drives fails. When I connected this second Hard Drive, I mapped the new Shares onto my computer and started to transfer files. It takes FOREVER. So I researched for the fastest method to do that without keeping my computer occupied with this task. And here it is. How to copy files from WD My Cloud to USB drive...read more

What’s the Difference Between Restarting and Shutting Down your computer

Posted on by DevPaulC
It seems logical. When you leave for a long time, shut down and when you just installed your computer restart. It’s not that simple. What happens when you shut down your computer Up until Windows 8, it used to be that a shutdown would turn off the power of your computer completely, clear the memory and it would be a similar action with unplugging the computer. However 2 things changed with Windows 8.  More people started to use laptops, computers with a battery on board, therefore computers would now be capable of saving some of the data in memory...read more

How to use Search operators in Google

Posted on by DevPaulC
Google is the biggest and the best search engine in the world. Sometimes searching through the billions of search results can be tricky. Google search operators can help you modify the typical simple search to give you better and more precise search results. What are Google Search Operators Search operators are text modifiers to your search query that will modify your search to give you specific results. In other words, you can use Google Search Operators to make your search smarter and to find specific information or results on specific websites. Let's take a look in detail at the...read more

3 easy steps to install Windows 11 on unsupported CPUs

Posted on by DevPaulC
Windows registry hack makes the upgrade possible, but should you do it? You’re currently seeing this message: “This PC doesn’t currently meet Windows 11 system requirements” or “The processor isn’t currently supported for Windows 11”. In this post you will learn a registry hack that should instantly make things better and help you upgrade to Windows 11 with a 7th generation processor. You can go from “doesn’t meet requirements” to “ready to install” in minutes.(tested the method on a Lenovo Yoga i5-7300U. This processor in NOT on Microsoft’s compatibility list, even though this computer is 3 years old) Here’s...read more