Troubleshooting issues in Oracle, RedHat Linux, Windows and lot more!.

What You Need: A USB flash drive with good storage capacity; preferably 4GB or more. Access to a computer running Windows Vista or Windows 7. A CD or DVD containing software you want to download. Getting Started: Connect the USB flash drive to a computer running Windows Vista or 7 and follow the steps below: Click Start > All Programs > Accessories > Right click on Command Prompt > Run as Administrator Type ‘diskpart' and press Enter to start the built in Windows disk partitioning utility  Type 'list disk' and press Enter. Identify your USB Flash drive and make a note of the disk number.  Here in this example, My USB flash drive is Disk 1.  Type 'select disk 1' and press Enter.   Type ‘clean’ and press Enter. The clean command will remove partitions or volume formatting from the selected disk (disk 1) by zeroing sectors.  Now to create a partition, type 'create partition primary’ and press Enter.  Type 'select partition 1',

Do you know the Red Hat File system directories and its usage ? Below are the list of the primary Red Hat Enterprise Linux system directories: /bin/ — Used to store user commands. The directory /usr/bin/ also stores user commands. /sbin/ — Location of many system commands, such as shutdown. The directory /usr/sbin/ also contains many system commands. /root/ — The home directory of root, the superuser. /misc/ — This directory is used for automatically mounting directories on removeable devices (such as Zip drives) and remote directories (such as NFS shares) usingautofs. Refer to the autofs manual page (type man autofs at a shell prompt) for more information. /mnt/ — This directory typically contains the mount points for file systems mounted after the system is booted. /media/ — This directory contains the mount points for removable media, such as diskettes, CD-ROMs, and USB flash drives. /boot/ — Contains the kernel and other files used during system startup. /lost+foun

If you are new to Windows Server 2008, then you are probably wondering why you are getting “Permission Denied” errors when attempting to even open your C drive folder. To help prevent malicious software from silently installing and causing computer-wide infection, Microsoft developed a feature called User Account Control. To get around these errors, you can simply disable the “User Account Control: Run all administrators in Admin Approval Mode” security option. To disable this feature, follow these steps, or simply let us know and we will take care of it for you: Turning off UAC Use the following procedure to disable UAC entirely. To perform the following procedure, you must be able to log on with or provide the credentials of a member of the local Administrators group. Important: Turning off UAC reduces the security of your computer and may expose you to increased risk from malicious software. Microsoft does not recommend leaving UAC disabled. To turn off UAC Click Star

How to retrieve the Local Date and Time in sql server ? A common task in SQL Server is the retrieval of the local date and time from the server. Usually, it is more appropriate for a database-linked application to obtain the time from the server than from the local machine, as this ensures that all users are using the same basis for the time. If a user's local clock is set incorrectly, the use of the server's clock ensures that an invalid date or time is not stored. Using the CURRENT_TIMESTAMP SQL Server defines a value named CURRENT_TIMESTAMP. This value can be included in aquery using a select statement or can be assigned to a DateTime variable to obtain the current local time. To demonstrate, try the following statements using a SQL Server Management Studio query window. The first will output the local time to the results window, the second will hold the time in a variable before printing the variable's value in the messages window. NB: When the current date

Ever since SQL Server 2005 was released, each object in a database has belonged to a database schema. SQL Server 2008 has continued with database schemas, and an explanation follows. What is a Database Schema? A database schema is a way to logically group objects such as tables, views, stored procedures etc. Think of a schema as a container of objects. You can assign a user login permissions to a single schema so that the user can only access the objects they are authorized to access. Schemas can be created and altered in a database, and users can be granted access to a schema. A schema can be owned by any user, and schema ownership is transferable. Creating a Database Schema To create a database schema in SQL Server 2008: Navigate to  Security > Schemas Right click on  Schemas  and select  New Schema... . Like this: Complete the details in the  General  tab for the new schema. In this example, the schema name is "person" and the schema owner is "Homer

In order to set the run oracle SQL*Plus client and the other oracle binaries ORACLE_HOME environment variable path should be set which defines the path of Oracle Home[server] installation directory of the windows server. Follow the below steps to set the ORACLE_HOME path in windows server, c:\> Set ORACLE_HOME= C:\oracle\product\11.2.0\ - where [C:] defines the install drive letter How to check the Oracle environment variable set in windows server ? C:\> echo %ORACLE_HOME% - will display the path of oracle home

How to install SQL Server 2008 R2 ? Applies to: SQL Server 2008 R2 November CTP. An evaluation copy of SQL Server 2008 R2 can be downloaded from  here . If you are upgrading to SQL Server 2008 R2, consider these resources and recommendations: Read about supported upgrade scenarios  here . Download and run SQL Server Upgrade Advisor. Upgrade to the same language version as the existing instance of SQL Server. The following are some recommendations before installing SQL Server 2008 R2: Use NTFS file system. Do no try to install SQL Server 2008 R2 on a compressed drive, because setup will block the installation. Do not install SQL Server on a Domain Controller. Click  here  for more information. Configure your firewall to allow SQL Server access. Click  here  for more information about protocols and port numbers. The user account that is running SQL Server Setup must have administrative privileges on the computer. Verify Windows Management Instrumentation service (C