wideitzone

How To Determine And Set Primary Graphics Card On Windows Computer

2018-03-11T05:11:00.000-07:00

Currently, a lot of laptops and desktop computers on the market have a dedicated graphics card. Although the computer processor itself has a graphics card inside it in the form of a chip known as an integrated graphics card, its graphics processing capability is limited. A dedicated graphics card is usually added to the laptops or the desktop computers with the medium or the high specification to run apps that require the higher graphics processing.

There are quite a few graphics card manufacturers, some of which are Nvidia, AMD, and Asus. The graphics card for the desktop computers has a large physical shape that can be installed in and removed from the mainboard expansion slot with ease, while the graphics card for the laptops is mounted and fused on the mainboard, making it difficult to remove or replace. When you buy a branded laptop or desktop computer, there is usually a small sticker on the case to identify whether the laptop or desktop computer has a dedicated graphics card or not.

If your laptop or desktop computer has two graphics cards, an integrated and a dedicated graphics card, Microsoft Windows by default will use an integrated graphics card. When you operate an application that requires the higher graphics processing like a game or a video processing app, you need to switch using the dedicated graphics card. You will not get the best performance when the higher graphics processing is handled by the integrated graphics card.

Each graphics card installed on the computer has a control panel that is used to change settings. Through the control panel, you can specify the primary graphics card used for graphics processing. In Microsoft Windows, the lighter graphics processing automatically uses the integrated graphics card, such as Intel HD Graphics for Intel processor, while for the 3D graphics processing or the certain applications that require the higher graphics processing, you can specify the dedicated one manually.

The example in this article uses Acer Aspire laptop which has two graphics cards that is Intel HD Graphics (the integrated graphics card) and NVIDIA GeForce 820M (the dedicated one). To determine and set the primary graphics card on the Windows 10 computer, here are the steps:

In the empty area of the desktop, right-click the mouse to display the shortcut menus and then select NVIDIA Control Panel.

In the NVIDIA Control Panel window that appears, click Manage 3D settings (1), select the Global Settings tab (2), from the drop-down list box, select High-performance NVIDIA processor (3), and then click the Apply button (4).

If you want to set the dedicated graphics cards for a particular application, click the Program Settings tab (1), select the application or program to be set to use the dedicated graphics card (2), and then select High-performance NVIDIA processor (3). You can repeat this step for another application. If the app you want is not on the list, you can uncheck the checkbox labeled Show only programs found on this computer or use the Add button to add it.

How To Change Default Text Editor In WampServer

2018-03-08T06:06:00.001-08:00

Most people prefer to create and develop a website for the first time on a local server on a personal computer rather than directly on a web hosting server. At the beginning of its creation and development, the website is not yet fully ready to go online. The website still needs to be given the touches, needs to be tested, and then filled with the contents. As with the hosting that has the web server, creating and developing the website on the personal computer also requires a web development environment known as a local web server.

To create a local web server on your personal computer, you can use the web solution packages. There are many choices of the web solution packages and one of them is WampServer. WampServer is specific to Windows computers. If you install WampServer on your Windows computer, you already have software components consisting of Apache web server, PHP, MySQL, MariaDB, and phpMyAdmin. With this package installed and configured on your computer, you are ready to create the website based on PHP programming language.

When you are installing WampServer on your Windows computer, there is a process in which you are prompted to specify the default text editor for WampServer. If you do not specify any text editor, WampServer will use Notepad text editor (notepad.exe) as a default text editor. The default text editor will be used by WampServer to open the text files (.txt).

Sometimes, reading the text files in Notepad text editor is difficult. Notepad tends to display all the texts in one line, not per line. That is a reason why many WampServer users select to use another editor, such as Notepad++ or Adobe Dreamweaver. Even if you have finished installing WampServer on your computer, you can still change Notepad text editor with another editor, for example, Notepad++ text editor. If you want to change the default text editor of WampServer, here are the steps:

Open File Explorer, navigate to C:\wamp64 path (1), right-click the mouse right on the wampmanager.conf file (2) to show menus and then select Edit with Notepad++ for easy file editing (3).

In line 13 of the file opened, you can see the path of Notepad text editor (notepad.exe) which is the default text editor of WampServer. To change the default text editor with another text editor, you need to replace the path with the path of the desired text editor, for example, the path of Notepad++ text editor.

To get the path of Notepad++ text editor, open File Explorer, select Notepad++ folder (1) and then find the notepad++.exe file (2). Next, by pressing the Shift key, right-click the mouse right on the notepad++.exe file to show menus and then select Copy as path (3).

In the wampmanager.conf file opened, replace the path of Notepad text editor with the path of Notepad++ text editor (1) and then save the file (2).

To get the result, first, exit from WampServer and then rerun it. Now, every time you open the text file in WampServer, Notepad++ text editor is run.

How To Rename An htaccess.txt File To A .htaccess File In cPanel

2018-03-04T04:31:00.000-08:00

Content Management System (CMS) is a popular web application used to create and manage the digital content. There are many CMSs out there you can select to use such as Joomla, Wordpress, Drupal, Magento, and so forth. Amongst Many CMSs, Joomla can be your choice to create many types of websites like portals, personal website, small business website, e-commerce, corporate website and other web applications.

When you install Joomla CMS, you have a file called htaccess.txt in the root directory such as public_html (Linux hosting), www, or httpdocs. According to Joomla documentation, for the sake of Joomla SEO, you should rename an htaccess.txt file to a .htaccess file. Depending on whether your Joomla files are still on the local web server on your computer or you have moved to web hosting server, you can use some ways to rename it.

You can use Windows Command Prompt to rename it if your Joomla is still on the local web server. If it is on the web hosting server, you can use the Rename button of the cPanel feature. All you need to know is that, in the Apache web server, the files that are preceded by a dot (.) are the hidden files. After renaming you don't find your .htaccess file, you need to activate Show hidden files (dotfiles) feature in cPanel to show it.

Here are the steps to rename the htaccess.txt file to the .htaccess file in cPanel:

