Category: Tech Tips

Technology related posts. Tutorials about every day tech, software or computer tips. Optimize your technology, build automation.

How to take a screenshot on a Windows 11 PC

Posted on by DevPaulC
Windows 11 took the Snipping tool to the next level in Windows 11. Not only the Snipping tool can take a screenshot of a part of your screen or use a delay to help you capture an open drop-down but now it can take short videos that you can use to demonstrate a short functionality to a colleague by quickly snipping a video and attaching it to an email or sending ti through a Teams chat. The Snipping Tool The Snipping tool helps you take a selective screenshot on a Windows 10 or Windows 11 PC. Instead of capturing...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 to remove the Audible Originals from your library

Posted on by DevPaulC
Audible Originals are more like Podcasts than AudioBooks. But you'll notice there is no way to remove them from your mobile app on iPhone and Android. However, there is a way. To do that, you have to go on the computer to your Amazon Account. Go to Accounts and Lists and then to Manager Your Content and Devices Once you are there, select to Show Audiobooks from the drop-down and select the Amazon Originals episodes you want to remove and DELETE from your library using the Delete button. Although, I don't recommend removing Michele Romanow's "The Revisionaries". It is...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

What is the Power BI service

Posted on by DevPaulC
If you are just starting with Power BI you might be confused of all the Power BI products you encounter. Power BI Service Power BI Desktop Power BI mobile app The good news is, they are all part of the same product but they perform different functions. Click on them to find out what purpose they serve Power BI Service Microsoft calls Power BI service the web portal where all your Workspaces, Dashboards, Reports and Datasets are stored. To access the Power BI Service go to powerbi.microsoft.com and login with your Microsoft account. Based on your subscription, you would...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

What is Power BI Desktop

Posted on by DevPaulC
Power BI Desktop If you look in the Microsoft Store you will find two applications that you can install on your Windows PC. One is Power BI Desktop and the other is Power BI Mobile. Install the Power BI Desktop if you are planning to create reports in your organization. All Power BI products (Service, Desktop and Mobile) are used with the same Power BI Licence you have. Power BI Desktop is a Desktop application similar with Excel in some ways. It installs on your computer and you can import data, transform data using formulas, merge data, create data...read more

How to learn Power BI – Frequently Asked Questions

Posted on by DevPaulC
Power BI is a powerful reporting tool. It is part of the Microsoft Power Platform and works very well with a variety of Data Sources starting with text, coma separated value files, Excel files and all the way to massive cloud databases. What is Power BI used for? Power BI is the best tool for making sense of the data. instead of looking at tray data and spending time in Excel to filter and group data, you can easily build visualizations and filters in Power BI to make data easy to understand. Each team may be interested in a...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