RTC Wake Up option in BIOS Settings

The RTC Wake Up option is responsible for automatically turning on the power of the computer at a certain time and day (by "alarm clock"). Usually this feature is not used ( Disabled ). The exceptions are cases when it is necessary to periodically perform certain actions in an automatic mode - for example, to run a computer scan for viruses at night. Then this option must be enabled ( Enabled ).

Read more: RTC Wake Up option in BIOS Settings

What is Universal Windows Platform?

The UWP (Universal Windows Platform) is a unified platform for building and running apps on Windows 10 and Windows 10 Mobile.

UWP is the evolution of earlier technologies. So, with the release of Windows 8, a new architectural platform for applications was introduced - Windows Runtime (WinRT), which allowed running applications in the so-called Modern (Metro) mode on desktops and tablets. Then, with the release of Windows 8.1 and Windows Phone 8.1, this technology was developed - there were "universal applications" that could run immediately Windows 8.1 and WP8.1. And in July 2015, the new Windows 10 OS was officially released. It uses the UWP platform, which is an evolution of the Windows Runtime.

As the name of the platform suggests, it is universal - universal for all devices in the Windows 10 ecosystem. And these are ordinary destops, tablets, mobile devices, IoT (Internet of Things) devices, Xbox, Surface Hub devices. And a UWP app can work the same on all of these platforms as long as they have Windows 10 installed.

Read more: What is Universal Windows Platform?

Using Ninject in C# ASP.NET MVC5 Projects

The IoC containers are used for dependency injection. There are many IoC containers, we use Ninject, as it is easy to use and understand. You can install the required package via NuGet. The package is called Ninject.MVC5

After installing the package, we can already use Ninject in the project. For example, let's change the constructor of the controller as follows:

using Ninject;
//.....................
public class HomeController : Controller
{
    IRepository repo;
    public HomeController()
    {
        IKernel ninjectKernel = new StandardKernel();
        ninjectKernel.Bind<IRepository>().To<BookRepository>();
        repo = ninjectKernel.Get<IRepository>();
 
    }
    public ActionResult Index()
    {
        return View(repo.List());
    }
}

Read more: Using Ninject in C# ASP.NET MVC5 Projects

Basic SQL Commands Every Developer Should Know

The SQL or Structured Query Language (structured query language) is used to manage data in a relational database system (RDBMS). In this article, you will learn about frequently used SQL commands that every developer should know. This material is ideal for those who want to refresh their knowledge of SQL before a job interview. We will be using MySQL or MariaDB syntax in this article. But most of the commands are patform-independent and will work on SQL Server, PostgreSQL, SQLite, OracleDB and others. 

Read more: Basic SQL Commands Every Developer Should Know

How to fix PHP upload file inherit permissions error using Windows IIS Server

If you’re like me, and you use Windows IIS, you’ve spent hours trying to figure out why your uploaded file won’t inherit the permissions needed to display correctly. Luckily, the answer is extremely easy and something most people would have never thought of.

The problem only happens when you use PHP to upload a file. When you upload a file, PHP sends the file to a temporary directory on the hard drive (for me it is C:\Windows\Temp) and then copies it over to it’s intended directory. Once the file has landed in the temporary directory, it is assigned the permissions of that directory. The problem is when Windows copies that file, it keeps the temporary directory’s permissions and doesn’t inherit your web directory’s permissions.

Read more: How to fix PHP upload file inherit permissions error using Windows IIS Server

How to unpack .tar.gz archive in Linux

.tar.gz archives are widely used in a GNU/Linux world because of love of the community to the patent freedom and open source formats. Usually, Linux distributions utilize tar.gz format for source code compression. When you begin familiarizing yourself with the Linux world, you quickly realize you need to know how to extract .tar.gz files in Linux. Actually, tar.gz archives are a a combination of two technologies chained one after another. First, all the files are merged in what is called a Tarball - just a single file plus file names information. Then, the Tarball is compressed with the use of gzip compression algorithm. 

So, how to actually extract the .tar.gz archive?

tar -xvf www1.tar.gz -C /var/www/website/

The above command will eventually extract the file www1.tar.gz residing in current directory to the folder /var/www/website/

Let's look at the details of this command:

x command means we want to extract the archive

v switch tells tar to verbosely output file names

f means we need to specify archive name (othewise tar will look into standard input)

As a bonus, you can extract .tar files or even .tar.bz2 files using the same command! Just specify the correct archive name and extension.

Now, you have mastered extracting tar.gz files. Good luck!

How to import large .sql file in MS SQL Server

Sometimes you need to import large database into MS SQL Server, but when you use Microsoft SQL Server Management Studio, it doesn't do the job right, but shows the message "Insufficient memory". Or maybe you need to do a batch import of sql script to database instead of doing the import by hand. Here comes in handy the sqlcmd command line tool. It can import large .sql files, can be run from a batch script, installer, etc.

How to use sqlcmd command-line tool to import large .sql file?

Open a command prompt window.
In the Command Prompt window, type: sqlcmd -S yourServer\instanceName -i C:\yourScript.sql
Press ENTER.
The progress of operation is written to the command prompt window.

Source: Microsoft

How to Install APK to Android Device via ADB in 6 simple steps

1. Download and install android platform tools: https://developer.android.com/studio/releases/platform-tools.html

2. Open command line and navigate to the folder where ADB is located, eg. cd /D d:\Android\sdk\platform-tools\

3. Type adb devices and press ENTER.

Read more: How to Install APK to Android Device via ADB in 6 simple steps

How To Upload Directory Tree To Remote FTP Server Recursively in Linux

When you host your web site remotely and the ftp server is the only way to upload all files including subdirectroies. You need to use special file transfer program such as ncftpget or ncftpput for recursive remote ftp server uploading and downloading purpose. Ncftp is considered as an improved FTP client. Ncftp's improvements include support for command line editing, command histories, recursive gets/puts, automatic anonymous logins, and much more.

1. Install ncftp client

Type the following command under Debian/Ubuntu Linux to install ncftp client:
$ sudo apt-get install ncftp

Read more: How To Upload Directory Tree To Remote FTP Server Recursively in Linux

Android WebView transparent background for Android 2.3 and up

Many people face an issue with Android's WebView and transparent background. The problem is that if you need to make transparent background for the WebView, it is not easy to do at the first sight. If you try to use property android:background="@android:color/transparent", you will discover that it just don't work as expected. The background is still opaque. Using background color set explicitly as #ff000000 constant sometimes work and sometimes not. 

Read more: Android WebView transparent background for Android 2.3 and up