Log in to your cPanel account, in the FILES group, click Files Manager. Make sure you have selected public_html folder (1), select a htaccess.txt file (2), and then click the Rename button (3).

In the Rename dialog box that pops up, in the New file name text box, rename htaccess.txt to .htaccess (1) and then click the Rename File button (2) to save the changes.

Now you can see that the name of the htaccess.txt file has changed to the .htaccess file.

How To Change Default Server Timezone Via Htaccess File

2018-03-02T08:48:00.000-08:00

If you create a website using a CMS like Joomla, you will have a file named htaccess.txt in the installation result. In the web hosting server, .htaccess.txt is in the root directory of your primary domain that is public_html where the Joomla files and folders are in it. According to the Joomla documentation, for the sake of the Joomla SEO, you need to convert htaccess.txt to .htaccess. Many people will think that .htaccess is one of the file extensions because it uses a dot (.) at the beginning but .htaccess is indeed the name of a file.

In the web servers that run the Apache web server software, .htaccess is a configuration file. .htaccess can be used to change the Apache Web Server configuration such as enabling or disabling its features and functionality. In the Apache document root, this file will be detected and executed by Apache web server software. By default, the file names started with a dot (.) in Apache web server are hidden files. To show these files, you need to enable the Show Hidden Files feature in cPanel.

.htaccess has many functions such as redirecting URL, denying visitor by IP address or referrer, password protection, preventing access to the php.ini file, and so forth. In addition to these functions, another function of .htaccess is to set server timezone, and this article is about it. The server has specific timing and follows its physical location. If the server location is overseas, for example, in Singapore, the server time will use Asia/Singapore time. If the website uses a server in Singapore while it is intended for visitors in America, the time shown on the website becomes inaccurate.

To solve this issue, you can use .htaccess to change the default time zone and then show the time from the local time zone. If you do not have .htaccess, you can create it using a text editor like Notepad. In addition to .htaccess, changing the server time zone can also be done via the php.ini file. But for shared hosting, access to php.ini is restricted. If you want to change the default timezone of the server via .htaccess, here are the steps:

Log in first to your cPanel account, in the Files group, click or choose File Manager. On the File Manager page, make sure you are in the root directory by clicking the public_html directory (1), select the .htaccess file (2), and then clicking the Edit button (3).

In the Edit dialog box that pops up, click the Edit button. .htaccess is open in the editor. Now it is the time for you to specify the local time zone you want to use. If you are unsure of the name or timezone format, you can check it here. This example will use America time zone.

After you select the Asian time zone, you then select another more specific Asia time zone, such as Asia / Jakarta timezone.

To change the default server time zone with the local time zone, add the code below at the top line of the .htaccess file, click the Save button to save the changes, and then click Close button closes the currently active page.

# Change the default time zone

SetEnv TZ America/Los_Angeles

What Is User Account Control (UAC) And How To Disable It

2018-03-01T09:23:00.002-08:00

If you are a Windows user, have you ever install an application in Windows that triggers User Account Control (UAC) dialog box? If yes, it means that UAC helps you make sure whether you will continue with the installation of the application or not. UAC is a security feature of Microsoft Windows first introduced in Windows Vista. Now, UAC always becomes a part of Microsoft Windows security system after Windows Vista. UAC continues to get the improvement to make it better than ever.

Microsoft Windows shows UAC dialog box when its system-related parts change. It is why installing a specific application show the UAC dialog box. It is because the application can change Microsoft Windows file system, registry, or other Windows system-related parts. However, the application is not the only one that can trigger the UAC dialog box to pop up, virus and malware can trigger too. When the UAC dialog box pops up, you that run Administrator account need to decide whether you let the application make changes to Windows system or not.

UAC is indeed an important feature to secure your Windows operating system. Although UAC can prevent Windows from being more at risk, many Windows users are not happy to see the UAC dialog box pop up. Now Windows give you an easy way to control how much security level of UAC you want to implement by dragging the slider. Many Windows user prefer to disable the feature by dragging the slider all the way down to the Never notify label. If you are one of them, here is how to disable UAC in Microsoft Windows 10:

In Windows 10, click the Type here to search button (1) located on the left side of the Windows taskbar and then type uac into the search box (2). From the result of searching, select or click Change User Account Control settings (3).

In the User Account Control settings window that pops up, drag the slider all the way down to the Never notify label (1) and then click the OK button (2).

How To View Saved Passwords In Google Chrome On Microsoft Windows

2018-02-28T17:00:00.000-08:00

Google Chrome is a browser owned by Google that combines a minimal design and sophisticated technology to make it easier to use, faster, and more secure. Until now, Chrome still becomes the browser with the most users, outperforming some other browsers like Microsoft Internet Explorer, Mozilla Firefox, or Safari. For most Windows users, although Windows has its default browser that is Microsoft Edge, Google Chrome remains their favorite browser.

Google Chrome has a helpful feature that can store your login password when you visit a website. Firstly, Google Chrome will ask you whether you want to save your login passwords into Chrome or not. If you select to save, whenever you revisit the website, you no longer need to type in your username and password for login. This feature will automatically fill in your username and password and then direct you to the website.

This feature will be useful and safe to use if only you who use the computer. If any other person also uses the computer, your privacy and account data are at risk. If the Windows computer is not password protected, anyone can view your account passwords saved by Google Chrome without the need to enter Windows local password or Microsoft account. If you want to see passwords stored in Google Chrome, here are the steps:

Open your Chrome browser, type chrome://settings/passwords in the address bar of the browser and then hit the Enter key.

In the Settings - Manage Passwords page that appears, you can see a list of your accounts with the passwords hidden by asterisk marks. To view one of the account passwords, click the Show password button on the right (1). In the Windows Security dialog box that appears, type your username and password (2) you use to log in to Windows system (local account). You can also click More choices (3) if you want to switch using Microsoft account.

If you use Microsoft account, click your Microsoft account (1), type its password (2) and then click the OK button (3).

Now, you can see the password for the account. To view the other passwords, just click the Show password button.

