Page 199

How to Set Up the Pin It Button for Chrome

Pinterest is a favorite website for users who enjoy organizing ideas, recipes, vacation spots, articles, and more. The basic idea is that you pin a website represented by an image from the webpage to a board dedicated to that topic. You then get a visual feed of all the items you have pinned so that you can refer back to them later.

If you are a frequent Pinterest user, I highly recommend downloading a web extension to let you pin items to your boards from anywhere without having to open Pinterest in your browser. These extensions are available in most browsers, including Firefox, Internet Explorer, Safari, Microsoft Edge, and Chrome. This tutorial will walk you through how to set up the Pin It Button for Chrome.

Continue

How to Open Pages Automatically in Chrome

Ashley Blood

Do you open the same set of tabs every time you go online? Perhaps you always check Facebook, Gmail, and your calendar whenever you are on your computer. You can set up Google Chrome so that it automatically opens those three sites on startup whenever you launch Chrome, completely skipping over the New Tab page. This handy trick can save you a considerable amount of clicking around and let you get down to work faster.

Continue

How to Create a Snapchat Story

Apps

Ashley Blood

Snapchat is a popular social media site that lets you send pictures or short videos with captions or drawings on them (Snaps) to your friends. Snaps disappear from the app after they are viewed. A Snapchat Story is Snapchat’s equivalent of a post or status like those on other social media sites. Multiple Snaps are strung together, and they can be viewed as many times as people want for 24 hours, at which time they disappear.

Even though Snaps disappear from the app, remember that people that view them can always take screenshots. Remember always to use social media wisely, and not to send incriminating Snaps. Do not count on your Snaps disappearing into the void. Here’s how to create your own Snapchat Story.

Continue

Find an Object’s Creation and Modification Dates in SQL Server

Vishwanath Dalvi

SQL Server is an all-in-one IDE for managing multiple user instances, SQL programming, and changing settings using graphical options. Often, we need to find out when a stored procedure/trigger was last modified, or we need to find the creation date of existing objects in SQL server.

Finding the creation dates and the modification dates of stored procedures, table triggers, or views and other objects in SQL server using meta data tables is quite easy.

We can query SQL Server’s meta data tables which store information about an object’s creation and modification. Some of the frequently used meta data tables are sys.objects and sys.procedures.

Continue

How Do I Enable VoiceOver on iPhone?

Apple iPhone

Leomar Umpad

iPhone has a gesture-based accessibility feature that helps you identify the current screen you are on and the buttons or icons you are pressing, even if you cannot see the screen. When you enable VoiceOver on iPhone, your phone will speak the name of the current button or icon that you are pressing and describe everything that is happening on your screen. You can adjust the speech rate and pitch, enable spoken hints, and add sound effects. This feature is helpful for those who are visually impaired and may also come in handy if you have left your eyeglasses at home or have broken them. If you or someone you know needs to know how to enable VoiceOver on iPhone, then this article will guide you through the process step-by-step.

Continue

How to Make your Excel Table Print on One Page

Microsoft Excel

Ashley Blood

How to Make your Excel Table Print on One Page

You have worked hard building your table in Excel. You print your spreadsheet and are disappointed to find that your table was too wide and a few columns were printed on a second page. Fortunately, there are several tricks you can use to get your Excel table to print on one page. Check them out here, and pick the ones that work best for you. You might need to use a combination of methods depending on your table’s size.

Continue

How to Use Snapchat Filters

Apps

Ashley Blood

Snapchat is a popular social media site that lets you send pictures or short videos with captions or drawings on them (Snaps) to your friends. One of Snapchat’s most entertaining features is the ability to apply interactive filters to your selfies. The filters change over time. Some examples of Snapchat filters are dog tongues lolling out when you open your mouth (see image below), sunglasses and explosions when you raise your eyebrows, big eyes popping from your face, puking rainbows, etc. Once you have added your filters, you can send these Snaps to your friends, add them to your story, or just have fun watching your face with gigantic eyes. Use the steps in this tutorial to add Snapchat filters to your photos and videos to customize your Snaps.

Continue

Create a Folder Using CMD in Windows

Leomar Umpad

Not many Windows users are familiar with CMD. The common misconception is that only programmers and computer geeks use CMD. Basically, CMD is a tool that you can use to communicate with your Windows computer. Though the user interface and other input methods are introduced, CMD is one tool that you cannot take for granted. Some commands, such as creating folders, are easier to execute using CMD. You may laugh and think that it is harder to create a folder using CMD instead of using your mouse and the “Right click > New folder” method. You may have a point, but what if you are asked to create 10 folders or more? CMD would greatly simplify the task. Creating a folder using CMD is easy. This article will show you how.

Continue

How to Freeze Rows AND Columns in Excel

Microsoft Excel

Ashley Blood

Working with a large set of data in Microsoft Excel can be tricky. It is particularly aggravating when several columns or rows of data are similar, so you have to keep jumping back to the header to remember what you are viewing. A good solution to this is to freeze columns, rows, or both so that they stay displayed on your screen while you scroll through the rest of your data. Here’s how to do it.

Continue

How Do I Transfer Images to the Samsung Gear S2?

Smartwatch

Leomar Umpad

How Do I Transfer Images to the Samsung Gear S2?

You can transfer images to the Samsung Gear S2 from any Android device as long as you have the right application on your phone. Once transferred, these images can be accessed from the Gear S2 without the need of a paired phone. The transfer will proceed regardless of the Gear S2’s remaining free space. Should you transfer more images than your smartwatch can handle, then your Gear S2’s system will delete photos that are not your favorites in chronological order, starting from the oldest saved image. This article describes two ways of transferring images: manually and through automatic syncing.

Continue

How Do I Enable Power Saving Mode on Samsung Gear S2

Smartwatch

Leomar Umpad

How Do I Enable Power Saving Mode on Samsung Gear S2

You can extend the battery life of your Gear S2 by minimizing the power usage of the smart watch. You can enable the power saving feature on Samsung Gear S2 to fine-tune your phone for longer usage. Using your Gear S2 in power saving will switch the watch’s display into grey tones, limit the performance of the watch’s CPU to save on processing power, disable Wi-Fi connection, and deactivate all other options except for mobile communication such as calls, messages and the notification feature. This article will guide you through the steps to activate power saving mode on Samsung Gear S2.

Continue

SQL Server Three-Valued Logic and NOT IN clause with NULL values

Vishwanath Dalvi

While querying the production server to solve one critical issue, suddenly one query completely caught my attention. We had written a query which was created to find records which exist in Table A but do not exist in Table B, based on a certain column. The query was syntactically correct and ran without any errors, but it did not return any results. There were some records which we were hoping to get in the results, so we investigated the reason why the correct query did not return any.

The NOT IN clause returns rows from the outer table which do not exist in the inner table used in the subquery. In this tutorial, we will examine using the NOT IN clause with null values.

Continue