Difference between Local User and Domain User

Local User:

  1. In Windows, a local user is one whose username and encrypted password are stored on the computer itself.
  2. A user account created in local database of a computer.
  3. Local Users are generally used in WORKGROUP model.
  4. Local Users can login only on the respective computer.

How to assign IP address in Windows

Every operating system will assign IP address at the time of OS installation. If we want to set IP address as your wish, follow the below steps.

To check current IP address of your machine open Command prompt or PowerShell, then run ipconfig

Convert Windows Core to Windows Server GUI

From Windows 2008, installations are two types: Server with GUI(full installation) and Server Core. From Windows 2012, it is also possible to convert Windows Server GUI to Core and Windows Server Core to GUI. Windows Core version had less features than Windows GUI(full installation). To change GUI to core or Core to GUI, user should login with administrator privileges.

Convert Windows Core to Windows Server GUI

Convert Windows Server GUI to Core

From Windows 2008, installations are two types: Server with GUI(full installation) and Server Core. From Windows 2012, it is also possible to convert Windows Server GUI to Core and Windows Server Core to GUI. Windows Core version had less features than Windows GUI(full installation). To change GUI to core or Core to GUI, user should login with administrator privileges.

Convert Windows Server GUI to Core Using PowerShell

This host supports intel vt-x but intel vt-x is disabled

This host supports intel vt-x but intel vt-x is disabled

This host supports intel vt-x but intel vt-x is disabled

By default, virtual technology is disabled. This can be enabled at hardware level. If this is disabled, we can not install virtual machines.

Enable intel vt-x:

NameError: name ‘raw_input’ is not defined

Traceback (most recent call last):
File “<pyshell#0>”, line 1, in
first_name=raw_input()
NameError: name ‘raw_input’ is not defined
 

NameError name 'raw_input' is not defined

Reason:

emp table script PostgreSQL

Standard emp table script for PostgreSQL

1) Create table structure
2) Insert data into emp table

Differences between where and having clause

WHERE: Where clause is used to filter the data based on condition. Only rows that meets conditions contribute data to the result set.
Filters rows
Where clause is executed before group by clause.
Use where clause, if there is no aggregate function in condition.

Table definition in SQL Server

If we want to see the table definition in SQL Server, then we can get using sp_help procedure.

Syntax:

sp_helptext [ @objname = ] ‘name’ [ , [ @columnname = ] computed_column_name ]

Powered by k2schools