2 Ways To Find Saved WiFi Passwords In Microsoft Windows

2018-02-27T06:10:00.002-08:00

You may ever forget your own home WiFi password even though your laptop is connecting to the WiFi. As a human being, it is only natural. However, if you know the way to find WiFi passwords stored on a Windows computer, it does not matter. If you forget your password whenever it is, you can find out it again. Sometimes, knowing how to find the WiFi passwords stored on Windows is important.

For example, when you buy a new device like a tablet or a smartphone and then connect it to your home WiFi or when your friends come to your home and need to connect their smartphone to your home WiFi, you need your home WiFi password. Windows 10 gives you ways to find the password of the WiFi currently used or the password of the WiFi profiles stored. Here is how to do on Windows computer:

Through Network and Sharing Center.

Click the Cortana icon located on the left of the taskbar, type network and sharing center in the Cortana search box, and from the search results, then select Network and Sharing Center. In the Network and Sharing Center window that appears, click the WiFi network icon currently used.

In the WiFi Status windows that appears, click Wireless Properties.

Make sure you are on the Security tab (1), then check the box labeled Show characters (2). Now, you can see your home WiFi password (3).

Through Command Prompt.

Use Windows + R key combination to open Run dialog box. Type cmd in the text box and then press the Enter key. In the Command Prompt window that appears, type netsh wlan show profiles command (1) and then press the Enter key. You can sell all the WiFi profiles stored on your computer (2).

Next, type netsh wlan show profiles name="wifi-profile" key=clear command (1), change wifi-profile with the WiFi profile you want to find its password and then press the Enter key. Now, you can see the password for the selected WiFi (2).

How To Check PHP Version Via Joomla Admin Panel

2018-02-26T04:25:00.002-08:00

Joomla is a content management system used to create, manage, and publish digital contents. Joomla is based on PHP programming language and supports some databases like MySQL, Microsoft SQL Server, and PostgreSQL. The release of a new version of Joomla often requires a minimum version of PHP to use. In Joomla 3, you can still use PHP 5.3 for the minimum version of PHP, but it is best to use recommended one such as PHP 5.6 or PHP 7.x.

The development of Joomla closely relates to the development of PHP. Joomla will take advantage of the new features of the current version of PHP. Joomla 4, the next version of Joomla, raise the minimum version of PHP to PHP 7. You can no longer install Joomla 4 if you use the PHP version before PHP 7. PHP 7 brings much-improved functionalities. One of them is the significant increase in the execution speed. This improvement gives a good impact on Joomla that uses PHP 7.

Most Joomla owners upload their website directly to the hosting server. They rarely check the current version of PHP at the hosting server. They assume as long as the Joomla website is running, it is considered enough. They do not realize that the use of PHP version gives the impact to the Joomla performance. The version of PHP your Joomla uses is easy to check. Besides via cPanel of your hosting, you can check it via the Joomla admin panel.

The PHP version displayed in the Joomla admin panel is the same as the PHP version of your hosting. Of course, this way provides convenience. When you are in the Joomla admin panel, you can check at once the version of PHP used thus you do not need to access cPanel anymore. Here is how to check the Joomla version via the Joomla admin panel:

Log in to your Joomla admin panel, click System menu (1) and then select System Information (2).

In the System Information page, make sure you are in the System Information tab (1). Now, you can see the current version of PHP used by your Joomla website (2).

The Importance Of Keeping The Joomla Version Up-To-Date

2018-02-25T08:45:00.001-08:00

Joomla is an open source Content Management System (CMS). Like other CMS, Joomla is used to create, manage, and publish the digital content. You can download, use, and further develop it freely. The programming language used to create and develop Joomla is PHP. To use Joomla, you also need to use one of some supported databases such as MySQL, Microsoft SQL Server, or PostgreSQL.

In addition to Joomla, there are many CMSs out there that are also open sources like Drupal, WordPress, and Magento. Joomla itself is easy to use. You do not have to master the software like PHP, HTML, CSS, JavaScript, Bootstrap, or its supported databases to create the websites or the web apps with Joomla. You can use Joomla to create the enterprise-class websites or web applications like online shop or e-commerce.

The number of Joomla users is growing quite rapidly. The Joomla project itself is 100% run by highly dedicated and vigorous volunteers who have a concern about the open source software development. Joomla periodically releases its newest version. All Joomla users are encouraged to do the update. There are reasons why you need to update your Joomla.

Security improvement.

As stated that Joomla is an open source CMS that uses PHP as its programming language and MySQL as its database. PHP and MySQL themselves are open source software. The weaknesses of most of the open source software are they may have the security gaps that can be found easily because their codes can be downloaded and learned by anyone. That is why open source software such as Joomla need to receive regular updates.

The usefulness of updating Joomla is to patch up the security gaps found in the previous version of Joomla. If you keep using the old version of Joomla and not updating it, you mean let the weaknesses of Joomla stay open to being attacked by the hackers. If so, your Joomla is in trouble. Joomla can become corrupted and you may lose all the useful data like user profiles, emails, and so on. Actually, the weaknesses of Joomla come not only from Joomla itself but also from PHP or database it uses.

Joomla that remains not updated may be vulnerable to the virus or malware attacks. This understanding is not different from the antivirus installed on your computer. The antivirus also needs to stay updated to keep all the software installed protected from the virus or malware. If you do want Joomla to avoid the virus or malware attacks, you need to pay attention to its security aspects.

Performance improvement.

Joomla is based on PHP and supports some databases. At the beginning of its emergence, Joomla may have a few issues related to its performance or other disturbances. The performance issues and disturbances will continuously be fixing. The completed fixes are then released again in the next Joomla version along with the new features and enhancements.

The next versions of Joomla certainly focus on improving the performance, implementing the new web technologies, and leveraging the new features of the software used. The Joomla development closely relates to the development of the software used. For example, Joomla 4 will raise the minimum PHP version to PHP 7. You can not install Joomla 4 if you use the previous version of PHP.

