SQL Interview Questions

What is Database engine?
The Database Engine is the core service for storing, processing, and securing data.
What is Quorum Disk?
In the event of failure, Windows Clustering maintains a primary node, and replicates changes for the cluster registry by means of a shared disk. The cluster registry is stored in the following location on each node: %SystemRoot%\Cluster\Clusdb
What is MS DTC Service?
The Microsoft Distributed Transaction Coordinator (MS DTC) is a transaction manager that coordinates the proper completion of the distributed transaction to ensure that either all of the updates on all the servers are made permanent, or, in the case of errors, all erased.

Read More

Windows 7 Deployment using MDT ( Microsoft Deployment Tool kit 2010)

How to Deploy Windows 7 using MDT
Open Deployment work bench and create a deployment share  as Windows 7 and finish the wizard. 
After creating the deployment share start adding the content.
Create a folder windows 7 and next finish
Right click on windows 7 folder  and  select import operating system and next select full setup source file  and select the ISO image of windows 7 and provide the descripted name and click finish.
If would like add application go to applications create a folder and give the name and if you want to add acrobat reader and version and select the Source directory of Adobe application
From the command line installation enter the command line installation path.
Now select the Task sequence and create the folder and name it as windows 7 right click on windows 7 and enter task sequence id and name of the task  
Select Standard template and select the OS sequence that we have added. If you have KMS  server no need to enter product key and set the admin account and password and finish
Now right click on OS sequence and properties and select Task sequence and set the required information and if you have to inject the drivers you can add. If you want install applications we if we want we can add applications.
After adding   OS, you need update deployment share create a boot image . to do this right click on Deployment share and click on update deployment share. And finish the wizard.
After completing the update, if we go to boot folder we can see different boot images. And select the light touch ISO file.
To install the OS boot the computer with  light touch boot image ISO file and default deployment wizard will click on run and create login account and select the sequence.
Capture WIM image using MDT tool?

Create a Task sequence and  enter task id and sequence name 
In task sequence Template and  select the Sysprep and capture in the OS dialogue box 
We select existing OS that we have created earlier, provide user name and password and click finish
Now Go to MDT share  and go to scripts folder and run Bbb.autorun  file and select sysprep and capture image option.
Click next  and select capture and image the reference computer button  and enter the creditentials to access network share. And sysprep will run to generalize the machine. and imagex will run to capture the image. And the image file will be captured.

Read More

Storage Interview Questions

What is the difference between Zoning and LUN masking?
Zoning:
Zoning controls access from one node to another. Zoning lets you isolate a single server to a group of storage devices or a single storage device, or associate a grouping of multiple servers with one or more storage devices, as might be needed in a server cluster deployment.
Zoning is implemented at the hardware level (by using the capabilities of Fibre Channel switches) and can usually be done either on a port basis (hard zoning) or on a World-Wide Name (WWN) basis (soft zoning).
Lun Masking: 
LUN masking, performed at the storage controller level, allows you to define relationships between LUNs and individual servers
RAID 0 (Striping): This setup increases hard-drive performance by splitting, or striping, data across two drives.  RAID 0 provides no data protection
RAID 1 (Mirroring): A RAID 1 setup protects data from drive failure by simultaneously writing the same data to two hard drives. 
RAID 5 (Distributed Parity): It requires a minimum of three hard drives. Instead of using an entire hard drive as a backup, RAID 5 spreads redundancy information--called parity bits--across all of the array's drives. When one of the drives in a RAID 5 array fails, the data content of that failed drive is reconstructed using the parity bits on the surviving drives and written to a new, replacement drive. 
RAID 1+0, 0+1, 10: Some adapters combine (referred to as nesting) RAID 0 and RAID 1 to provide both data redundancy and increased disk performance. This works by either striping data across a pair of drives then mirroring (0+1) them with another pair, or striping data across two mirrored pairs (1+0, aka 10). RAID 0+1, 1+0, and 10 require a minimum of four hard drives.

Read More

Windows Server 2008 R2 Failover Cluster

The minimum requirements to create a Windows Server 2008 R2 Cluster:
Two or more compatible servers
A shared storage
Two network cards on each server
Windows Server 2008 R2 Enterprise or Datacenter Editions
Install Failover Cluster feature and run cluster validation
1. In “Server Manager”, access “Features” and select “Failover Cluster”.
2. Select “Validate a Configuration”.
3. In the new wizard, we are going to add the hosts that will represent the Failover Cluster in order to validate the configuration. Type in the server’s FQDN names or browse for their names; click on “Next”.
4. Select “Run all tests (recommended)” and click on “Next”.

Create Windows Server 2008 R2 Failover Cluster
 1. In the “Failover Cluster” console, select the option for “Create a cluster”.
2. The first thing to do is add the servers we would like to cluster; click on “Next”.
3. we have to select the cluster name and the IP address assigned. Remember that in a cluster, all machines are represented by one name and one IP.
4. After a few seconds the cluster will be created .

Read More

IIS Interview Questions..

What is Application Pool?
you can separate different Web applications and Web sites into groups known as application pools.
What is Virtual Directory?
A virtual Directory is a directory that is not contained in the home directory but appears to client browsers as though it were
what is the difference between IIS6 and IIS7

New Admin tools

Integrated form-based authentication

Integrated ASP.NET and IIS authentication

shared configuration
automatic application pool isolation
Improved FTP service
good performance and more security 
What is ISAPI?
Internet Server Application Programming Interface, is an API developed to provide the applications developers with a powerful way to extend the functionality of IIS.
What is metabase?

IIS metabase is a special databse which maintains the settings and configuration data for IIS.

IIS logfile format w3svc

%system root%/system32/logfiles

What debugging tools do you use for IIS?
Debugdiag.msi
How to host multiple websites on IIS server?
Web sites hosted on the same server can be distinguished using any one of the following unique identifiers.
Host header name
IP address
TCP port number
Using host header names to uniquely identify sites on a server is recommended for most situations.

Read More