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

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