The use of PHP 7 in Joomla 4 is not without reason. The presence of PHP 7 brings many enhancements and functionalities. One of the big concerns is the significant increase in the execution speed. Of course, the good impact of using PHP 7 is not only on speed but also on security and stability. Some online articles stated that Joomla performance will rise 50% or more with PHP 7.

Utilizing the presence of new features.

Unlike the previous versions of Joomla, Joomla 4 brings many changes such as new user interface in the admin panel, code improvements, faster page loading time, SEO improvements, and many more. Joomla 4 also supports the use of the latest web technologies such as Bootstrap 4 and needs PHP 7 to run. By using the new features of the software used and utilizing the latest web technologies, Joomla will continue to exist and can compete with other CMS out there.

Therefore, you can no longer keep quiet with the old version of Joomla that continue to fall behind and are less able to adapt to the today's technological developments. You should benefit from the presence of the new features brought by Joomla. In other words, if you want to take advantage of the new features to ensure you can adapt to the current technological developments, you need to update to the latest version of Joomla.

How To Back Up Joomla Website Manually

2018-02-24T09:00:00.000-08:00

Backing up the Joomla websites on a regular basis is highly recommended. If you have the latest backup, you can feel calmer when something goes wrong on your Joomla website. Joomla is an open source CMS, meaning that the Joomla source codes can be downloaded for free, viewed, studied, or further developed. All open source CMSs are commonly vulnerable to the hacker attacks if the administrators of websites based on CMS platforms don't pay attention to its security factors.

The Joomla strength is in its extension support. Joomla has several kinds of extensions such as templates, modules, plugins, components, and languages. The extensions provide the additional power and functionality on the Joomla website. There are the free Joomla extensions or the commercial ones. The Joomla core extensions itself have been tested and checked however the free ones may have the security gaps that can be exploited by the hackers. The hackers can then do anything they want on your Joomla website.

The threats on the Joomla website not only come from the hackers, there are many bad things that can threaten. Not being careful in choosing the Joomla extensions and then install them can also cause the failures or malfunctions. When in use, the Joomla extensions damage your Joomla website. Doing the backup before installing the new extension is needed in case of a failure. If the problem arises when updating Joomla, you can use the backup to restore your Joomla website.

Joomla often gets regular updates when the new versions exist. You can find out any updates on the Joomla control panel. The Joomla official site always recommends to back up the Joomla website before you update. To back up the Joomla website, you can do it manually by backing up all of its files and databases. Here is how to do the backup of the Joomla website manually:

Backing up the files and folders on the Joomla website.

In the File Manager page, click the public_html folder as the root directory of your Joomla website. You will see all of your Joomla files and folders.

Click or check the box labeled Select All (1) to select all the files and folders and then click Compress button (2) to start backing up the files and folders.

In the Compress window that appears, select zip archive as compression type, change the name for the compression result file as you want (1) and then click Compress File(s) button (2).

After the compression process is complete, close the Compression Results window. In the public_html folder, find the compression result file (1) and then click the Download button (2).

In the Save As dialog box that appears, select the folder to save the downloaded file and then click Save button to start saving the file on your local computer.

Backing up the database used by the Joomla website.

In the Databases group, click phpMyAdmin button.

In the left pane of phpMyAdmin page, select the database of your Joomla website you want to back up and in the right pane, click Export button.

Make sure the radio button labeled Quick - display only the minimal options is selected (1), select SQL as the file format (2), and then click Go button (3).

In the Save As dialog box that appears, select the folder for the downloaded file and then click Save button to start saving the file on your local computer.

Database: Definition, types, and examples

2018-02-20T03:51:00.000-08:00

Database and DBMS

A database is a collection of data that is stored systematically inside a computer. Data in the database need to be processed or manipulated further using an application to generate the useful information. The database is an important aspect of the information system that acts as the warehouse to store data. The database can organize data, avoid duplicate data, avoid unclear data relationships as well as complex updates.

The process of retrieving data from and entering data into the database requires the software called DBMS. A DBMS is a software system that enables the database administrator (DBA) to maintain, control, and access data in a practical and efficient manner. In other words, the DBMS handle all the accesses to the database. The DBMS is a layer that connects the database and the application program to make sure that the database remains well organized and accessible easily.

The DBMS is responsible for handling several functions such as processing the data definition, handling user requests for data access, security checking and enforcing data integrity defined by DBA, handling the failure in accessing data and performance of all functions efficiently. The DBMS provides the abstract data review to the database users, so the system hides any information about how data is stored, maintained, and accessed efficiently.

Types Of Database

By type, the database can be divided into:

1. Flat-file Database.

The flat-file database is ideal for the small amount of data and easy to be changed. Basically, the flat-file database is a set of strings in one or more files that can be parsed to obtain the useful information. The flat-file database is suitable for storing simple lists or data in small amounts. The weakness of the flat-file database is vulnerable to the data corruption due to the absence of inherent locking and the data duplication that is difficult to avoid. One type of the flat-file database is CSV file.

2. Relational Database.

The relational database has a more logical structure if it relates to data stored. The relational database uses a set of two-dimensional tables which each table composes of rows and columns. The relationships between two or more tables require key attributes that are a primary key in one table and a foreign key in another table. Currently, the relational database is the best choice for data management.

Database Examples

The following are some of the most widely used databases today.

1. MySQL database.

MySQL is the most popular open source database for web-based applications such as dynamic websites or e-commerce. MySQL is one of the most widely used databases in the world and the first for the open source databases. MySQL was created in 1995 by Michael Widenius, David Axmark, and Allan Larsson. MySQL has become the database option that is efficient, trusted, and reliable. In 2000, MySQL platform changed to open source and followed the GPL provisions.

Many web applications use MySQL as their database solution and integrate it with PHP as an object-oriented scripting language. MySQL is also one of the important components of many web service solution stacks such as a LAMP, XAMPP, MAMP, WampServer, and AMPPS which are all the open source web development platform. If you create a website using a CMS like Joomla, Wordpress, or Drupal, this CMS also uses MySQL as its database solution.

