A Beginner’s Guide to Sequence Objects in SQL Server
SQL Server has supported SEQUENCE objects since the inception of SQL Server 2012 and later editions. Oracle database has supported SEQUENCE objects from the beginning. You can read the archive post on Tech-Recipes using SEQUENCE in Oracle.
How to Save Instagram Photos and Videos Privately
With more than 600 million users, Instagram has a large, fast-growing community. Besides personal photos, Instagram users also share shots of products or videos that you may find useful for future reference. In the past, whenever you came across Instagram posts that you wanted to save, you could either like them or save them to another app. The first solution is not ideal for privacy as your likes are visible to your followers while the latter is time-consuming and inconvenient. Fortunately, Instagram has noticed this problem and provided a feature for users to save Instagram posts privately to their accounts with just a tap. Continue reading to find out how to use this feature.
How to Restrict Specific Apps from Using Cellular Data on iPhone
By default, any application can access an iPhone’s cellular data. If you want to browse the internet using a browser app (e.g., Safari) on your iPhone, you would only need to turn on either your Wi-Fi or your cellular data. It is that simple. You just need to have an internet connection, and any app can access the internet, using either a Wi-Fi connection or your cellular data. Depending on the type and the purpose of the apps on your iPhone, some apps are able to run in the background, continually using the internet connection of your device. For those who use cellular data without unlimited data plans, this can cause higher data charges. If you want to continue using your network data and, at the same time, disable specific apps from accessing the internet through your cellular data connection, then you are on the right page. This tutorial shows how you can restrict specific apps from using cellular data on iPhone.
Access Your Yahoo Account Without Using a Password
For the second time this year, Yahoo has issued a notice confirming another security breach in the company’s user accounts. This security issue is different from the disclosed data theft incident which occurred last September 22, 2016. To ensure that your account is safe, you can follow the steps in this tutorial to keep your Yahoo account secure. You can also set up a Yahoo Account Key to do away with passwords completely. This tutorial explains how to access your Yahoo account without using a password.
How to Prevent Public Comments on Facebook Posts
By default, the posts you make public on Facebook can be viewed and commented on by anyone, including people who are not your friends. At times, this policy can become a problem as your profile picture and cover photo are always public, so these are good spots for abusive comments. If you are facing such a situation, you can follow the steps in this tutorial to keep people who do not have connections with you from commenting on your posts.
How to Filter Facebook Search Results on a Smartphone
When you search for someone on Facebook, the results page often includes a list of people who have the same name as the person you are trying to find. Normally, Facebook moves people with whom you have mutual friends or who live near your current location to the top of the list. This could make finding the right person harder if you do not have any connections to him or her. Luckily, it is possible to narrow the results by providing more information such as location or education when you search someone on Facebook. Continue reading to find out how.
Microsoft SQL Server: Estimated vs. Actual Execution Plans
Let’s assume you are constructing a new house, and you have a contract with a builder. After thoughtful examination of the area, height, and materials needed, he estimates it will take 120 days to build a new home. After constructing the home, it actually took 200 days to built it.
There is a difference between his estimation and the actual result. This applies to query execution plans in SQL server as well, specifically Estimated vs. Actual execution plans.
This tutorial contains an Estimated execution plan as well as an Actual execution plan in SQL Server.
How to Turn LG G5 into a Universal Remote Using QuickRemote
LG’s G5 can be used as a universal remote for most of your electronic devices that require a remote control. By simply following a few simple steps, you can convert your LG G5 into a universal remote controller for your TV, multimedia players, sound systems, air conditioner, and other electronic appliances. This tutorial outlines all the steps you need in order to use QuickRemote on your LG G5.
How Do I Set Screen Security on Google Pixel
Pixel, Google’s flagship phone for 2016, is a strong contender for the best phone of the year. Both Pixel and Pixel XL have enough power and features to go head-to-head with other smartphone manufacturers’ flagship devices. Aside from the the software and hardware, Google has also made sure that Pixel’s security is top-notch. This tutorial explains how you can set screen security on Google Pixel.
How to Improve Ecommerce SEO
For Ecommerce business owners, the traffic that one gets is one of the key points that translates to the success or failure of a business. Doing it right guarantees the success of the whole process. The popularity that a site attains, on the other hand, will depend on its overall ranking on the search engines. One can use both on-page as well as off-page SEO factors to obtain a better ranking, which translates to more traffic for the website.
How to Activate Night Shift Mode on iPhone
