emp table script SQL Server

Standard emp table script for SQL Server

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

Stop Sybase server

system administrator can shut down an SAP ASE.


shutdown [srvname] [with {wait [=”hh:mm:ss”] | nowait}]]

Stop Sybase backup server

If we want to stop only Sybase backup server or it is best practice to stop backup server first then, ASE server.

We can stop backup server using following ‘shutdown SYB_BACKUP’

1> shutdown SYB_BACKUP
2> go
Backup Server The Backup Server go down immediatley. Terminating sessions.

Install xampp on windows

XAMPP stands for Cross-Platform (X), Apache (A), MariaDB (M), PHP (P) and Perl (P). It is a simple, lightweight Apache distribution that makes it extremely easy for developers to create a local web server for testing and deployment purposes. XAMPP is an easy to install Apache distribution containing MariaDB, PHP, and Perl. Just download and start the installer. It’s that easy.

Install xampp on windows 7 Step by Step:

1. Download xampp by clicing Download link.

How to Create Virtual Machine

Virtual machine (VM) is an emulation of a computer system. Virtual machines are based on computer architectures and provide functionality of a physical computer. Their implementations may involve specialized hardware, software, or a combination.

How to get list of users in Linux

The /etc/passwd file is used to keep track of every registered user that has access to a system. Sometimes, we want to know the list of local users. If we want to get list of users in terminal, run below command.

cut -d: -f1 /etc/passwd

If we want to save this output in file, then run following command on terminal.

cut -d: -f1 /etc/passwd > userslist.txt

How to get the Syntax of PowerShell Cmdlet

To view the syntax of a PowerShell Cmdlet, use get-command or help command.

Get Syntax using Get-Command Cmdlet:

Get-Command Get-Process -Syntax



Difference between Blob Storage and File Storage in Azure

File Storage:
The File storage offers cloud-based SMB file shares, if we are porting an existing application that needs to share files then use Azure File Service. File share up to 5TB capacity limit.

Blob Storage:
If we are developing a new application, you should leverage the native Azure API directly into Blob Storage, in this scenario we can use blob storage, because the blob storage up to the 500 TB capacity limit. Blobs are cheaper and have less limitations.

Powered by k2schools