In January 2008, Sun Microsystems acquired MySQL. In April 2009, Sun Microsystems and Oracle Corporation reached an agreement regarding the purchase of Sun Microsystems along with the copyrights and trademarks of MySQL by Oracle. In January 2010, Oracle acquired MySQL officially. Under the Oracle ownership, MySQL is available in double licenses, open source (GPL) and commercial.

2. Oracle database.

Oracle is a leading relational database owned by Oracle Corporation. Oracle is the best database for a commercial database version. Oracle itself is available in various configurations with customizable tool coverage for all company sizes ranging from the small to large-sized companies. Some people say that Oracle is considered better regarding its performance and scalability than other commercial databases.

The first version of Oracle was developed by Software Development Laboratories (SDL) in 1977 in which there was Larry Ellison, Bob Miner, and Ed Oates. In 1979, for the first time, the commercial version of Oracle database released. Now, the latest version of Oracle is Oracle 12c. The c in 12c stands for cloud computing that allows companies to manage their Oracle databases as the cloud services.

3. Microsoft SQL Server database.

From the name, you can easily guess who the owner of the database is. Microsoft is a giant software that is very famous for its software. Microsoft owns many types of software from operating systems, office application, antivirus applications, programming language suite, and also databases. Microsoft's database for enterprise-class is Microsoft SQL Server that is a commercial relational database. Unlike Microsoft Access database that has more limited features and runs on the desktop computers, Microsoft SQL Server supports a wide variety of transaction processing, business intelligence (BI), and analytics applications.

An early history of Microsoft SQL Server began when Microsoft and Sybase joined to develop a DBMS called Sybase SQL Server to compete with the existing databases such as IBM and Oracle. In 1989, Microsoft and Sybase released the first database. Sybase then sold the copyright to Microsoft and Microsoft renamed the database to Microsoft SQL Server.

Many companies run their computer servers using Microsoft Windows Server operating system. Microsoft SQL Server is certainly an option for Microsoft Windows Server because of having been integrated. Now, the latest version of Microsoft SQL Server is Microsoft SQL Server 2016. Microsoft SQL Server 2016 is available as the on-premises and cloud database platform and comes with the new features and enhancements that provide breakthrough performance, advanced security and reporting, and integrated analysis.

4. MariaDB database.

You may not hear much about this database. MariaDB is a fully open source relational database system. All of the MariaDB database source codes are under a GPL or an LGPL license. MariaDB is actually a fork of MySQL database. The fork here means another version of the MySQL standard. The developer of MariaDB was Michael Widenius who has left Sun Microsystems when acquired by Oracle.

The popularity of MariaDB continues to increase. The latest stable release of MariaDB is version 10.1 which is also known as MariaDB Enterprise 2016. In the latest stable release, MariaDB has much better protection by applying database security on every layer. MariaDB can detect and prevent attacks by using encryption, authentication, user roles, password validation, and security notification.

How To Prevent Installing Apps From Outside Microsoft Store In Windows

2018-02-18T08:41:00.001-08:00

Microsoft continually strives to make Windows 10 the perfect desktop operating system. In every major update of Windows 10, Microsoft always includes a number of new features and improvements. One of the new features in Windows 10 Creators Update that is still related to Windows security is a feature to prevent the installation of apps coming from outside Microsoft Store.

By default, this feature is disabled so Windows users can still install third-party desktop apps. If this feature is enabled, Windows users can only install apps from Microsoft Store. Microsoft Store provides Universal Windows Platform (UWP) apps. This type of apps is for all compatible Windows devices such as PCs, tablets, smartphones, or Xbox.

In addition to business factor, another reason that encourages Microsoft to add this feature is to prevent Windows from the risk of the malware and spyware attacks. Microsoft assumes that apps coming from outside Windows Store are not safe, unlike apps from Microsoft Store that have met the Microsoft specifications, have been tested and are safe to install on Windows devices.

Microsoft Store does not provide all apps that are required by Windows users. Therefore, this feature is only an option that can be turned on or off anytime. If your Windows computer is for regular use and is enough with the apps installed in it, it is time for you to enable the feature on your Windows computer.

Right-click the Windows button (1) to open WinX menu and then select Settings (2).

In the Windows Settings window that appears, select Apps (Uninstall, defaults, optional features).

In the Settings - Apps window, make sure you are in the Apps & features tab (1), in the Installing apps section, select Allow apps from the Store only from the drop-down list box (2).

Now if you try to install an application downloaded from the internet, a window will pop up informing you that the installation should only be for verified applications from the Store.

How To Change MySQL Root Password In WampServer

2018-02-15T06:31:00.002-08:00

A Website or another web app such as an online store or e-commerce is a special application that runs on a web server. To open the website page, you need to use a web browser such as Google Chrome, Mozilla Firefox, or Microsoft Edge. You first need to run your browser and then type the URL of the website page you want to visit in the address bar of the browser you use.

Generally, in creating or testing a new website, most people will choose to do on a local web server on their PC. This is to ensure whether the website has worked and run well as expected before it can be accessed online. You can turn your PC or laptop into a local web server. To create a local web server, you need to install software like Apache Web Server, PHP, MySQL, and phpMyAdmin and then configure them to connect to each other.

Configuring all software manually to create a local web server is not easy. It takes knowledge and understanding to do it right. An easier way is you can use a web application stack like WampServer. You no longer need to configure Wampserve because WampServer will be configured automatically during the installation process. After installation process of WampServer is complete, your computer has a local web server with software like Apache web server, PHP, MySQL, and phpMyAdmin installed.

WampServer is easy to install and use. By default, to access the MySQL server in WampServer, the username is root and the password is blank. The default settings of WampServer are quite risky. If you use a computer that is also used by others, you should do protection by giving a password to MySQL database. If other people also know WampServer, they will think that you are still using the default settings. Unbeknownst to you, that person can access an unprotected MySQL database and then do the things you do not want.

