How To’s

  • Kodi No Limit not Working

    Kodi no limits can stop working due to an outdated Kodi application, network restrictions or corrupted installations. This is a very common problem which occurs usually after the first install of the No Limits build. This problem isn’t restricted to specific version of Kodi as well. Kodi No Limits is…

  • Moving VMs from one location to another using Hyper-V 2019

    You have probably realized that we really love to write about Hyper-V and virtual machines. But if you haven’t realized that fact, then you have missed all previous articles where we talked about Hyper-V, initial configuration and virtual machines. In order to be up-to-date, please check the articles below: Part…

  • Exporting and Importing Virtual Machines in Hyper-V 2019

    Back in August 2019, we wrote four articles that explain the procedure of installing Hyper-V 2019, configuring and deploying the virtual machine. If you have missed these articles, you can read them on the links below: Part 1: How to install Hyper-V 2019 Server Core? Part 2: Hyper-V 2019 Core…

  • Find your Router’s IP Address from any Device

    Every WiFi router has its very own private IP address, and you might wonder what exactly is it that makes your WiFi router’s IP address at all important. Well, on all small-scale networks (such as those commonly found in homes and small businesses) that only consist of a WiFi router…

  • Getting Err 99 on Canon? Follow these steps

    The “Error 99” ‘Shooting is not possible’ is shown on the Canon Camera’s LED while trying to take a picture and it usually indicates an issue with the camera’s shutter. This can be due to blockage in its path or it might be because the shutter is misplaced from its…

  • Comcast Remote not Working? Try these solutions

    This Error is triggered while trying to use the remote with the Comcast device and it is mostly an indicator of an issue with the remote configuration or it might also be a sign of weak batteries. It is also possible that the remote might be glitched. What Prevents the…

  • How to Archive Files Using TAR on Linux

    An archive is a special kind of file that can store a myriad of folders and files within it. What makes archives so effective is that the files and folders they contain retain the file-structure they had outside the archive, and this structure remains intact when an archive is un-archived. You…

  • Troubleshooting Complete Signal Loss Error on DISH

    This “Signal Loss” message is seen on the Dish Network and it is caused due to an issue with the cable connections or it might be due to water damage to the lines. It can also be caused due to an issue with the service provider and prevent the signal…

  • Using Android phone as a PC GamePad or Steering Wheel

    Certain PC games are just better with a gamepad, such as fighting games and platformers, and playing racing games with a keyboard is simply abysmal. Maybe you travel a lot with your gaming laptop, and a gamepad just takes up extra space in your bag – let alone an entire…

  • Creating Clustered and Non-Clustered Indexes in SQL Server

    In a SQL Server, two types of indexes exist; Clustered and non-clustered indexes. Both clustered indexes and non-clustered indexes have the same physical structure. Moreover, both of them are stored in SQL Server as a B-Tree structure. Clustered index: A clustered list is a particular type of index that rearranges…

  • Fix Python Socket Error 48

    Socket Error 48 is a python error which is triggered when the process tries to bind itself to a port that is already in use. What Causes the “socket.error: [Errno 48] Address already in use” Error? After brief research, we found the causes to be: Solution 1: Specifying Port Number…

  • Fix the ‘Internet May not be Available’ Error on Android Devices

    The “Internet May Not be Available” error on Android is shown whenever the user connects to the internet and this is usually caused due to an error with the network configurations which the mobile is using to connect to the internet. It might also be caused due to incorrect DNS…

  • Fixes for Spectrum WiFi not Working

    Spectrum Wifi can often stop working if the service is experiencing issues with establishing a secure connection with the background servers. This issue is likely triggered after a power outage or due to a maintenance breakdown at Spectrums’ end. What Prevents the Wifi from Working on Spectrum? After investigating, we…

  • Vizio TV Not Connecting to WiFi

    Vizio TV not connecting to Wifi is probably a result of mismanaged network configurations or due to the build-up of corrupt launch configurations. It can also be triggered due to certain settings being disabled and if the IP address of the router hasn’t been configured properly. What Prevents the Vizio…

  • Ares Wizard not Working in Kodi? Quick Fixes

    Ares Wizard fails to work in Kodi because of outdated software, corrupt Ares installations, or due to the fact that some of its releases got banned from Kodi itself. Ares Wizard is an add-on tool which is used in Kodi. It features an all-in-one solution for Kodi users where they…

  • How to Setup Database Mail in SQL Server using Gmail?

    With SQL Server 2005 many things have been changed. In earlier versions in order to make it work, SQL Mail relied on having a MAPI mail client installed like Outlook. This has changed with SQL Server 2005 and later, and now the mail services are using an SMTP server to…

  • How to Remove Duplicate Rows from a SQL Server Table?

    When designing objects in SQL Server, we must follow certain best practices. For example, a table should have primary keys, identity columns, clustered and unclustered indexes, data integrity and performance constraints. SQL Server table should not contain duplicate rows according to best practices in database design. Sometimes, however, we need…

  • How To Use DROP IF EXISTS in SQL Server?

    This article discusses the “DROP IF EXISTS” statement available in SQL Server 2016 and later versions.  “IF EXITS” is the latest optional clause added in the existing DROP statement in SQL Server 2016 and later versions. Essentially, the “DROP IF EXISTS” option is used when it is necessary to check…

  • How to Create Aliases and Shell Functions on Linux?

    Knowing the command prompts & shell scripts is still necessary if you want to get the most out of the GNU/Linux system & the more one operates at the command line, the more one will find that the majority of the commands being used are a very small subset of the…

  • How to Rename a SQL Server database?

    Sometimes we need to change database name because the original name was based on the project that has become irrelevant to the data stored into the database or you had given temporarily name before and now you want to modify it. Irrespective of the reasons behind renaming the database, in…

  • How to Fix the Error ‘Cannot insert explicit value for identity column in table when IDENTITY_INSERT is set to OFF’?

    The primary key column is often set to auto-increment when constructing a SQL Server database. The IDENTITY limit is set on for the primary key column to do this. The starting location and step of increment are transferred to the IDENTITY column as parameters. Then whenever a new record is…

  • How to Fix ‘Error 97: SMS Origination Denied’ Error on Android?

    Android is one of the most popular operating systems for mobile phones and is used by more than a billion people. It is mostly popular due to its vast customizability options and fast speeds. SMS is a feature used by almost everyone and it allows you to send text messages…

  • How to Fix ‘Error Checking for Updates’ Error on Google Play Store?

    Google Play Store is one of the main applications that come pre-installed with almost all mobile phones that are running Android. It contains thousands of applications that the users can download and install on their mobiles. The app is also responsible for keeping all the applications on the mobile up…

  • How to Fix the ‘One Moment Please with REF Code S0A00’ Error on Comcast?

    Comcast is one of the most popular cable service providers in the world. It is the largest pay-TV service provider and also one of the most used ISP in the USA. It provides many telecommunication services and is headquartered in Philadelphia. Xfinity is also their subsidiary and is quite popular…

  • How to Fix ‘Error 11: GPS signal not found’ on Pokemon GO?

    Pokemon Go is one of the most famous Augmented Reality Games out there due to its worldwide availability and unique mesmerization of the Pokemon Anime which contains numerous Pokemons from the original manga and has the same feel. It is available almost worldwide and requires an active internet connection and…