Posts

Step-by-step guide to adding emojis anywhere in Microsoft Windows - including Outlook

Image
Emojis are a fun and creative way to add personality to your emails and messages. They can help you express emotions, convey tone, and make your messages more engaging. Adding emojis to your emails and messages is easy and can be done in just a few simple steps. In this guide, we will show you how to add emojis anywhere in Microsoft Windows, including Outlook messages. Whether you’re using Windows 10 or 11 Put your cursor where you want the emoji to appear. Press the Windows key and the period key (.) simultaneously to open the Windows emoji picker. Select an emoji from the picker by clicking on it. The selected emoji will be inserted at the cursor location. Easy right?

Step-by-Step Guide to Finding the Owner of a Microsoft Form Using Inspect, Refresh, and Azure AD

Image
Microsoft Forms is a powerful citizen tool for creating surveys, quizzes, and questionnaires. While it offers great functionality for collecting responses, finding the owner of a specific form might not be immediately obvious. In this blog post, we'll walk you through the process, step by step. Step 1: Inspect the Elements Open the Microsoft Form for which you want to find the owner. Right-click on the page and select "Inspect" (or use the keyboard shortcut Ctrl+Shift+I). The browser's developer tools will open, showing the HTML and CSS code for the page. Step 2: Refresh the Form Page With the developer tools still open, press the "Refresh" button in your browser or use the keyboard shortcut F5. This step ensures that you have the latest version of the page loaded, which will be necessary for finding the owner's information. Step 3: Access the Response Page Look for a network request with a URL: "responsepagestartup.ashx" in the developer tools...

Resolving Black Screen on Screen Recording

When you do a screen recording, encountering a black screen while attempting to capture the video can be frustrating. Apparently, there is a quick solution to resolve this issue. By turning off the hardware acceleration setting in Google Chrome, you can overcome the black screen hurdle and streamline your screen recording.  Step-by-Step Guide: Accessing the Chrome Menu: Open your Google Chrome browser and locate the three vertical dots positioned at the top-right corner of the window. Click on these dots to access the Chrome menu, which will provide you with various options. Navigating to Settings: In the Chrome menu, scroll down and locate the "Settings" option. Clicking on it will open a new tab dedicated to Chrome's settings, presenting you with an array of configuration choices. Exploring Advanced Settings: To unveil additional options, scroll down to the bottom of the settings page and click on the "Advanced" link. This will expand the advanced settings sec...

How to Delete Table with Join Statement

Similar to my previous post on how to update with multiple join statements , this time, I need to delete rows in a table, but with extra criteria which made me need to join the table before deleting the rows. To do this, there are several ways, however, I found this method is the easiest: DELETE A FROM TABLE1 A LEFT JOIN TABLE2 B ON A.ROWID = B.ROWID WHERE A.first_name = 'James' AND B.last_name = 'Bond'

How to UPDATE multiple tables in Microsoft SQL using JOIN query

Sometimes the update query needs to target a complex query and therefore you will need to use this. SQL Syntax: UPDATE      t1 SET      t1.field = value    FROM      t1     [INNER | LEFT] JOIN t2 ON join_predicate    .. WHERE      where_predicate; And MySQL Syntax: UPDATE t1 [INNER | LEFT JOIN] JOIN t2 ON join_predicate SET T1.field = value WHERE condition

Sunrose USB Fingerprint Reader Driver

Image
Also known as the ELAN Smart-id Fingerprint. Steps to resolve: Download the driver  (Tested on Windows 10) Extract the Zip file Go to device management, find ELAN Fingerprint, right-click and select update driver Locate the driver inside the extracted files Let me know in the comment below if you still have any issue(s)

How to get size of each table using SQL Management Studio

Image
Sometimes your DB storage bloated so much, without knowing what caused it. Fortunately, there is an easy way to check using SQL Management Studio (SMSS). In this scenario, I am using SQL Management Studio 18. Open SQL Management Studio and connect to your DB Click View -> Object Explorer (F7) -> Databases From the list of databases, navigate to the DB you want to investigate Right-click on the header of the table list, choose Data Space Used (KB) Click on the Data Space header to sort based on the biggest to lowest data usage. Not surprising, usually the culprit is the log that does not have an auto-delete function.