The default settings of WampServer are quite risky. If the computer you are using is also used by others, you should do protection by giving password for MySQL database. If other people also know WampServer, they can think that you are still using the default settings. Unbeknownst to you, that person can access an unprotected MySQL database and then do the things you do not want.

Protecting a MySQL database on a local web server of WampServer is also important to your new web project save. You need to prevent anything that could cause your project risk. Changing the root password of the MySQL database in WampServer is not difficult. You just write a little command through the MySQL console. If you want to do, here's how:

Run WampServer, click the Show hidden icons button (1), click the button with the WampServer logo (2), next select MySQL (3), and then select the MySQL console (4).

In the MySQL command line window that appears, press the Enter key without entering a password because, by default, MySQL root password is blank. Now you can directly access the MySQL server. To change the blank password by giving a new password, type SET PASSWORD FOR root @ localhost = PASSWORD ('admin345'); where admin345 is your new password for the MySQL root password (2), and then press Enter key.

Now every time you access MySQL server via the MySQL console, you need to enter password admin345.

How To Change Default Web Browser In Microsoft Windows

2018-02-13T18:50:00.005-08:00

If you are a Windows 10 user, there are two browsers in this operating system namely Microsoft Internet Explorer and Microsoft Edge. Microsoft Edge is a new browser that became the default browser to replace Microsoft's old browser, Microsoft Internet Explorer. Although Microsoft Edge is better than Microsoft Internet Explorer, for now, the feature is still limited, while Microsoft Internet Explorer itself has experienced failure and abandoned by its users.

Due to the limited features that are available in the Microsoft Edge, many Windows 10 users then install other browsers from the third-party provider such as Google Chrome, Mozilla Firefox, or Opera. Each browser has its own advantages and disadvantages such as a browser with support for multiple extensions, a browser with better performance, or a browser with more features. This is also a reason why a computer has more than one browser.

If your Windows 10 computer has more than one browser installed, one browser will be the default browser. When you click on a link in an email or perform an action that triggers a browser running, then Windows 10 will run this default browser. In Windows 10, If you never change the Windows settings for the default apps, your default browser is Microsoft Edge.

Everyone has their favorite browser or the most frequently used browser. You can turn your favorite browser into the default browser. There are several ways to change the default browser in Windows 10, for example, through Windows Settings or through the settings that exist in each browser setting. Here are the steps to change the default browser in Windows 10 using Windows Settings:

Access the WinX menu by right-clicking the Windows button located in the lower-left corner of the screen (1) and then choose Settings (2).

In the Windows Settings window that appears, click Apps (Uninstall, default, optional features).

In the Settings - Apps window that appears, make sure you have clicked the Default apps link (1), next click the default browser that is currently active (2), and then select the browser that you want as the new default browser (3).

How To Use Check Boxes To Select Multiple Files In Windows

2018-02-13T07:37:00.001-08:00

Microsoft Windows has a lot of hidden features that are not included in its standard operations. Most of the hidden features are rarely used or known by the Windows user. To use the hidden features, you often need to do the setting changes. One of the hidden features that Windows have is to select multiple files or folders with the help of check boxes.

You may not realize that the files or the folders in Windows File Explorer or dialog boxes can have the check boxes on their left side. The check boxes can give you an easy way to select the files or the folders in Windows File Explorer or dialog boxes. By checking the boxes on the left side of the files or the folders, it means that you have selected those files or folders. The check boxes can make the process of selecting multiple files or folders easier.

An example of taking advantage of the check boxes is when you want to open some program files like Microsoft Excel's files. If you use the normal way, you first need to press the SHIFT or CTRL key and then select the desired files. With the check boxes, you only need to check the box on left side of every file you want to open and then click the Open button on the Open dialog box. To activate the feature, here are the steps:

Click on Windows Cortana (1), type file explorer options in the search box (2), and then choose or click File Explorer Options (3).

In the File Explorer Options dialog box that appears, make sure you are in the View tab (1), check the box labeled Use check boxes to select items (2), click the Apply button (3), and then click the OK button (4).

Now you can check the boxes to select the files you want.

How To Generate A Laptop Battery Health Report In Windows

2018-02-12T06:58:00.001-08:00

A Battery is the most important part of a device like a laptop, a smartphone, or a tablet. Without the battery, you can not turn your device on especially if you take it out of the house. The battery is the power source for almost all devices. As you know, a laptop, a tablet, or a smartphone uses a rechargeable battery. If the battery power is exhausted, you must recharge it.

If you have a laptop that uses Windows 10 operating system, you can check the condition of your laptop battery with a simple and easy way. You just need to click a battery icon in the taskbar of your Windows 10 to get the information about the percentage of the battery power and approximate duration of usage. But if you want more information about it, Windows 10 also has a feature to generate the detailed report about the laptop battery.

The detailed report generated includes the concise information of the laptop, the installed battery, the current usage, the graph of the battery usage for 3 days, the battery history, the battery capacity history, the estimated battery life, and so on. The detailed report of the laptop battery can be generated with the powercfg command and the result is in the form of an HTML file. Then you can use your web browser to open this file.

Use Windows+X key combination to access the WinX menu (1) and then select Command Prompt (Admin) (2).

In the Administrator: Command Prompt window that appears, type the powercfg /batteryreport command (1) and then press the Enter key. This command creates the battery report in the form of the HTML file and saves it in the system32 folder (2).

Open File Explorer and then find the battery-report.html file. Double-click the file to open it in your default browser.

Now you can view the detailed report of your laptop battery.

How To Replace Windows PowerShell With Command Prompt In WinX Menu

2018-02-11T01:30:00.001-08:00

Loyal users of Microsoft Windows may already be familiar with the command-line application namely Command Prompt. However, In Microsoft Windows 10 Creators Update, you will not see Command Prompt on the WinX menu (Windows + X Menu). Microsoft has replaced Command Prompt with Windows PowerShell. As Command Prompt, PowerShell is also a command-line application that has better capabilities and flexibility.

PowerShell has advanced features that make it superior to Command Prompt like the remote execution of tasks, background tasks, task automation, command piping, and so on. When viewed on WinX Menu, PowerShell runs two modes namely Normal mode through Windows PowerShell and Administrator mode through Windows PowerShell (Admin).

For Windows users who are familiar with Command Prompt may be a bit confused. But it can be ascertained that anything that can be done in Command Prompt, can also be done in Windows PowerShell. So Windows PowerShell has the same functionality as Command Prompt but with additional enhancements. If you still want to use Command Prompt, you can still replace Windows PowerShell with Command Prompt.

Right-click in the empty area of the taskbar to display the shortcut menu and then choose Settings.

In the Settings - Personalizaton window that appears, you will be in the Taskbar tab (1). Set the toggle button labeled Replace Command Prompt with Windows PowerShell in the menu when I right-click the start button or press Windows logo key + X from On to Off (2).

Now every time you access the WinX menu (Win + X key combination) to use command line, you will find Command Prompt.

As Windows PowerShell, Command Prompt in Windows 10 Creators Update also runs two modes namely normal mode through Command Prompt and Administrator mode through Command Prompt (Admin). Running Command Prompt with Administrator access can grant access to all Windows system components.

How To Change Primary Language In cPanel

2018-02-09T17:02:00.002-08:00

If you have a website that is self-managed and has moved to the web hosting server, you are certainly familiar with cPanel. cPanel is a Linux-based web hosting control panel and widely used to manage the web hosting. cPanel offers a graphical interface (GUI) for easy administering as it has a lot of integrated auto features to simplify the process of managing the website on the web hosting server.

The default primary language of cPanel is English. If you never change the settings, you use this language in your cPanel. You can change this primary language to another language you want, for example, Indonesian. The cPanel administrative interface comes with support for multiple languages. Changing the cPanel primary language to another language is easy. You can take advantage of the Change Language button of the Preferences group in cPanel. Here are the steps you can follow:

Log in to your cPanel account, in the Preferences section, click Change Language button.

In the Change Language page, klik drop-down list box labeled Select a Language, choose a language you want from the list, for example Indonesian (Bahasa Indonesia) (1) and then click Change button (2).

Now your cPanel primary language has changed to Indonesian (Bahasa Indonesia).

How To Automatically Delete Browsing History In Microsoft Edge

2018-02-09T05:03:00.001-08:00

As a Microsoft Windows 10 user, you already have a default browser in it namely Microsoft Edge. Microsoft Edge is an easy-to-use, faster, more secure browser in Windows 10 and designed for the modern web. Most users of Microsoft Windows 10 no longer need to install the other browsers because they are quite satisfied with the Microsoft Edge performance.

Every time you browse the web, the URLs of the web pages you visit is saved by Microsoft Edge in the form of browsing history. The browsing history is actually useful. When you revisit the web pages you previously visited but have forgotten the URLs, you can make use of the browsing history saved.

But one of the drawbacks about the browsing history is that your privacy becomes distracted. If the computer you are using is also used by others, others will be able to see all the web pages you've visited. If you care about your privacy, you should delete your browsing history.

Deleting the browsing history in Microsoft Edge is easy. You also have an option to do it automatically. Every time you exit the browser, your browsing history will be automatically deleted for you. By default, this feature is not active. To activate this feature, you need to do setting change, here are how:

Open Microsoft Edge, click the Settings and more button located at the upper right corner (1), and then select Settings (2).

Scroll down to the Clear browsing data section (1) and then click the Choose what to clear button (2).

Check the check boxes whose data you want to clear (1) and then set the toggle button from Off to On (2).

How To Create Desktop Shortcuts For cPanel And Webmail

2018-02-08T04:47:00.000-08:00

If you have self-managed websites, you may often access cPanel or webmail. cPanel and webmail are two services that always relate to the website management. cPanel is a service to manage files and databases with a web-based graphical interface, while webmail is a service to send or receive messages via a web browser.

To access cPanel or webmail, you need a web browser. Accessing cPanel or webmail takes a few steps. You need to open the web browser first and then type the URL in the address bar of the browser to open cPanel or webmail page. Actually, there is a more practical way. You can create a desktop shortcut for cPanel or webmail and then use it.

A shortcut is a quick way to access a file, a folder, or an application. A desktop shortcut is an icon or a thumbnail that appears on the computer desktop. The shortcut icon for cPanel or webmail uses the icon of the default browser. When the desktop shortcut has finished creating, you just need to double-click it to open the cPanel or webmail page.

When you access cPanel or webmail via a desktop shortcut, the default browser automatically launches and directly opens the cPanel or webmail page. Creating desktop shortcuts for cPanel and webmail is not a difficult task. cPanel provides features for this purpose. Here are the steps:

First log in to your cPanel account, in the Preferences group, click the Shortcuts (icon) button.

On the next page, you can see two links. The first link, Access cPanel, is used to create a desktop shortcut for cPanel, while the second link, Access cPanel Webmail, is used to create a desktop shortcut for webmail.

To start creating a desktop shortcut for cPanel, drag the cPanel Access link to the computer desktop area and then release. The desktop shortcut created uses the default browser icon with label Access cPanel. You can create a desktop shortcut for webmail in the same way.

Now, you have two additional desktop shortcuts, one for cPanel and one for webmail.

How To Repair Or Reset Microsoft Edge Browser

2018-02-05T23:29:00.001-08:00

Microsoft Edge is a default browser included in Microsoft Windows 10 to replace Microsoft Internet Explorer. Microsoft Edge was created and designed as a browser that is easier to use, faster, more secure for Microsoft Windows 10 and designed for the modern web. Microsoft continues to provide updates and improvements to the browser along with the major updates of Microsoft Windows 10.

Recently, Microsoft Edge again received updates along with major update of Windows 10 to Fall Creators Update (version 1709). In Windows 10 Fall Creators Update, one of the new features added to Microsoft Edge is the presence of the Repair and Reset buttons. You can use the Repair button if Microsoft Edge is not working properly. If the problem persists, you can use the Reset button.

As the browser in general, Microsoft Edge is not always in its best performance. You may notice some annoying issues such as Microsoft Edge can not be opened, run slow, shut down by itself, and so on. You can use the Repair or the Reset button to fix any problems that arise. This is Microsoft's answer to the users request to provide repair option. Thanks to Microsoft.

To use the Repair and Reset buttons, right-click the Windows button located in the lower left corner of the screen to open WinX Menu (1) and then select Settings (2).

In the Windows Settings window that appears, select Apps (Uninstall, defaults, optional features).

In the Settings - Apps window that appears, click Apps & features (1), click Microsoft Edge (2), and then click Advanced options (3).

Now, you can see the Repair (1) and Reset (2) buttons ready to use.

How To Open Edge Browser From Run Dialog And Command Prompt

2018-02-05T16:08:00.001-08:00

Microsoft Edge is a new browser that is included in Microsoft Windows 10 to replace Microsoft old browser, Microsoft Internet Explorer. You can run or open Microsoft Edge in several ways such as through Task Manager or Start Menu. Most Windows users use the Microsoft Edge icon located in the Task Manager to run it. This is the most practical and fastest way to do it.

You can also try a slightly different way by using a Run dialog or a Command Prompt window. The Run dialog and the Command Prompt window are Microsoft Windows built-in applications. Both of those applications can provide quick access to computer resources such as programs, folders, documents, and so on. Many Windows users use them to run or open other programs. If you want to run or open Microsoft Edge using one of those applications, here's how:

1. Open Microsoft Edge from Run dialog.

Use the Win + R key combination to open the Run dialog box, type microsoft-edge:// (1) and then click the OK button (2).

You can also type microsoft-edge: (1) and then click the OK button (2).

2. Open Microsoft Edge from Command Prompt.

Use the Win + R key combination to open the Run dialog box, type cmd (1) and then click the OK button (2).

In the Command Prompt window that appears, type microsoft-edge start: and then press Enter.

You can also include an URL to open a webpage directly on Microsoft Edge by typing microsoft-edge start:https://www.wideitzone.com.

How To Find Computer Name In Microsoft Windows

2018-02-05T01:58:00.001-08:00

Ordinary users of Microsoft Windows may not care too much about a computer name. Most users do not know that a computer has a name. The computer name is assigned during the first computer setup process. The computer name must be unique if it becomes a part of the network. When there are one or more computers on the network that have the same computer names, problems can arise.

The computer name becomes very important when problems arise on the network. Network engineers will need the computer names that are part of the network to solve the problem. By telling your computer name to the network engineer, it will help accelerate the handling of network problems that occur. If you do not know how to find your computer name, here's how:

1. Using Command Prompt.

Use the Win + R key combination to open the Run dialog box, type cmd (1) and then click the OK button (2).

In the Command Prompt window that appears, type hostname and then press Enter. Now you find your computer name.

2. Through System Properties.

Use the Win + R key combination to open the Run dialog box, type sysdm.cpl (1) and then click the OK button (2) to open the System Properties dialog box.

In the System Properties dialog box that appears, you can find your computer name.

3. Through Windows Settings.

Right-click on the Start button located at the bottom left corner (1) and then choose System (2).

On the Settings - System page that opens, you can find your computer name.

How To Find IP Address Of A Domain Using Command Prompt In Windows

2018-02-04T04:51:00.001-08:00

When associated with sites, an IP address is a series of numbers, for example, 119.234.255.43 that a visitor should use to visit a site. You can imagine what if the visitor must remember the IP address of your site and also the IP addresses of the other sites. They will not be able to remember many IP addresses of many sites and need a note to remember more.

Because of the difficulty to remember the IP addresses, then Domain Name System (DNS) is introduced. DNS allows visitors to access the site using a name that is easier to remember by humans. The name in question is the domain name. For example, you will easily access a site using its domain name "termasmedia.com" instead of using its IP address like "119.234.255.43".

The domain name gives an easy way to visit the site, while the address of the site you visit still uses the IP address. Mapping the domain name to the corresponding IP address becomes a DNS task. But if you want to know the IP address of a particular domain, you can use Windows Command Prompt. Here are the steps:

Use the Win + R key combination to open the Run dialog box, type "cmd" (1) and then click the OK button (2).

In the Command Prompt window that appears, type "NSLOOKUP domain-name", for example "NSLOOKUP termasmedia.com" (1) and then press Enter. Now you can see the IP address for the domain name (2).

In addition to using the NSLOOKUP command in Windows Command Prompt, there are quite a number of online converters that you can use, such as tools.keycdn.com, domaintoipconventer.com, whatismyipaddress.com, and so forth.

How To Show Hidden Files In cPanel

2018-02-03T23:04:00.000-08:00

If you create a blog or a website using a CMS like Joomla, there is a file called htaccess.txt in the Joomla installation result. For the sake of Joomla SEO, you need to change htaccess.txt to .htaccess. You can find the htaccess.txt file in the root directory of your primary domain that is the public_html directory. In the Apache document root, the htaccess.txt will be detected and executed by Apache web server.

When the Joomla update happens, Joomla will add back the htaccess.txt file to the public_html directory. This addition doesn't cause issues because the existing htaccess.txt file has renamed to .htaccess. In cPanel, files starting with a period (.) are hidden files by default such as .htaccess, .htpasswd, and .bashrc. The files are made hidden to avoid deletion accidentally. If needed, you can also create your own hidden file and add it to your website.

The latest version of cPanel uses Paper Lantern as its default theme. Paper Lantern is a modern responsive theme that comes to replace the cPanel old theme, X3. With its Paper Lantern theme, you can access the cPanel interface more conveniently. There are not many changes to the existing features. Displaying the hidden files is also still the same. You just need to take advantage of the Settings button located at the upper right corner. Here are the steps to do:

Log in to your cPanel account, in the FILES group, click the File Manager button.

In the upper right corner of the File Manager page, click the Settings button.

In the Preferences window that appears, check the check box labeled Show hidden files (1) and then click the Save button (2).